Subject Commit fails if nothing has been done since last commit
Author Erik Erskine
I'm getting the following error if I try and commit a transaction when
nothing has been done since the last commit/rollback.

The code looks like this:

// sql operations
con.commit(); // works fine
con.commit(); // fails

The exception is:

java.sql.SQLException: javax.resource.ResourceException: couldn't commit
local transaction: javax.transaction.xa.XAException
at org.firebirdsql.jdbc.FBConnection.commit(

What I have done works fine with Interclient, is this valid SQL? If
not, is there an easy way to test whether a commit/rollback is necessary?



| Erik Erskine erik@... |
| Sundayta Ltd |