Subject | IllegalStateException with 1.5beta2 |
---|---|
Author | Marco Parmeggiani |
Post date | 2004-01-28T10:39:28Z |
I'm testing the 1.5beta2 version of the driver (i've skippep the beta1)
with some code that actually uses 1.0.3 without problems. I have some
problem executing a stored procedure. Here's the code snippet:
sq = "EXECUTE PROCEDURE
SP_TOTALE_INCASSI_OPERATORE('2003-12-23','2003-12-26','grazia')";
try {
CallableStatement cs =
classecinema.Menu.DbTab.getCon().prepareCall(sq);
cs.execute();
ResultSet rsc = cs.getResultSet();
rsc.next();
[...]
rsc.close();
cs.close();
} catch (Exception xx) {
xx.printStackTrace();
}
the exception thrown is:
java.lang.IllegalStateException: registerStatement called with no
transaction
at
org.firebirdsql.jca.FBManagedConnection.registerStatement(FBManagedConnection.java:851)
at
org.firebirdsql.jdbc.AbstractConnection.registerStatement(AbstractConnection.java:927)
at
org.firebirdsql.jdbc.FBStatementFetcher.<init>(FBStatementFetcher.java:67)
at org.firebirdsql.jdbc.FBResultSet.<init>(FBResultSet.java:120)
at
org.firebirdsql.jdbc.AbstractStatement.getResultSet(AbstractStatement.java:544)
ciao
--
Seti@Home Java Applets
http://maruko.webhop.net/
with some code that actually uses 1.0.3 without problems. I have some
problem executing a stored procedure. Here's the code snippet:
sq = "EXECUTE PROCEDURE
SP_TOTALE_INCASSI_OPERATORE('2003-12-23','2003-12-26','grazia')";
try {
CallableStatement cs =
classecinema.Menu.DbTab.getCon().prepareCall(sq);
cs.execute();
ResultSet rsc = cs.getResultSet();
rsc.next();
[...]
rsc.close();
cs.close();
} catch (Exception xx) {
xx.printStackTrace();
}
the exception thrown is:
java.lang.IllegalStateException: registerStatement called with no
transaction
at
org.firebirdsql.jca.FBManagedConnection.registerStatement(FBManagedConnection.java:851)
at
org.firebirdsql.jdbc.AbstractConnection.registerStatement(AbstractConnection.java:927)
at
org.firebirdsql.jdbc.FBStatementFetcher.<init>(FBStatementFetcher.java:67)
at org.firebirdsql.jdbc.FBResultSet.<init>(FBResultSet.java:120)
at
org.firebirdsql.jdbc.AbstractStatement.getResultSet(AbstractStatement.java:544)
ciao
--
Seti@Home Java Applets
http://maruko.webhop.net/