spring多数据源2

mvc-dispatcher-servlet.xml

<?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:context="http://www.springframework.org/schema/context"xmlns:mvc="http://www.springframework.org/schema/mvc" xmlns:aop="http://www.springframework.org/schema/aop"xmlns:task="http://www.springframework.org/schema/task"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/mvc        http://www.springframework.org/schema/mvc/spring-mvc.xsd        http://www.springframework.org/schema/websocket        http://www.springframework.org/schema/websocket/spring-websocket.xsd       http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-3.0.xsdhttp://www.springframework.org/schema/task http://www.springframework.org/schema/task/spring-task.xsd"><context:component-scan base-package="cn" /><task:annotation-driven/><bean class="org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter"><property name="messageConverters"><list><bean class="org.springframework.http.converter.json.MappingJackson2HttpMessageConverter" /><bean class="org.springframework.http.converter.FormHttpMessageConverter" /></list></property></bean><bean class="org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping" /><aop:aspectj-autoproxy /></beans>

applicationContext-pg.xml

<?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:mvc="http://www.springframework.org/schema/mvc"xmlns:p="http://www.springframework.org/schema/websocket"xmlns:context="http://www.springframework.org/schema/context"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/mvc http://www.springframework.org/schema/mvc/spring-mvc.xsd        http://www.springframework.org/schema/websocket http://www.springframework.org/schema/websocket/spring-websocket.xsd"><context:component-scan base-package="cn" /><mvc:annotation-driven ></mvc:annotation-driven><bean id="pgDataSource" class="org.springframework.jndi.JndiObjectFactoryBean"><property name="jndiName" value="A" /><property name="resourceRef" value="true" /><property name="expectedType" value="javax.sql.DataSource" /></bean><!-- 配置hibernate SessionFactory --><bean id="pgSessionFactory" class="org.springframework.orm.hibernate4.LocalSessionFactoryBean"><property name="dataSource" ref="pgDataSource" /><property name="hibernateProperties"><props><prop key="hibernate.dialect">org.hibernate.dialect.PostgreSQL82Dialect</prop><prop key="hibernate.show_sql">true</prop><prop key="hiberante.format_sql">true</prop><prop key="hiberante.connection.autocommit">true</prop><prop key="hibernate.temp.use_jdbc_metadata_defaults">false</prop></props></property><property name="annotatedClasses"><list></list></property></bean><!-- 事务管理器 --><bean id="transactionManager"class="org.springframework.orm.hibernate4.HibernateTransactionManager"><property name="sessionFactory" ref="pgSessionFactory"></property></bean><bean id="hibernateTemplate" class="org.springframework.orm.hibernate4.HibernateTemplate"><property name="sessionFactory" ref="pgSessionFactory"></property></bean></beans>

applicationContext-oracle.xml

<?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:mvc="http://www.springframework.org/schema/mvc"xmlns:p="http://www.springframework.org/schema/websocket"xmlns:context="http://www.springframework.org/schema/context"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/mvc http://www.springframework.org/schema/mvc/spring-mvc.xsd        http://www.springframework.org/schema/websocket http://www.springframework.org/schema/websocket/spring-websocket.xsd"><context:component-scan base-package="cn" /><mvc:annotation-driven ></mvc:annotation-driven><bean id="oracleDataSource" class="org.springframework.jndi.JndiObjectFactoryBean"><property name="jndiName" value="B" /><property name="resourceRef" value="true" /><property name="expectedType" value="javax.sql.DataSource" /></bean><!-- 配置hibernate SessionFactory --><bean id="oracleSessionFactory"class="org.springframework.orm.hibernate4.LocalSessionFactoryBean"><property name="dataSource" ref="oracleDataSource" /><property name="hibernateProperties"><props><prop key="hibernate.dialect">org.hibernate.dialect.Oracle10gDialect</prop><prop key="hibernate.show_sql">true</prop><prop key="hiberante.format_sql">true</prop><prop key="hiberante.connection.autocommit">true</prop><prop key="hibernate.temp.use_jdbc_metadata_defaults">false</prop></props></property><property name="annotatedClasses"><list></list></property></bean><!-- 事务管理器 --><bean id="transactionManager"class="org.springframework.orm.hibernate4.HibernateTransactionManager"><property name="sessionFactory" ref="oracleSessionFactory"></property></bean><bean id="hibernateTemplate" class="org.springframework.orm.hibernate4.HibernateTemplate"><property name="sessionFactory" ref="oracleSessionFactory"></property></bean></beans>