4.1.1.Final - Performance issue

iranm · **Joined:** Wed Sep 03, 2003 9:31 am **Posts:** 26

I posted this problem before but got no answer yet (https://forum.hibernate.org/viewtopic.php?f=1&t=1014585). Now I upgraded to 4.1.1 and the problem persists. I still don't know it's really a hibernate problem or a configuration/usage issue.

I'll describe it again.

Code:

open session
for (about 5000 iterations) {
   load
}
close session

For the first 300 iterations performance goes well, but after that I notice the queries are executed slower and slower until the following exception throws:

ERROR - [JDBC Progress Driver]:Out Of Memory
WARN - SQL Error: 30190, SQLState: HY001

The problem occurs also when I do only saves inside the loop:

Code:

open session
for {
   begin transaction
   saveOrUpdade
   commit
}
close session

Prior 4.1.0.Final upgrade I didn't have this problem. The only solution I found until now was:

Code:

for {
   open session
   do load or save
   close session
}

This way the performance is normal but it doesn't seem to be right.

By the way, I'm using c3p0 with the following configurations:

hibernate.c3p0.min_size=1
hibernate.c3p0.max_size=20
hibernate.c3p0.timeout=1800
hibernate.c3p0.max_statements=20

I tried to change pool size, max_statements, but no solution.

Any thoughts?

pb00067 · **Joined:** Tue Jun 16, 2009 3:36 am **Posts:** 990

Did you try Hibernate4.1.2 ?
It includes
https://hibernate.onjira.com/browse/HHH-7190
so it may resolve your problem...

sanne.grinovero · **Posted:** Sun Apr 15, 2012 6:47 am

you should use session.clear() after the commit if you want to reuse the same Session but free the memory from the objects it was containing.

iranm · **Joined:** Wed Sep 03, 2003 9:31 am **Posts:** 26

I tried session.chear(), but I was waiting for an upgrade in our database to give a more concise reply.

I realized the problem was the old jdbc progress driver (9.1e) which was behaving bad. With the new version (10.1a) many problems was solved, including this one.

Thanx for the tip.