<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-configuration PUBLIC
      "-//Hibernate/Hibernate Configuration DTD 3.0//EN"
      "http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">
<hibernate-configuration>
   <session-factory>
      <property name="hibernate.connection.driver_class">com.mysql.jdbc.Driver</property>
      <!-- URL Base de datos -->
      <property name="hibernate.connection.url">jdbc:mysql://localhost:3306/cardalesDesa?autoReconnect=true</property>
      <property name="hibernate.connection.username">user</property>
      <property name="hibernate.connection.password">*****</property>
      <property name="hibernate.dialect">org.hibernate.dialect.MySQLDialect</property>


      <!-- Use the C3P0 connection pool.  -->
      <!-- c3p0 config http://www.hibernate.org/214.html -->
      <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 -->


      <!-- Enable Hibernate's automatic session context management -->
      <property name="current_session_context_class">thread</property>

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

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

      <!-- Drop and re-create the database schema on startup -->
      <property name="hbm2ddl.auto">update</property>
   </session-factory>
</hibernate-configuration>

private static final ThreadLocal<Session> session = new ThreadLocal<Session>();

public static synchronized Session getSession() throws HibernateException {
    if (sessionFactory == null) {
   init();
    }
    Session s = session.get();
    if (s == null || !s.isOpen()) {
         s = sessionFactory.openSession();
         session.set(s);
    }
    s.clear();
    return s;
}

// This operation does the insert, opening a new session, creating the object,
// saving, and committing. After that, the id generated for the object, is sent to
// the next method.
long id = createNewObject(data);

// This method publishes a task in a ThreadPool, but when the thread that gets the task,
// tries to access the object inserted, by 'id', its not there.
publishTask(id);