CODEMONKEYBRET
Programmer
Hi there!
I've been having problems with PreparedStatements in Java connecting to DB2 V7.1 UDB FIXPACK2 on Windows NT Server 2000.
Basically, we have a java object that manages database connections and transactions. It prepares statements, uses them and stores them if they need to be used in the future.
From time to time, we get an SQL0518N error meaning that either the package has been REBINDed, a ROLLBACK forces the prepared statement to be invalid or it is a SELECT or VALUES statement.
The statement has been prepared, we do not explicitly do REBIND statements (although REORG and RUNSTATS may happen from time to time) and after doing a short test, when executing a ROLLBACK, nothing bad seems to happen to my prepared statements.
Does anyone have any ideas what might be going on?
Thanks
-Bret
I've been having problems with PreparedStatements in Java connecting to DB2 V7.1 UDB FIXPACK2 on Windows NT Server 2000.
Basically, we have a java object that manages database connections and transactions. It prepares statements, uses them and stores them if they need to be used in the future.
From time to time, we get an SQL0518N error meaning that either the package has been REBINDed, a ROLLBACK forces the prepared statement to be invalid or it is a SELECT or VALUES statement.
The statement has been prepared, we do not explicitly do REBIND statements (although REORG and RUNSTATS may happen from time to time) and after doing a short test, when executing a ROLLBACK, nothing bad seems to happen to my prepared statements.
Does anyone have any ideas what might be going on?
Thanks
-Bret