Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp

Hibernate version:3.1

Mapping documents:Too many to post

Code between sessionFactory.openSession() and session.close():

Full stack trace of any exception that occurs:

Connection pool exhausted

Name and version of the database you are using:Oracle 9i

The generated SQL (show_sql=true):

Debug level Hibernate log excerpt:

Since upgrading from 3.0.5 to 3.1, I am running out of DB connections very quickly (easily repeatable)... to it would appear that something is not closing connections...

All I have done is changed a few mapping file values to conform to the stricter/slightly modified dtd in 3.1 ...

I am using apache dbcp with setting:

<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">

Anyone else seen this?

I am using Spring 1.2.4 and

import org.springframework.orm.hibernate3.support.HibernateDaoSupport;

OpenSessionInViewFilter etc...

is there any reason why this should not be compatible with 3.1? or is it that ThreadLocal are serializable/serialized now?

Not sure... any idea's appreciated... I will do some more digging...

and changed back the attribute change I made on my

many-to-one relationships.. (which was changing lazy=no-proxy back to lazy=true)

and it works fine.......