Hi,

I've been having a problem with setAutoCommit(false) failing sporadically on
what seems to be a valid connection.

I'm using FBWrappingDataSource with pooling turned on. I downloaded and
compiled the most recent snapshot of the driver but the problem is still
there.

I get the following error:

java.sql.SQLException: javax.resource.ResourceException: no local
transaction active: can't commit
at org.firebirdsql.jdbc.FBConnection.setAutoCommit(FBConnection.java:339)

I get this when I do the following:

c = fbwds.getConnection();

if (c != null)
c.setAutoCommit(false);

getConnection does not throw an error and the connection is non-null;

In fact I can comment out setAutoCommit(false) and the connection can read
the database flawlessly.

What is weird is that most of the time the setAutoCommit(false) works fine.

Any clues?

Rick