How to set JNDI in Hibernate?

How to set JNDI in Hibernate?

Configuration for Tomcat and Jboss is almost same.

I did check in both it is working.

Set the following in Hibernate.hbm and then set the datasource in jndi config file.

<?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>
<!-- a SessionFactory instance listed as /jndi/name -->
<session-factory
name="java:hibernate/SessionFactory">

<!-- properties -->
<property name="connection.datasource">java:/comp/env/jdbc/MyDB</property>
<property name="dialect">org.hibernate.dialect.SCJASQLDialect</property>
<property name="show_sql">true</property>
<property name="transaction.factory_class">
org.hibernate.transaction.JTATransactionFactory
</property>
<property name="jta.UserTransaction">java:comp/UserTransaction</property>

<!-- mapping files -->

<!-- cache settings -->

</session-factory>

</hibernate-configuration>

server.xml configuration

Configure the JNDI DataSource in Tomcat by adding a declaration for your resource to $CATALINA_HOME/conf/server.xml.

Add this in between the </Context> tag of the examples context and the </Host> tag closing the localhost definition.

<Context path="/DBTest" docBase="DBTest"

        debug="5" reloadable="true" crossContext="true">

  <Logger className="org.apache.catalina.logger.FileLogger"

             prefix="localhost_DBTest_log." suffix=".txt"

             timestamp="true"/>

  <Resource name="jdbc/MyDB"

               auth="Container"

               type="javax.sql.DataSource"/>

  <ResourceParams name="jdbc/MyDB">

    <parameter>

      <name>factory</name>

      <value>org.apache.commons.dbcp.BasicDataSourceFactory</value>

    </parameter>

    <!-- Maximum number of dB connections in pool. Make sure you

         configure your mysqld max_connections large enough to handle

         all of your db connections. Set to 0 for no limit.

         -->

    <parameter>

      <name>maxActive</name>

      <value>100</value>

    </parameter>

    <!-- Maximum number of idle dB connections to retain in pool.

         Set to 0 for no limit.

         -->

    <parameter>

      <name>maxIdle</name>

      <value>30</value>

    </parameter>

    <!-- Maximum time to wait for a dB connection to become available

         in ms, in this example 10 seconds. An Exception is thrown if

         this timeout is exceeded.  Set to -1 to wait indefinitely.

         -->

    <parameter>

      <name>maxWait</name>

      <value>10000</value>

    </parameter>

    <!-- MySQL dB username and password for dB connections  -->

    <parameter>

     <name>username</name>

     <value>javauser</value>

    </parameter>

    <parameter>

     <name>password</name>

     <value>javadude</value>

    </parameter>

    <!-- Class name for mm.mysql JDBC driver -->

    <parameter>

       <name>driverClassName</name>

       <value>org.gjt.mm.mysql.Driver</value>

    </parameter>

    <!-- The JDBC connection url for connecting to your MySQL dB.

         The autoReconnect=true argument to the url makes sure that the

         mm.mysql JDBC Driver will automatically reconnect if mysqld closed the

         connection.  mysqld by default closes idle connections after 8 hours.

         -->

    <parameter>

      <name>url</name>

      <value>jdbc:mysql://localhost:3306/javatest?autoReconnect=true</value>

    </parameter>

  </ResourceParams>

</Context>