05/02/2011 16:23:02 DEBUG BasicResourcePool:548 - acquire test -- pool is already maxed out. [managed: 10; max: 10]
05/02/2011 16:23:02 DEBUG BasicResourcePool:1279 - awaitAvailable(): com.mchange.v2.c3p0.impl.NewPooledConnection@7301061
05/02/2011 16:23:02 DEBUG BasicResourcePool:1620 - trace com.mchange.v2.resourcepool.BasicResourcePool@6a74f160 [managed: 10, unused: 0, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@7301061)

try{
session = MyHibernateUtil.getSessionFactory().getCurrentSession();
session.beginTransaction();
List<Cliente> listaClientiVoip = ClienteDao.listAllCliVoip(session);
session.flush();
session.getTransaction().commit();
catch (Exception ex) {
         log.error("", ex);
         try {
            if (session != null && session.getTransaction() != null) {
               session.getTransaction().rollback();
            }
         } catch (RuntimeException rbEx) {
            log.error("Non riesco ad annullare la transazione.", rbEx);
         }
      }

Caused by: org.hibernate.SessionException: Session was already closed
at org.hibernate.impl.SessionImpl.close(SessionImpl.java:312)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

<!DOCTYPE hibernate-configuration PUBLIC '-//Hibernate/Hibernate Configuration DTD 3.0//EN' 'http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd'>
<hibernate-configuration>
   <session-factory>
      <!-- Database connection settings -->
      <!-- MySQL -->
      <property name="connection.driver_class">com.mysql.jdbc.Driver</property>
      <property name="connection.url">jdbc:mysql://192.168.185.254:3306/ztl_import</property>
      <property name="connection.autoReconnect">true</property>
      <property name="connection.autoReconnectForPools">true</property>
      <property name="connection.is-connection-validation-required">true</property>
      <property name="connection.username">root</property>
      <property name="connection.password">xxxxxxxx</property>

      <!--
         per usare true e false nelle query: togliere se il db non è mysql
      -->
      <property name="hibernate.query.substitutions">true 1, false 0</property>
      <!--
         <property name="hibernate.connection.tinyInt1isBit">true</property>
         <property
         name="hibernate.connection.transformedBitIsBoolean">true</property>
      -->



      <!-- JDBC connection pool (use the built-in) -->
      <property name="connection.provider_class">org.hibernate.connection.C3P0ConnectionProvider</property>
      <property name="c3p0.acquire_increment">1</property>
      <property name="c3p0.idle_test_period">14400</property>
      <property name="c3p0.max_size">10</property>
      <property name="c3p0.max_statements">0</property>
      <property name="c3p0.min_size">10</property>
      <property name="c3p0.timeout">25200</property>
      <property name="connection.pool_size">20</property>

      <!-- SQL dialect -->
      <!--
         <property
         name="dialect">org.hibernate.dialect.MySQLInnoDBDialect</property>
      -->
      <property name="hibernate.dialect">org.hibernate.dialect.MySQL5InnoDBDialect</property>

      <!-- Enable Hibernate's automatic session context management -->
      <property name="hibernate.transaction.factory_class">org.hibernate.transaction.JDBCTransactionFactory</property>
      <property name="current_session_context_class">thread</property>

      <!-- Disable the second-level cache  -->
      <property name="cache.provider_class">org.hibernate.cache.NoCacheProvider</property>
      <property name="hibernate.cache.use_query_cache">false</property>

      <!-- Echo all executed SQL to stdout -->
      <property name="show_sql">true</property>
      <property name="format_sql">true</property>
      <property name="use_sql_comments">true</property>

      <property name="hbm2ddl.auto">update</property>
   
                <!--HERE THERE ARE ALL MAPPINGS-->
      <mapping class="xxxxxx" />
   
      
   </session-factory>

</hibernate-configuration>