Subject Re: [Firebird-Java] Re: Active Transaction in Autocommit-Mode ?
Author Carsten Schäfer
I don't have access o the cvs directory,
can someone send me an actual binary or post it 2 the file-section at yahoo-groups ?
 
mfg
Carsten 
----- Original Message -----
Sent: Thursday, October 30, 2003 10:05 AM
Subject: [Firebird-Java] Re: Active Transaction in Autocommit-Mode ?

Hi,

> I'm getting the following exception:
> java.lang.IllegalStateException: Can't destroy managed connection 
> with active transaction
> ...
> when closing a connection.
> My problem: this connection is only used in autocommit mode (only
> read-connection), so i thought i don't have to commit explicit.

No, you are not allowed to use commit in auto-commit mode. This is a
bug in the driver.

> I think this only happens when i use the same connection from
> different threads (but with no other sql-error).

Simultaneously? JayBird 1.0.x is not thread-safe and you should avoid
using the same connection from multiple threads simultaneously.

> Why is this happening ?

Bug. It would be great, if you could try version of the driver from
the CVS. I think I have fixed this bug there.

Best regards,
Roman Rokytskyy