jQuery in Action, 2nd edition*
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
 
Similar Threads
Servlet hang when performing to much insert function
DB2 JDBC heap error
Not enough storage is available to process this command
SQL Exception
PerGen Space