Hi!

I have this hibernate.cfg.xml :

<?xml version='1.0' encoding='utf-8'?>
<!DOCTYPE hibernate-configuration PUBLIC
"-//Hibernate/Hibernate Configuration DTD//EN"

"http://hibernate.sourceforge.net/hibernate-configuration-2.0.dtd">


<hibernate-configuration>

<session-factory >
<!-- Settings for mySQL
-->
<property name="hibernate.dialect">net.sf.hibernate.dialect.MySQLDialect</property>
<property name="hibernate.show_sql">true</property>
<property name="hibernate.use_outer_join">false</property>
<property name="hibernate.connection.driver_class">com.mysql.jdbc.Driver</property>
<property name="hibernate.connection.username">user</property>
<property name="hibernate.connection.password">pwd</property>
<property name="hibernate.connection.url"><![CDATA[jdbc:mysql://localhost:3306/dbname?autoReconnect=true&autoReconnectForPools=true]]></property>
<property name="hibernate.proxool.maximum-connection-count">10</property>
<property name="hibernate.proxool.house-keeping-test-sql">select CURRENT_DATE</property>
<!-- property name="hibernate.connection.pool_size">15</property -->
<!-- property name="hibernate.statement_cache.size">30</property -->

<!-- mapping files -->
<mapping resource="com/test/TestClass.hbm.xml"/>
</session-factory>
</hibernate-configuration>

Whenever i start the Application i get:

02.06.2004 11:04:04 net.sf.hibernate.dialect.Dialect <init>
INFO: Using dialect: net.sf.hibernate.dialect.MySQLDialect
02.06.2004 11:04:04 net.sf.hibernate.cfg.SettingsFactory buildSettings
INFO: Use outer join fetching: false
02.06.2004 11:04:04 net.sf.hibernate.connection.DriverManagerConnectionProvider configure
INFO: Using Hibernate built-in connection pool (not for production use!)
02.06.2004 11:04:04 net.sf.hibernate.connection.DriverManagerConnectionProvider configure
INFO: Hibernate connection pool size: 20


NO proxool pool is used - WHY?
Can somenone post a working hibernate.cfg.xml using the proxool connection pool?

Cheers!

<?xml version='1.0' encoding='utf-8'?>
<!DOCTYPE hibernate-configuration PUBLIC
"-//Hibernate/Hibernate Configuration DTD 2.0//EN"

"http://hibernate.sourceforge.net/hibernate-configuration-2.0.dtd">

<hibernate-configuration>

<!-- a SessionFactory instance listed as /jndi/name -->
<session-factory>

<!-- properties -->


<property name="connection.driver_class">oracle.jdbc.driver.OracleDriver</property>
<property name="connection.url">jdbc:oracle:thin:@142.215..:1526:</property>
<property name="connection.username"></property>
<property name="connection.password"></property>




<property name="connection.provider_class">net.sf.hibernate.connection.ProxoolConnectionProvider</property>
<property name="proxool.house-keeping-sleep-time">30000</property>
<property name="proxool.house-keeping-test-sql">select 1 from dual</property>
<property name="proxool.maximum-connection-count">3</property>
<property name="dialect">net.sf.hibernate.dialect.OracleDialect</property>
<property name="show_sql">true</property>
<property name="use_outer_join">true</property>

<!-- activation ehcache-->
<property name="hibernate.cache.provider_class">net.sf.ehcache.hibernate.Provider</property>

<!-- mapping files -->
...
</session-factory>

</hibernate-configuration>