db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Bernt Marius Johnsen <bernt.john...@oracle.com>
Subject Re: Closing connection result with exception
Date Fri, 11 Feb 2011 10:16:28 GMT
Egidijus Vaisnora wrote:
> Hello All,
>     I am using Embedded Derby and whenever I attempt to close connection 
> I got "Cannot close a connection while a transaction is still active." 
> error.
>     I am using Derby 10.5.3. I found that in Derby in release 
> notes there is a note about DERBY-3319, which states that "Users must 
> call commit() or rollback(), or use auto-commit, before attempting to 
> close a connection with uncommitted operations." But I am executing just 
> "select" statement, do I still need to call rollback or commit?

A select statement will open an transaction which needs to be committed 
or rolled back.

> P;ease, advice,

View raw message