File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
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 Java Interview Guide this week in the Jobs Discussion 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!