Subject IllegalStateException with 1.5beta2
Author Marco Parmeggiani
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/