I'm using HIbernate 3.1 in my web app. Application works ok, but if I leave it for a few days suddenly the connection can not be obtained and it constantly crashes.
Did anyone noticed something like this?

Bojan

This is most often caused by a leak in the connection pool. Probably at some point in your code you are not properly calling Session.close() so Hibernate doesn't know to return the Session (and underlying Connection) back to the connection pool.

Depending on the rate of connections drawn from the pool and the number of times the 'leaky' code is called, it probably takes some time for the entire pool to drain.

Just my guess with very little hard info to go on.
-Geoff

if you application have huge or tremendous amount of data then check for the lazy loading

No, no. When I start an application server, I check if everithing works ok. Works perfect.

Then I leave and return back in a few days and it doeasn't work. No one worked on the sistem exept me.

Any help appreciated.