Trying to execute a statement that is not in a closed state!!
MAX STATEMENT - 50
PREPARED STATEMENT CACHE SIZE - 50
I have opened up a PreparedStatement and executed a query through the application with out any problem. In the finally block, I close the Connection, ResultSet and PreparedStatement object.
Again when I execute the same query through the application, I get the error "Trying to execute a statement that is not in closed state".
Looks like the statement is cached as expected, but not sure why we are getting the error. Second time, the compilation time is shows as 0, but when it is getting executed in the DB, I am getting this error.
Please help us out. Thank you in advance.
PREPARED STATEMENT CACHE SIZE - 50
I have opened up a PreparedStatement and executed a query through the application with out any problem. In the finally block, I close the Connection, ResultSet and PreparedStatement object.
Again when I execute the same query through the application, I get the error "Trying to execute a statement that is not in closed state".
Looks like the statement is cached as expected, but not sure why we are getting the error. Second time, the compilation time is shows as 0, but when it is getting executed in the DB, I am getting this error.
Please help us out. Thank you in advance.
0