Subject javax.resource.ResourceException: couldn't start local transaction
Author Carsten Schäfer
Post date 2002-08-14T07:26:10Z
Hi,
I'm using the latest (last week) src from the type4 java-Driver. (Firebird 1.0,Win2000SP3,JDK1.3.1_04)
I' have only local connections and I'm using the same connection for a long time.
After some time of corrrect work i got the follwing exception with a call of connection.prepareStatement("Insert Statement")
java.sql.SQLException: ResourceException: javax.resource.ResourceException: couldn't start local transaction: javax.transaction.xa.XAException
 at org.firebirdsql.jdbc.FBConnection.ensureInTransaction(FBConnection.java:894)
 at org.firebirdsql.jdbc.FBPreparedStatement.<init>(FBPreparedStatement.java:79)
 at org.firebirdsql.jdbc.FBConnection.prepareStatement(FBConnection.java:188)
 
After that error i always get the following while calling the same insert statement:
ava.sql.SQLException: ResourceException: javax.resource.ResourceException: local transaction active: can't begin another
 at org.firebirdsql.jdbc.FBConnection.ensureInTransaction(FBConnection.java:894)
 at org.firebirdsql.jdbc.FBPreparedStatement.<init>(FBPreparedStatement.java:79)
 at org.firebirdsql.jdbc.FBConnection.prepareStatement(FBConnection.java:188) 
 
 
Generally i often get errors with the exception saying that local transaction is active.
But I'm sure that my code is correct because with other drivers (Interclient) I've never seen these errors.
 
 
gruß
Carsten Schäfer