Question re Hibernate connection pooling with C3P0 and CMT transaction management

[Geronimo User <ge...@gmail.com>]

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.