Subject | Re: Unrecognized transaction problem |
---|---|
Author | bullitenergy |
Post date | 2004-10-24T00:59:32Z |
Hey Roman,
I have little CVS exerience, so i changed your code somewhat from its
webview at:
http://cvs.sourceforge.net/viewcvs.py/*checkout*/f
irebird/client-java/src/test/org/firebirdsql/jdbc/
TestFBPreparedStatement.java?rev=1.15.
Your code does not add the PRIMARY KEY to the table and does no insert
(i think). I have added the lines in setUp:
stmt.executeUpdate(CREATE_UNRECOGNIZED_TR_TABLE);
stmt.executeUpdate(ADD_CONSTRAINT_T1_C1);
stmt.executeUpdate(INIT_T1);
(The SQL in INIT_T1 is invalid, change the dot into a comma)
And i get an exception thrown in your testcase however at the
connection.close(), see below.
I hope this helps!
Best Regards!
Bullit Energy
---
Exception in thread "main" org.firebirdsql.jdbc.FBSQLException: GDS
Exception. 3
35544327. invalid request handle
at
org.firebirdsql.jdbc.AbstractStatement.close(AbstractStatement.java:2
48)
at
org.firebirdsql.jdbc.AbstractConnection.freeStatements(AbstractConnec
tion.java:107)
at
org.firebirdsql.jdbc.AbstractConnection.close(AbstractConnection.java
:418)
at
TestFBPreparedStatement.testUnrecognizedTransaction(TestFBPreparedSta
tement.java:563)
at TestFBPreparedStatement.main(TestFBPrep
aredStatement.java:570)
at org.firebirdsql.gds.GDSException: invalid request handle
I have little CVS exerience, so i changed your code somewhat from its
webview at:
http://cvs.sourceforge.net/viewcvs.py/*checkout*/f
irebird/client-java/src/test/org/firebirdsql/jdbc/
TestFBPreparedStatement.java?rev=1.15.
Your code does not add the PRIMARY KEY to the table and does no insert
(i think). I have added the lines in setUp:
stmt.executeUpdate(CREATE_UNRECOGNIZED_TR_TABLE);
stmt.executeUpdate(ADD_CONSTRAINT_T1_C1);
stmt.executeUpdate(INIT_T1);
(The SQL in INIT_T1 is invalid, change the dot into a comma)
And i get an exception thrown in your testcase however at the
connection.close(), see below.
I hope this helps!
Best Regards!
Bullit Energy
---
Exception in thread "main" org.firebirdsql.jdbc.FBSQLException: GDS
Exception. 3
35544327. invalid request handle
at
org.firebirdsql.jdbc.AbstractStatement.close(AbstractStatement.java:2
48)
at
org.firebirdsql.jdbc.AbstractConnection.freeStatements(AbstractConnec
tion.java:107)
at
org.firebirdsql.jdbc.AbstractConnection.close(AbstractConnection.java
:418)
at
TestFBPreparedStatement.testUnrecognizedTransaction(TestFBPreparedSta
tement.java:563)
at TestFBPreparedStatement.main(TestFBPrep
aredStatement.java:570)
at org.firebirdsql.gds.GDSException: invalid request handle