Meaningless Drivel is fun!*
The moose likes JDBC and the fly likes Not enough storage error Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Not enough storage error" Watch "Not enough storage error" New topic
Author

Not enough storage error

Sudhin Moorkoth
Greenhorn

Joined: Mar 29, 2001
Posts: 8
Hi,
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.
Sudhin
sanjay yermalkar
Greenhorn

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: http://aspose.com/file-tools
 
subject: Not enough storage error