17:58:51,187 INFO  [STDOUT] 17:58:51,187 ERROR [InsuranceHome] Could not locate SessionFactory in JNDI
java.lang.ClassCastException: org.jboss.resource.adapter.jdbc.WrapperDataSource
   at com.sellermania.hibernate.generated.InsuranceHome.getSessionFactory(InsuranceHome.java:29)
   at com.sellermania.hibernate.generated.InsuranceHome.<init>(InsuranceHome.java:22)
   at com.sellermania.hibernate.generated.InsuranceDao.getdata(InsuranceDao.java:29)
   at test.FirstBeanController.retriveData(FirstBeanController.java:16)
   at test.FirstBean.<init>(FirstBean.java:74)

<?xml version='1.0' encoding='utf-8'?>
<!DOCTYPE hibernate-configuration PUBLIC
"-//Hibernate/Hibernate Configuration DTD//EN"
"http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">

<hibernate-configuration>
<session-factory>
      <property name="hibernate.cache.provider_class">org.hibernate.cache.NoCacheProvider</property>
        <property name="hibernate.cglib.use_reflection_optimizer">true</property>
        <property name="hibernate.connection.driver_class">com.mysql.jdbc.Driver</property>
       
        <property name="hibernate.connection.pool_size">1</property>
        <property name="hibernate.connection.url">jdbc:mysql://localhost/test?zeroDateTimeBehavior=convertToNull</property>
        <property name="hibernate.connection.username">test</property>
         <property name="hibernate.connection.password">test</property>
        <property name="hibernate.current_session_context_class">thread</property>
        <property name="hibernate.dialect">org.hibernate.dialect.MySQLMyISAMDialect</property>
        <property name="hibernate.show_sql">true</property>
      <property name="hibernate.hbm2ddl.auto">update</property>
      
      <property name="connection.datasource">java:/MySqlDS</property>
      
      
      <!-- 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>     
      
        <!-- Mapping files   -->
         <mapping resource="com/test/hibernate/generated/insurance.hbm.xml"/>

</session-factory>
</hibernate-configuration>

<?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.default_schema">dpcs</property>
        <property name="hibernate.connection.datasource">java:/MySqlDS</property>
      <property name="hibernate.transaction.factory_class">org.hibernate.transaction.JTATransactionFactory</property>
      <property name="hibernate.transaction.manager_lookup_class">org.hibernate.transaction.JBossTransactionManagerLookup</property>
     
        <property name="hibernate.dialect">org.hibernate.dialect.MySQLInnoDBDialect</property>
      <property name="hibernate.cglib.use_reflection_optimizer">false</property>
       
        <property name="show_sql">true</property>
       <property name="hibernate.format_sql">true</property>
        <property name="hbm2ddl.auto">none</property>
        <property name="cache.use_second_level_cache">false</property>
      <property name="hibernate.current_session_context_class">thread</property>
      <property name="hibernate.query.factory_class">org.hibernate.hql.classic.ClassicQueryTranslatorFactory</property>

      <mapping resource="com/test/hibernate/generated/insurance.hbm.xml"/>
    </session-factory>
</hibernate-configuration>

Object o  = new InitialContext().lookup("java:MySqlDS");
              System.out.println("><<<<<<<>>>>>>>>>>>>>>>>>>>>>" + o.toString());
s = (SessionFactory)o;
   

<?xml version="1.0" encoding="UTF-8"?>

<!-- $Id: mysql-ds.xml 41016 2006-02-07 14:23:00Z acoliver $ -->
<!--  Datasource config for MySQL using 3.0.9 available from:
http://www.mysql.com/downloads/api-jdbc-stable.html
-->

<datasources>
  <local-tx-datasource>
    <jndi-name>MySqlDS</jndi-name>
    <connection-url>jdbc:mysql://localhost/test</connection-url>
    <driver-class>com.mysql.jdbc.Driver</driver-class>
    <user-name>test</user-name>
    <password>test</password>
    <exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.MySQLExceptionSorter</exception-sorter-class-name>
    <!-- should only be used on drivers after 3.22.1 with "ping" support
    <valid-connection-checker-class-name>org.jboss.resource.adapter.jdbc.vendor.MySQLValidConnectionChecker</valid-connection-checker-class-name>
    -->
    <!-- sql to call when connection is created
    <new-connection-sql>some arbitrary sql</new-connection-sql>
      -->
    <!-- sql to call on an existing pooled connection when it is obtained from pool - MySQLValidConnectionChecker is preferred for newer drivers
    <check-valid-connection-sql>some arbitrary sql</check-valid-connection-sql>
      -->

    <!-- corresponding type-mapping in the standardjbosscmp-jdbc.xml (optional) -->
    <metadata>
       <type-mapping>mySQL</type-mapping>
    </metadata>
     
  </local-tx-datasource>
 
</datasources>

SessionFactory sessionFactory = new Configuration().configure().buildSessionFactory();

Session session = sessionFactory.getOpenSession();

or

Session session = sessionFactory.getCurrentSession();

then

Transaction tx = session.beginTransaction();

session.save(objectToSave);

tx.commit();

[Configuration] Configured SessionFactory: null