<hibernate-configuration>
   <session-factory name="SessionFactory">
      <!-- connection properties -->
      <property name="connection.datasource">java:/DB</property>

      <!-- dialect for Oracle 9 -->
      <property name="dialect">net.sf.hibernate.dialect.Oracle9Dialect</property>
      <property name="hibernate.show_sql">true</property>
      <property name="hibernate.use_outer_join">true</property>
      <property name="jta.UserTransaction">java:comp/UserTransaction</property>
      <property name="cache.use_query_cache">false</property>
      
      <!--### C3P0 Connection Pool ###-->
       <property name="c3p0.acquire_increment">1</property>
      <property name="c3p0.idle_test_period">100</property> <!-- seconds -->
      <property name="c3p0.max_size">100</property>
      <property name="c3p0.max_statements">0</property>
      <property name="c3p0.min_size">10</property>
      <property name="c3p0.timeout">100</property> <!-- seconds -->