Configure jndi in tomcat6 and work with hibernate

This article describes how to configure JNDI in tomcat6 and work with hibernate.

step 1) open file context.xml under folder %tomcat_home%/conf, and add the following settings between <Context> and </Context>.

<Resource name="jdbc/leave" auth="Container" type="javax.sql.DataSource"
password="lmsdb1234" username="lms" driverClassName="org.gjt.mm.mysql.Driver"
url="jdbc:mysql://localhost:3306/lmsdb" maxActive="20" maxIdle="1" maxWait="5000"/>

step 2) copy mysql driver file, e.g. mysql-connector-java-5.1.7-bin.jar to folder %tomcat_home%/lib

step 3) open file web.xml for the specific project, and add the following settings

<resource-ref>
   <description>MySQL DataSource</description>
   <res-ref-name>jdbc/test</res-ref-name>
   <res-type>javax.sql.DataSource</res-type>
   <res-auth>Container</res-auth>
</resource-ref>

make sure the refercence name is the same as defined in tomcat config file.

step 4) open hibernate config file and assign the jndi settings
<property name="connection.datasource">
    java:/comp/env/jdbc/leave
</property>