I am a newbie to Hibernate and very confused about how to Not use the default Hibernate connection pool. Hibernate assures you that this pool should not be used for Production. Great..I get it..its dinky. However, if I am using Spring2.6 and Hibernate3.3 on simple old Tomcat 6 what is the best PRODUCTION QUALITY way to implement my Hibernate connection pool? I thought Apache DBCP would suffice but it looks like Hibernate 3.3 no longer supports DBCP. Is this true? There is no documentation about how to do this, at least I couldnt find any, and the only posts I found seem to be using "org.hibernate.connection.DBCPConnectionProvider" which does not exist in Hibernate 3.3 apparently. What should I be doing?

Any help would be much appreciated!

Thanks
John

you can use third party tools like c3p0 using hibernate for connection pooling.

Thanks, but c3p0 is the connection pool mechanism that Hibernate uses by default and in fact the very mechanism that I am trying to avoid using because it has been described as 'definitely not for production'!