Win a copy of Machine Learning Systems: Designs that scale this week in the Scala forum
or Xamarin in Action: Creating native cross-platform mobile apps in the Android forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

PreparedStatement closes prematurely while in Websphere 5.0  RSS feed

 
Ranch Hand
Posts: 37
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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 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 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.
 
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
DSRA9110E: is "Connection is closed" (not Statement is closed)
 
Dave Milne
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
My mistake, can be either it appears. Sorry.
 
money grubbing section goes here:
Rocket Oven Kickstarter - from the trailboss
https://coderanch.com/t/695773/Rocket-Oven-Kickstarter-trailboss
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!