db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "TomohitoNakayama" <tomon...@basil.ocn.ne.jp>
Subject Re: conn.rollback in Database#close() even though there are either conn.commit in Database#commit() and conn.rollback in Database#rollback()
Date Tue, 05 Jul 2005 14:22:22 GMT
Hello.

I followed myself.

>I understood that we need to make connection to inactive state calling 
>conn.rollback() or conn.commit() before conn.close()

In this sentence , "we" means user of Derby

Best regards.

/*

         Tomohito Nakayama
         tomonaka@basil.ocn.ne.jp
         tomohito@rose.zero.ad.jp
         tmnk@apache.org

         Naka
         http://www5.ocn.ne.jp/~tomohito/TopPage.html

*/
----- Original Message ----- 
From: "TomohitoNakayama" <tomonaka@basil.ocn.ne.jp>
To: "Derby Development" <derby-dev@db.apache.org>
Sent: Tuesday, July 05, 2005 11:16 PM
Subject: conn.rollback in Database#close() even though there are either 
conn.commit in Database#commit() and conn.rollback in Database#rollback()


> Hello.
>
> Chasing DERBY-397,
> I again came to have question why connection was rollbacked in 
> Database#close().
>
>
> I understood that we need to make connection to inactive state calling 
> conn.rollback() or conn.commit() before conn.close()
>
> However ,
> if user execute commit or rollback properly before closing session,
> it seems that Database#commit() or Database#rollback() was called and
> responding conn.commit() or conn.rollback() are called,
> and transaction becomes inactive and is possible to close.
>
> Else if user did not execute neither commit nor rollback before closing 
> session,
> transaction stays active and is just impossible to close , failed closing 
> connection.
>
> In both case, we don't need to call rollback in Database#close().
>
>
> Does Database#close() have something to do with case that session was 
> closed by accident ?
> Or are there something to do with multiple database connected in single 
> session ?
>
>
> Best regards.
>
>
> /*
>
>         Tomohito Nakayama
>         tomonaka@basil.ocn.ne.jp
>         tomohito@rose.zero.ad.jp
>         tmnk@apache.org
>
>         Naka
>         http://www5.ocn.ne.jp/~tomohito/TopPage.html
>
> */
>
>
> -- 
> No virus found in this outgoing message.
> Checked by AVG Anti-Virus.
> Version: 7.0.323 / Virus Database: 267.8.9/39 - Release Date: 2005/07/04
>
>
>
>
> -- 
> No virus found in this incoming message.
> Checked by AVG Anti-Virus.
> Version: 7.0.323 / Virus Database: 267.8.9/39 - Release Date: 2005/07/04
>
> 



-- 
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.323 / Virus Database: 267.8.9/39 - Release Date: 2005/07/04


Mime
View raw message