Integration Of Spring with Hibernate using Oracle Database

[Vivek Kr Agrawal]

Hi Everyone,
Problem Scenario:Putting dataSource from Persistence.xml and ApplicationContext.xml at one place.
Details:-
I am having a tough time integrating Hibernate with Spring framework. I am following strict JPA guidelines in the framework. So I am having one persistence.xml and some orm.xml which basically contains the mapping. In my persistence.xml I am providing the dataSource as hibernate standards.Everything is working fine with this configuration:-

<?xml version="1.0" encoding="UTF-8"?> <persistence version="2.0" xmlns="http://java.sun.com/xml/ns/persistence" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://java.sun.com/xml/ns/persistence http://java.sun.com/xml/ns/persistence/persistence_2_0.xsd"> <persistence-unit name="SampleTestPU" transaction-type="RESOURCE_LOCAL"> <provider>org.hibernate.ejb.HibernatePersistence</provider> <mapping-file>Applicant_orm.xml</mapping-file> <mapping-file>CoApplicant_orm.xml</mapping-file> <mapping-file>LoanDetails_orm.xml</mapping-file> <mapping-file>SupportingDoc_orm.xml</mapping-file> <properties> <property name="hibernate.connection.url" value="url" /> <property name="hibernate.connection.driver_class" value="oracle.jdbc.driver.OracleDriver" /> <property name="hibernate.connection.username" value="name" /> <property name="hibernate.connection.password" value="passwprd" /> <property name="hibernate.dialect" value="org.hibernate.dialect.Oracle9iDialect" /> <property name="hibernate.temp.use_jdbc_metadata_defaults" value="false" /> <property name="hibernate.show_sql" value="true" /> </properties> </persistence-unit> </persistence>
In my applicationContext.xml(Spring xml) I am doing
<bean id="entityManagerFactory" class="org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean"> <property name="persistenceUnitName" value="SampleTestPU" /> <property name="dataSource" ref="dataSource" /> </bean> <bean id="dataSource" class="org.springframework.jdbc.datasource.SimpleDriverDataSource"> <property name="driverClass" value="oracle.jdbc.driver.OracleDriver"></property> <property name="url" value="url"></property> <property name="username" value="name"></property> <property name="password" value="pass"></property> </bean>

But the point is that I don't want to declare give my db details at two places. Putting all db details in application context makes more sense. So i tried integrating using sessionFactory bean concept provided at various sites but still have no success.
I am trying to all this new bean in my applicationContext.xml
<bean id="sessionFactory" class="org.springframework.orm.hibernate.LocalSessionFactoryBean"> <property name="hibernateProperties"> <props> <prop key="hibernate.hbm2ddl.auto">create</prop> <prop key="hibernate.dialect">org.hibernate.dialect.Oracle9iDialect</prop> <prop key="hibernate.show_sql">true</prop> </props> </property> </bean>


Can you please provide me a good example how to put all my datasource at one place.

[Bill Gorder]

You do not need the sessionfactory bean, you are using a LocalContainerEntityManagerFactoryBean. You can just remove the db connection details from the persistence.xml, it is not needed there.