Hello: We are using Hibernate inside session EJBs that use container-managed transactions.
Our Hibernate configuration looks like this: <property name="hibernate.transaction.manager_lookup_class"> com.informiam.eacore.data.hibernate.GeronimoTransactionManagerLookup</property> <property name="connection.datasource">java:comp/env/jdbc/SessionEJBDataSource</property> <property name="hibernate.transaction.factory_class">org.hibernate.transaction.CMTTransactionFactory</property> <property name="hibernate.TransactionStrategy">org.hibernate.transaction.CMTTransactionFactory</property> <property name="hibernate.current_session_context_class">jta</property> I wonder whether it's possible, or necessary, to use connection pooling via C3P0 with such a configuration. I configured the hibernate.c3p0 properties with basic settings and deployed the application. It was slower to start, but then seemed to run much faster. But is it the right thing to do? Comments? Thanks.
