The moose likes JDBC and Relational Databases and the fly likes Not enough storage error Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of REST with Spring (video course) this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Not enough storage error" Watch "Not enough storage error" New topic

Not enough storage error

Sudhin Moorkoth

Joined: Mar 29, 2001
Posts: 8
I am getting "java.sql.SQLException: [IBM][CLI Driver][DB2/6000] SQL0954C Not enough storage is available in the application heap to process the statement. SQLSTATE=57011" error during update process. This happens after about 700 records are updated. I am using JAVA code and PreparedStatements. The JDBC version is 2.0 and database is UDB on a SP platform.
Please help me.
sanjay yermalkar

Joined: Sep 19, 2001
Posts: 23
I had a similar trouble with PreparedStatement. So, i'm just guessing that your error corresponds to 'maximum cursors open' in oracle. I had a loop for inserting the data in a table and I was creating the preparedStatement everytime instead of just setting the parameters.
hope this helps!
I agree. Here's the link:
subject: Not enough storage error
It's not a secret anymore!