posted 21 years ago
reposting this:
Hi,
I am working on a database intensive app with heavy usage of PreparedStatements. I have prepared the statements, using a single connection object (which is valid throught the lifetime of the application) in the constructor. Subsequently I am calling other methods on my dbManager class which execute these 'pre-prepared' statements one by one.
At executeQuery(), I get the following error:
'DSRA9110E: Statement is closed.'
I changed the parameter for PreparedStatment cache and set it to 200 (from the admin console)even though I have a batch of 90 PreparedStatements, but in vain.
The only way to get past this error as of now is to prepare the statement every time I want to execute it, which does not make sense.
Has anyone encountered the same problem. If so how do we tackle it.
REPLY ASAP PLEASE.
Regards,
Juzar.