Configure multiple data sources in hibernate

 

 

<?xml version="1.0" encoding="UTF-8"?><beans xmlns="http://www.springframework.org/schema/beans"    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"    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-2.0.xsd    http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-2.0.xsd    http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-2.0.xsd"><bean id="propertyConfigurer" class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">    <property name="locations"><list><value>classpath:configure.properties</value><value>classpath:resources.properties</value></list>     </property></bean><bean id="nativeJdbcExtractor" class="org.springframework.jdbc.support.nativejdbc.C3P0NativeJdbcExtractor"/><bean id="oracleLobHandler" class="org.springframework.jdbc.support.lob.OracleLobHandler"><property name="nativeJdbcExtractor" ref="nativeJdbcExtractor"/></bean><bean id="sessionFactory" class="org.rd.framework.hibernate.ConfigurableSessionFactoryBean"><property name="hibernateProperties"><props><prop key="hibernate.dialect">${hibernate.dialect}</prop><prop key="hibernate.query.substitutions">true=1,false=0</prop><prop key="hibernate.jdbc.batch_size">25</prop><prop key="hibernate.show_sql">true</prop><prop key="hibernate.format_sql">false</prop><prop key="hibernate.generate_statistics">false</prop><prop key="hibernate.cache.use_query_cache">false</prop><prop key="hibernate.cache.region_prefix">direct</prop><prop key="hibernate.cache.use_structured_entries">false</prop> <prop key="hibernate.cache.provider_class">org.hibernate.cache.EhCacheProvider</prop><prop key="hibernate.query.factory_class">org.hibernate.hql.ast.ASTQueryTranslatorFactory</prop> <prop key="hibernate.transaction.factory_class">org.hibernate.transaction.JDBCTransactionFactory</prop></props></property><property name="dataSource"       ref="dataSource"/><property name="mappingResources" ref="mappingResources"/><property name="lobHandler"       ref="oracleLobHandler"/></bean><bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource" destroy-method="close"><property name="maxPoolSize" value="${c3p0.maxPoolSize}"/><property name="minPoolSize" value="${c3p0.minPoolSize}"/><property name="maxIdleTime" value="${c3p0.maxIdleTime}"/><property name="maxStatements" value="${c3p0.maxStatements}"/><property name="acquireIncrement" value="${c3p0.acquireIncrement}"/><property name="idleConnectionTestPeriod" value="${c3p0.idleConnectionTestPeriod}"/><property name="driverClass" value="${jdbc.driverClassName}"/><property name="jdbcUrl" value="${jdbc.url}"/><property name="user" value="${jdbc.username}"/><property name="password" value="${jdbc.password}"/></bean><bean id="sessionFactoryItsm" class="org.rd.framework.hibernate.ConfigurableSessionFactoryBean"><property name="hibernateProperties"><props><prop key="hibernate.dialect">${hibernate.dialect}</prop><prop key="hibernate.query.substitutions">true=1,false=0</prop><prop key="hibernate.jdbc.batch_size">25</prop><prop key="hibernate.show_sql">true</prop><prop key="hibernate.format_sql">false</prop><prop key="hibernate.generate_statistics">false</prop><prop key="hibernate.cache.use_query_cache">false</prop><prop key="hibernate.cache.region_prefix">direct</prop><prop key="hibernate.cache.use_structured_entries">false</prop> <prop key="hibernate.cache.provider_class">org.hibernate.cache.EhCacheProvider</prop><prop key="hibernate.query.factory_class">org.hibernate.hql.ast.ASTQueryTranslatorFactory</prop> <prop key="hibernate.transaction.factory_class">org.hibernate.transaction.JDBCTransactionFactory</prop></props></property><property name="dataSource"       ref="dataSourceItsm"/><property name="mappingResources" ref="mappingResources"/><property name="lobHandler"       ref="oracleLobHandler"/></bean><bean id="dataSourceItsm" class="com.mchange.v2.c3p0.ComboPooledDataSource" destroy-method="close"><property name="maxPoolSize" value="${c3p0.maxPoolSize}"/><property name="minPoolSize" value="${c3p0.minPoolSize}"/><property name="maxIdleTime" value="${c3p0.maxIdleTime}"/><property name="maxStatements" value="${c3p0.maxStatements}"/><property name="acquireIncrement" value="${c3p0.acquireIncrement}"/><property name="idleConnectionTestPeriod" value="${c3p0.idleConnectionTestPeriod}"/><property name="driverClass" value="${jdbc.driverClassName}"/><property name="jdbcUrl" value="${itsm.jdbc.url}"/><property name="user" value="${itsm.jdbc.username}"/><property name="password" value="${itsm.jdbc.password}"/></bean><bean id="transactionManagerItsm" class="org.springframework.orm.hibernate3.HibernateTransactionManager"><property name="sessionFactory" ref="sessionFactoryItsm"/></bean><bean id="transactionProxyTemplateItsm" class="org.springframework.transaction.interceptor.TransactionProxyFactoryBean" abstract="true"><property name="transactionManager" ref="transactionManagerItsm"/><property name="transactionAttributes"><props><prop key="get*">PROPAGATION_REQUIRED</prop><prop key="query*">PROPAGATION_REQUIRED</prop><prop key="*">PROPAGATION_REQUIRED</prop></props></property></bean><bean id="transactionManager" class="org.springframework.orm.hibernate3.HibernateTransactionManager"><property name="sessionFactory" ref="sessionFactory"/></bean><bean id="transactionProxyTemplate" class="org.springframework.transaction.interceptor.TransactionProxyFactoryBean" abstract="true"><property name="transactionManager" ref="transactionManager"/><property name="transactionAttributes"><props><prop key="get*">PROPAGATION_REQUIRED</prop><prop key="query*">PROPAGATION_REQUIRED</prop><prop key="*">PROPAGATION_REQUIRED</prop></props></property></bean>       <bean id="jdbcTemplateItsm" class="org.springframework.jdbc.core.JdbcTemplate">        <property name="dataSource">        <ref bean="dataSourceItsm"/>        </property>       </bean><bean id="jdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate">          <property name="dataSource">        <ref bean="dataSource"/>          </property>        </bean>        </beans>

Use different data sources to configure in the interface

Use Data Source

<?xml version="1.0" encoding="UTF-8"?><beans xmlns="http://www.springframework.org/schema/beans"    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"    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-2.0.xsd    http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-2.0.xsd    http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-2.0.xsd"> <bean id="HDLoginService" parent="transactionProxyTemplate">  <property name="target">   <bean class="org.hd.login.service.impl.LoginServiceImpl">    <property name="sessionFactory">     <ref bean="sessionFactory"/>    </property>   </bean>  </property>  <property name="proxyInterfaces">   <value>org.hd.login.service.LoginService</value>  </property> </bean></beans>

Use the data source performanceitsm

<?xml version="1.0" encoding="UTF-8"?><beans xmlns="http://www.springframework.org/schema/beans"    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"    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-2.0.xsd    http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-2.0.xsd    http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-2.0.xsd"><bean id="businessServiceItsm" parent="transactionProxyTemplate"><property name="target"><bean class="org.hd.business.service.impl.BusinessServiceImplItsm"><property name="sessionFactory"><ref bean="sessionFactoryItsm"/></property></bean></property><property name="proxyInterfaces"><value>org.hd.business.service.BusinessServiceItsm</value></property></bean><bean id="businessService" parent="transactionProxyTemplate"><property name="target"><bean class="org.hd.business.service.impl.BusinessServiceImpl"><property name="sessionFactory"><ref bean="sessionFactory"/></property></bean></property><property name="proxyInterfaces"><value>org.hd.business.service.BusinessService</value></property></bean></beans>