Well, all I know is that once I got the hibernate.cfg.xml file to load, there were definitely a lot more log entries for c3p0. Also, pay close attention to which c3p0 settings MUST be specified in the hibernate.cfg.xml It's my understanding that any other settings must be in the c3p0.properties.
<?xml version='1.0' encoding='utf-8'?>
<!DOCTYPE hibernate-configuration PUBLIC
"-//Hibernate/Hibernate Configuration DTD//EN"
"http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">
<hibernate-configuration>
<session-factory>
<property name="show_sql">true</property>
<property name="hibernate.dialect">org.hibernate.dialect.MySQLDialect</property>
<property name="hibernate.connection.driver_class">com.mysql.jdbc.Driver</property>
<property name="hibernate.connection.url">jdbc:mysql://localhost/someDatabase?autoReconnect=true</property
<property name="hibernate.connection.username">someUsername</property>
<property name="hibernate.connection.password">somePassword</property>
<property name="hibernate.connection.pool_size">0</property>
<property name="format_sql">false</property>
<property name="hibernate.jdbc.use_scrollable_resultset">true</property>
<!-- configuration pool via c3p0-->
<property name="hibernate.c3p0.acquire_increment">3</property>
<property name="hibernate.c3p0.idle_test_period">100</property> <!-- seconds -->
<property name="hibernate.c3p0.max_size">100</property>
<property name="hibernate.c3p0.max_statements">0</property>
<property name="hibernate.c3p0.min_size">10</property>
<property name="hibernate.c3p0.timeout">100</property> <!-- seconds -->
</session-factory>
</hibernate-configuration>
Login
FAQ
Search