We are developing a Banking Project. We used Hibernate 1.2 version and got good results in all functions except batch processing. When we do deposit, withdraw process then it works good. But when we start profit posting (for more than 1000 accounts) then Hibernate gives two errors:
1. Maximum Cursor Exceeds
2. Out of Memory

To get remedy from this problem we changed Hibernate 1.2 and installed Hibernate 2.1.

But its a great sorrow that, now Hibernate is working very bad. Now Hibernate 2.1 is giving "Out of Memory' problem after completing 20 or 30 operations. We checked it by JProfile and got after 30-40 operations it occupies 256 RAM and gives "Out of Memory' error. We are not understanding why this memory leak is happening.

Looking for a solution.

regards

tanver

We need more information than that.

http://www.hibernate.org/ForumMailinglists/HowToAskForHelp

The Max cursor Excedeed is probably due to your driver (I had some trouble with Oracle some times ago)
The OutOfMemory is certainly due to a bad design in your app. Untill now every single outofmemory claims were due to either code errors or innapropriate designs. Hibernate had no memory leaks in all of these claims.

If you load a lot of objects in the same session, be sure to evict your loaded objects after you don't need them anymore. Also check that the loaded object graph is not to large (use lazy loading etc)