How to configure a DataSource for Hibernate in Tomcat 6.0

1. Create a DataSource in the Context file (context.xml) in the following location :
   

   <tomcat install>\conf
   

   
    

   <?xml version='1.0' encoding='utf-8'?>
   

   <!--
   

   Licensed to the Apache Software Foundation (ASF) under one or more
   

   contributor license agreements. See the NOTICE file distributed with
   

   this work for additional information regarding copyright ownership.
   

   The ASF licenses this file to You under the Apache License, Version 2.0
   

   (the "License"); you may not use this file except in compliance with
   

   the License. You may obtain a copy of the License at
   

   
    

   http://www.apache.org/licenses/LICENSE-2.0
   

   
    

   Unless required by applicable law or agreed to in writing, software
   

   distributed under the License is distributed on an "AS IS" BASIS,
   

   WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
   

   See the License for the specific language governing permissions and
   

   limitations under the License.
   

   -->
   

   <!-- The contents of this file will be loaded for each web application -->
   

   <Context>
   

   
    

   <!-- Default set of monitored resources -->
   

   <WatchedResource>WEB-INF/web.xml</WatchedResource>
   

       
    

   <!-- Uncomment this to disable session persistence across Tomcat restarts -->
   

   <!--
   

   <Manager pathname="" />
   

   -->
   

   
    

   <!-- Uncomment this to enable Comet connection tacking (provides events
   

   on session expiration as well as webapp lifecycle) -->
   

   <!--
   

   <Valve className="org.apache.catalina.valves.CometConnectionManagerValve" />-->
   

   
    

   <Resource name="jdbc/TAPPS_DS"
   

   auth="Container"
   

   type="javax.sql.DataSource"
   

   maxActive="-1" maxIdle="-1" maxWait="5000" validationQuery="select * from dual"
   

   username="wol_db" password="N3wtapp5"
   

   driverClassName="oracle.jdbc.OracleDriver"
   

   url="jdbc:oracle:thin:@tappsdev.mweb.co.za:1521:tappsdev" />
   

   </Context>
   

   
    

2. And then Add the DataSource to your Hibernate Configuration file hibernate.cfg.xml located in the following location of your Web application :
   

<You Web Application>\<Your Web Content>\WEB-INF\classes\

 

<?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.dialect">org.hibernate.dialect.OracleDialect</property>

<property name="current_session_context_class">thread</property>

<property name="hibernate.connection.datasource">java:comp/env/jdbc/TAPPS_DS</property>

<mapping class="com.mweb.sharedservices.entity.Partner" file="" jar="" package="" resource="hibernate.hbm.xml"/>

</session-factory>

</hibernate-configuration>