In my project I am using two oracle datasources for one of the datasource Im using LocalSessionFactoryBean and for another LocalContainerEntityManagerFactoryBean I am mapping the datasources accordingly but when Im trying to get sessionFactory for LocalSessionFactoryBean the datasource details are that of the other. Dono what I am doing wrong.
<tx:annotation-driven transaction-manager="xxxTransactionManager" /> <bean id="xxxEntityManagerFactoryBean" class="org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean"> <property name="dataSource" ref="dataSource" /> <property name="persistenceXmlLocation" value="classpath:persistence.xml" /> <property name="jpaDialect"> <bean class="org.springframework.orm.jpa.vendor.HibernateJpaDialect" /> </property> <property name="jpaVendorAdapter"> <bean class="org.springframework.orm.jpa.vendor.HibernateJpaVendorAdapter" /> </property> <property name="jpaProperties"> <props> <prop key="hibernate.dialect">${hibernate.dialect}</prop> <prop key="hibernate.show_sql">${hibernate.show_sql}</prop> <prop key="hibernate.hbm2ddl.auto">${hibernate.hbm2ddl.auto}</prop> </props> </property> </bean> <bean class="org.modelmapper.ModelMapper" id="modelMapper"/> <bean id="xxxEntityManager" class="org.springframework.orm.jpa.support.SharedEntityManagerBean"> <property name="entityManagerFactory" ref="xxxEntityManagerFactoryBean" /> </bean> <bean id="xxxTransactionManager" class="org.springframework.orm.jpa.JpaTransactionManager"> <property name="entityManagerFactory" ref="xxxEntityManagerFactoryBean" /> <property name="nestedTransactionAllowed" value="true" /> <property name="dataSource" ref="dataSource" /> <property name="jpaDialect" ref="jpaDialect" /> </bean> <bean id="jpaDialect" class="org.springframework.orm.jpa.vendor.HibernateJpaDialect" /> in another xml file that is imported i have
<bean id="sessionFactoryNew" class="org.springframework.orm.hibernate4.LocalSessionFactoryBean"> <property name="dataSource" ref="dataSource1" /> <property name="packagesToScan" value="com.citi.aml.npa.domain.api" /> <property name="hibernateProperties"> <props> <prop key="hibernate.show_sql">${hibernate.show_sql}</prop> <prop key="hibernate.dialect">${hibernate.dialect}</prop> </props> </property> </bean> <bean id="xxxTransactionManagerNew" class="org.springframework.orm.hibernate4.HibernateTransactionManager"> <property name="sessionFactory" ref="sessionFactoryNew" /> <qualifier value="xxxtransaction"/> </bean> in app context.xml i have the datasources like
<beans profile="local"> <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close"> <property name="driverClassName" value="${db.oracle.driverClassName}" /> <property name="username" value="${db.oracle.username}" /> <property name="password" value="${db.oracle.password}" /> <property name="url" value="${db.oracle.url}" /> </bean> <context:property-placeholder location="classpath*:/config/local/yyy.properties" ignore-unresolvable="true"/> </beans> <beans profile="local"> <bean id="dataSource1" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close"> <property name="driverClassName" value="${db.oracle.driverClassName}" /> <property name="username" value="${db.oracle.username}" /> <property name="password" value="${db.oracle.password}" /> <property name="url" value="${db.oracle.url}" /> </bean> <context:property-placeholder location="classpath*:/config/local/xxx_db.properties" ignore-unresolvable="true"/> </beans> in Dao impl calss i have
@Repository public class OracledbTestRepository implements TestRepository { @Autowired @Qualifier(value = "sessionFactoryNew") SessionFactory sessionFactory; @SuppressWarnings("unchecked") @Override public List<xxx> getTestData() { Session session = sessionFactory.getCurrentSession(); System.out.println(sessionFactory); List<xxx> xxxTestDatas = session.createCriteria(xxx.class).list(); return xxxTestDatas; } } any help will be appreciated.
