Subject Re: Active Transaction in Autocommit-Mode ?
Author Roman Rokytskyy
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