Hello,

We recently moved to the following environment.

java version "1.6.0_23"
jboss-6.0.0.Final
hibernate 3.6.0.Final

I am seeing this warning message on the jboss console and want to take appropriate action.

c3p0 properties is specificed, but could not find org.hibernate.connection.C3P0ConnectionProvider from the classpath, these properties are going to be ignored.

Following is sample cfg.xml file from our application.

<?xml version='1.0' encoding='utf-8'?>
<!DOCTYPE hibernate-configuration PUBLIC "-//Hibernate/Hibernate Configuration DTD//EN"
"http://www.hibernate.org/dtd/hibernate-configuration-3.0.dtd">

<hibernate-configuration>
<!-- a SessionFactory instance listed as /jndi/name -->
<session-factory>
<property name="hibernate.connection.datasource">java:AutomationDS</property>
<property name="hibernate.show_sql">false</property>
<property name="hibernate.dialect">org.hibernate.dialect.MySQLDialect</property>
<property name="hibernate.jdbc.use_streams_for_binary">true </property>
<property name="hibernate.jdbc.batch_size">0</property>
<property name="transaction.factory_class">org.hibernate.transaction.JDBCTransactionFactory</property>
<property name="hibernate.cache.use_minimal_puts">true</property>
<property name="c3p0.min_size">10</property>
<property name="c3p0.max_size">100</property>
<property name="c3p0.timeout">10</property>
<property name="c3p0.acquireRetryAttempts">30</property>
<property name="c3p0.acquireIncrement">5</property>
<property name="c3p0.idleConnectionTestPeriod">300</property>
<property name="c3p0.initialPoolSize">20</property>
<property name="c3p0.maxPoolSize">100</property>
<property name="c3p0.maxIdleTime">300</property>
<property name="c3p0.maxStatements">50</property>
<property name="c3p0.minPoolSize">10</property>
<!--Mapping files -->
<mapping resource="config/hibernate/AutomationResult.hbm.xml" />
</session-factory>
</hibernate-configuration>

We are using the following hibernate jars.

hibernate-commons-annotations.jar
hibernate-core.jar
hibernate-entitymanager.jar
hibernate-jpa-2.0-api.jar
hibernate-validator.jar
hibernate-validator-legacy.jar
mysql-connector-java-5.1.14-bin.jar

I tried using c3p0-0.9.1.jar in our application but it further breaks the application with more exceptions. As of now, we are not using it.

You have to use hibernate-c3po and include this into your classpath!