db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Sakthivel.P" <p.sti...@gmail.com>
Subject Re: Closing connection result with exception
Date Fri, 11 Feb 2011 11:54:51 GMT
refer this
http://db.apache.org/derby/docs/10.4/devguide/cdevconcepts29416.html

default auto commit is set true. if its turned off, need to commit
explicitly.

http://db.apache.org/derby/manuals/tools/tools46.html

regards
Sakthivel

On Fri, Feb 11, 2011 at 4:52 PM, Egidijus Vaisnora <
egidijus.vaisnora@nomagic.com> wrote:

>
> I have updated derby but still the same. Issue DERBY-3806 covers problem
> when ResultSet was not closed, however I am closing ResultSet, prepared
> statement and then connections. What I am not doing is commit either
> rollback calls - jsut because I am executing SELECT statement. Do I need to
> call "commit" or "rollback" in any case before "close", even if I am using
> SELECT statement and I am closing opened ResultSet and prepared statement?
>
> --
> Egidijus
>
> On 2/11/11 12:10 PM, Sakthivel.P wrote:
>
>> 10.7.1.1 <http://db.apache.org/derby/releases/release-10.7.1.1.cgi> is
>> latest version. Please download and use.
>>
>>
>> http://db.apache.org/derby/derby_downloads.html
>>
>> refer this issue for more details
>> https://issues.apache.org/jira/browse/DERBY-3806
>>
>> - Sakthivel
>>
>> On Fri, Feb 11, 2011 at 3:32 PM, Egidijus Vaisnora <
>> egidijus.vaisnora@nomagic.com <mailto:egidijus.vaisnora@nomagic.com>>
>> 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 10.5.1.1 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?
>>
>>    P;ease, advice,
>>    --
>>    Egidijus
>>
>>
>>

Mime
View raw message