<?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>

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

        <!-- properties -->       
       
        <property name="hibernate.dialect">org.hibernate.dialect.PostgreSQLDialect</property>
       <property name="hibernate.connection.driver_class">org.postgresql.Driver</property>
       <property name="hibernate.connection.url">jdbc:postgresql://192.168.149.49:5432/DNA_Mann</property>
       <property name="hibernate.connection.username">postgres</property>
       <property name="hibernate.connection.password">postgres</property>
       <property name="hibernate.connection.autocommit">true</property>
       <!-- Enable Hibernate's automatic session context management -->
      
      <property name="current_session_context_class">thread</property>
      
        <property name="show_sql">true</property>
        <property name="use_outer_join">true</property>

        <!-- mapping files -->
      <!-- mapping resource="hibernate-config/com/infra/persistence/bean/Customer.hbm.xml"/ -->
        <!-- mapping resource="hibernate-config/com/infra/persistence/bean/Order.hbm.xml"/ -->
        <!-- mapping resource="hibernate-config/com/infra/persistence/bean/Orderitem.hbm.xml"/ -->
        <mapping resource="hibernate-config/com/infra/persistence/bean/Product.hbm.xml"/>
        <!-- mapping files -->       
    </session-factory>

</hibernate-configuration>

private Session getSession() throws PersistenceException {
            Session session = ThrdSessionHolder.get();
            System.out.println("session is .." +session);
            //org.hibernate.Session session = GlobalSessionFactory.get().newSession();
            //ConnectionProvider cp = ConnectionProviderFactory.newConnectionProvider();
            //TODO Need to test the Connection
           [b] Connection conn = session.connection(); //I get the error here in this line[/b]
            System.out.println("conn is .." +conn);
            log.info("session.isConnected() :--> "+session.isConnected());
            if (!session.isConnected()) {
                try {
                   System.out.println("session object not connected");
                   session.reconnect(conn);
                } catch (HibernateException he) {
                   System.out.println("Exception obj is-->"+he);
                    throw new PersistenceException(PersistenceErrCodes.SESSION_ERROR, he);
                }
            }
            return session;
        }