Spring Hibernate C3P0 JNDI

Integrating Spring, Hibernate and JNDI Resource

pom.xml

	<properties>
		<project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
		<org.springframework-version>4.2.4.RELEASE</org.springframework-version>
		<hibernate.core>5.1.0.Final</hibernate.core>
		<hibernate.c3p0>5.1.0.Final</hibernate.c3p0>
		<mysql.version>5.1.38</mysql.version>
	</properties>

<!-- Hibernate -->
	<dependency>
		<groupId>org.hibernate</groupId>
		<artifactId>hibernate-core</artifactId>
		<version>${hibernate.core}</version>
	</dependency>

	<dependency>
		<groupId>org.hibernate</groupId>
		<artifactId>hibernate-c3p0</artifactId>
		<version>${hibernate.c3p0}</version>
	</dependency>

<!-- Spring -->
	<dependency>
		<groupId>org.springframework</groupId>
		<artifactId>spring-core</artifactId>
		<version>${org.springframework-version}</version>
	</dependency>

	<dependency>
		<groupId>org.springframework</groupId>
		<artifactId>spring-context</artifactId>
		<version>${org.springframework-version}</version>
		<exclusions>
		<!-- Exclude Commons Logging in favor of SLF4j -->
			<exclusion>
				<groupId>commons-logging</groupId>
				<artifactId>commons-logging</artifactId>
				</exclusion>
			</exclusions>
	</dependency>

        <dependency>
		<groupId>mysql</groupId>
		<artifactId>mysql-connector-java</artifactId>
		<version>${mysql.version}</version>
	</dependency>

context.xml

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

<Context path="/myapp" docBase="myapp"
   crossContext="true" reloadable="true" debug="1">

      <Resource auth="Container"
		driverClass="com.mysql.jdbc.Driver"
		maxPoolSize="10"
		minPoolSize="3"
		acquireIncrement="1"
		name="jdbc/myapp"
          	user="javabread"
          	password="javabread"
		factory="org.apache.naming.factory.BeanFactory"
         	type="com.mchange.v2.c3p0.ComboPooledDataSource"
          	jdbcUrl="jdbc:mysql://localhost:3306/dbname"/>
</Context>

spring’s application-context.xml

<?xml version="1.0" encoding="UTF-8"?>
<beans:beans xmlns="http://www.springframework.org/schema/mvc"
	xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:beans="http://www.springframework.org/schema/beans"
	xmlns:context="http://www.springframework.org/schema/context" xmlns:util="http://www.springframework.org/schema/util"
	xmlns:aop="http://www.springframework.org/schema/aop" xmlns:tx="http://www.springframework.org/schema/tx"
	xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd
						http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context.xsd
						http://www.springframework.org/schema/util http://www.springframework.org/schema/util/spring-util.xsd
						http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop.xsd
						http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx.xsd">

	<context:annotation-config />
	<context:component-scan base-package="edu.javabread.demo" />

	<!-- Configure Properties File -->
	<beans:bean class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer" id="myProperties">
		<beans:property name="locations">
			<beans:list>
				<beans:value>classpath:system.properties</beans:value>
				<beans:value>classpath:ValidationMessages.properties</beans:value>
			</beans:list>
		</beans:property>
		<beans:property name="ignoreUnresolvablePlaceholders" value="true" />
	</beans:bean>

	<beans:import resource="hibernate-config.xml"/>

</beans:beans>

hibernate-config.xml

<?xml version="1.0" encoding="UTF-8"?>
<beans:beans xmlns="http://www.springframework.org/schema/mvc"
	xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:beans="http://www.springframework.org/schema/beans"
	xmlns:tx="http://www.springframework.org/schema/tx"
	xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd
						http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context.xsd
						http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx.xsd">

	<tx:annotation-driven/>

	<beans:bean id="dataSource" class="org.springframework.jndi.JndiObjectFactoryBean">
        <beans:property name="jndiName" value="java:comp/env/jdbc/instaproxy"/>
    </beans:bean>

    <beans:bean id="sessionFactory" class="org.springframework.orm.hibernate5.LocalSessionFactoryBean">
        <beans:property name="dataSource" ref="dataSource" />
        <beans:property name="hibernateProperties">
            <beans:props>
                <beans:prop key="hibernate.dialect">org.hibernate.dialect.MySQLDialect</beans:prop>
                <beans:prop key="hibernate.show_sql">true</beans:prop>
                <beans:prop key="hibernate.format_sql">true</beans:prop>
                <beans:prop key="hibernate.hbm2ddl.auto">validate</beans:prop>
                <beans:prop key="hibernate.default_schema">dbname</beans:prop>
            </beans:props>
        </beans:property>
     </beans:bean>

</beans:beans>