I have a simmilar problem... I'm inserting about 12 000 Entities in the DB, and
after about 8000 it craches thithe the same "Cannot open connection" exception.
The problem is, that connection is obtained and released for each call to
persist(). See hibernate log:
| 2006-08-22 21:50:44,889 DEB
I could not find update for Hibernate 3.2cr3 so tried to do it myself.
There are 2 files needed for update - hibernate3.jar in lib dir and
hibernate-client.jar in client dir.
The first one is available from
http://sourceforge.net/project/showfiles.php?group_id=40712&package_id=127784&release_id=4