• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Liutauras Vilda
  • Campbell Ritchie
  • Tim Cooke
  • Bear Bibeault
  • Devaka Cooray
Sheriffs:
  • Jeanne Boyarsky
  • Knute Snortum
  • Junilu Lacar
Saloon Keepers:
  • Tim Moores
  • Ganesh Patekar
  • Stephan van Hulst
  • Pete Letkeman
  • Carey Brown
Bartenders:
  • Tim Holloway
  • Ron McLeod
  • Vijitha Kumara

SQL Exception  RSS feed

 
Ranch Hand
Posts: 128
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi All,
I am facing an starnge problem.
My psuedo code,

1. A Query to Retreive the Records satisfying particular condition.
2. For each record retreived above i have a for loop to itreate it and do the following operations.
3. Inside For loop-
Write a prepared statement and execute it to get users associated with that which is multiple.
4. Based on the users got i build a comlplex query with the values retrived in above process and execute it to get the resultset.
5.I store the values in arraylist
6. Repeat the above process unitill all the records are handled.

If the no. of records are less, its working fine. But it exceeds around 60 i get the following exception-

com.ibm.db2.jcc.b.SqlException: Not enough storage is available in the application heap to process the statement.


Can any one suggest a solution to overcome this problem.

Thanks in advance.

Regards,
Arul.
 
Ranch Hand
Posts: 201
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
This is just a wild guess, but it sounds like either cursor problems, an unanticipated set of conditions, or unclosed resources. Have you placed printlns strategically? ... especially with different counts?

~Bill
 
Ranch Hand
Posts: 94
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
You can also check your queries and make sure you are not executing a cartesian join on two huge tables. It maybe that the resulting object pushed as return from the db to your java object is too big and java cannot store it.

Regards,
george
 
Don't get me started about those stupid light bulbs.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!