ssh配置多个数据源

SSH配置多个数据源

1.编写hibernate的数据库配置文

Mysql_hibernate.cfg.xml代码

1.<?xmlversion='1.0'encoding='UTF-8'?>

2.<!DOCTYPEhibernate-configurationPUBLIC

3."-//Hibernate/HibernateConfigurationDTD3.0//EN""http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">

4.

5.<hibernate-configuration>

6.<session-factory>

7.<propertyname="show_sql">true</property>

8.<propertyname="connection.driver_class">com.mysql.jdbc.Driver</property>

9.<propertyname="connection.url">jdbc:mysql://172.16.11.9:3306/mytest?useUnicode=true&amp;characterEncoding=utf-8</property>

10.<propertyname="connection.username">root</property>

11.<propertyname="connection.password">rootroot</property>

12.

13.<propertyname="hibernate.c3p0.max_size">20</property>

14.<propertyname="hibernate.c3p0.min_size">1</property>

15.<propertyname="hibernate.c3p0.timeout">5000</property>

16.<propertyname="hibernate.c3p0.max_statements">100</property>

17.<propertyname="hibernate.c3p0.idle_test_period">3000</property>

18.<propertyname="hibernate.c3p0.acquire_increment">2</property>

19.<!--

20.<propertyname="dialect">org.hibernate.dialect.MySQLDialect</property>

21.-->

22.<propertyname="dialect">org.hibernate.dialect.MySQLInnoDBDialect</property>

23.<propertyname="hbm2ddl.auto">create</property>

24.

25.<propertyname="hibernate.current_session_context_class">thread</property>

26.

27.

28.<mappingresource="com/test/bean/User.hbm.xml"/>

29.</session-factory>

30.</hibernate-configuration>

Sqlserver_hibernate.cfg.xml代码

1.<?xmlversion='1.0'encoding='UTF-8'?>

2.<!DOCTYPEhibernate-configurationPUBLIC

3."-//Hibernate/HibernateConfigurationDTD3.0//EN"

4."http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">

5.

6.<hibernate-configuration>

7.<session-factory>

8.<propertyname="connection.driver_class">com.microsoft.jdbc.sqlserver.SQLServerDriver</property>

9.<propertyname="connection.url">jdbc:microsoft:sqlserver://172.16.11.20:1433;DatabaseName=new_cmcc;SelectMethod=cursor</property>

10.<propertyname="connection.username">sa</property>

11.<propertyname="connection.password">111</property>

12.<propertyname="connection.pool_size">100</property>

13.<propertyname="show_sql">true</property>

14.<propertyname="dialect">org.hibernate.dialect.SQLServerDialect</property>

15.

16.<mappingresource="com/test/bean/User.hbm.xml"/>

17.</session-factory>

18.</hibernate-configuration>

Oracle_hibernate.cfg.xml代码

1.<?xmlversion='1.0'encoding='UTF-8'?>

2.<!DOCTYPEhibernate-configurationPUBLIC

3."-//Hibernate/HibernateConfigurationDTD3.0//EN"

4."http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">

5.

6.<hibernate-configuration>

7.<session-factory>

8.<propertyname="dialect">org.hibernate.dialect.Oracle9Dialect</property>

9.<propertyname="connection.url">jdbc:oracle:thin:@172.16.11.14:1521:epip</property>

10.<propertyname="connection.username">capitel</property>

11.<propertyname="connection.password">123456</property>

12.<propertyname="connection.driver_class">oracle.jdbc.driver.OracleDriver</property>

13.<propertyname="show_sql">false</property>

14.

15.<mappingresource="com/test/bean/User.hbm.xml"/>

16.</session-factory>

17.</hibernate-configuration>

2.在spring配置文件(applicationContext.xml)中配置Hibernate数据源(以测试过的三个数据库oralce,mysql,serversql为例)

Applicationcontext.xml代码

1.<!--MySql-->

2.<beanid="mySqlSessionFactory"class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">

3.<propertyname="configLocation">

4.<value>WEB-INF/classes/mysql_hibernate.cfg.xml</value>

5.</property>

6.</bean>

7.<beanid="mySqlTransactionManager"class="org.springframework.orm.hibernate3.HibernateTransactionManager">

8.<propertyname="sessionFactory">

9.<reflocal="mySqlSessionFactory"/>

10.</property>

11.</bean>

12.

13.<!--SQLServer-->

14.<beanid="sqlServerSessionFactory"class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">

15.<propertyname="configLocation">

16.<value>WEB-INF/classes/sqlserver_hibernate.cfg.xml</value>

17.</property>

18.</bean>

19.<beanid="sqlServerTransactionManager"class="org.springframework.orm.hibernate3.HibernateTransactionManager">

20.<propertyname="sessionFactory">

21.<reflocal="sqlServerSessionFactory"/>

22.</property>

23.</bean>

24.

25.<!--Oracle-->

26.<beanid="oracleSessionFactory"class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">

27.<propertyname="configLocation">

28.<value>WEB-INF/classes/oracle_hibernate.cfg.xml</value>

29.</property>

30.</bean>

31.<beanid="oracleTransactionManager"class="org.springframework.orm.hibernate3.HibernateTransactionManager">

32.<propertyname="sessionFactory">

33.<reflocal="oracleSessionFactory"/>

34.</property>

35.</bean>

3.在spring配置文件(applicationContext.xml)中配置spring的事务拦截器(AOP):

Applicationcontext.xml代码

1.<!--1、mysql数据源事务管理拦截器-->

2.<tx:adviceid="mySqlTxAdvice"transaction-manager="mySqlTransactionManager">

3.<tx:attributes>

4.<tx:methodname="find*"read-only="true"/>

5.<tx:methodname="get*"read-only="true"/>

6.<tx:methodname="notx*"propagation="NEVER"/>

7.<tx:methodname="*"rollback-for="自定义Exception"/>

8.</tx:attributes>

9.</tx:advice>

10.<!--2、sqlserver数据源事务管理拦截器-->

11.<tx:adviceid="sqlServerTxAdvice"transaction-manager="sqlServerTransactionManager">

12.<tx:attributes>

13.<tx:methodname="find*"read-only="true"/>

14.<tx:methodname="get*"read-only="true"/>

15.<tx:methodname="notx*"propagation="NEVER"/>

16.<tx:methodname="*"rollback-for="自定义Exception"/>

17.</tx:attributes>

18.</tx:advice>

19.

20.<!--3、oracle数据源事务管理拦截器-->

21.<tx:adviceid="oracleTxAdvice"transaction-manager="oracleTransactionManager">

22.<tx:attributes>

23.<tx:methodname="find*"read-only="true"/>

24.<tx:methodname="get*"read-only="true"/>

25.<tx:methodname="notx*"propagation="NEVER"/>

26.<tx:methodname="*"rollback-for="自定义Exception"/>

27.</tx:attributes>

28.</tx:advice>

29.

30.<!--配置多数据源的事务拦截器-->

31.<beanid="serviceAutoProxyCreator"class="org.springframework.aop.framework.autoproxy.BeanNameAutoProxyCreator">

32.<propertyname="beanNames">

33.<list>

34.<value>*Service</value>

35.</list>

36.</property>

37.<propertyname="interceptorNames">

38.<list>

39.<value>mySqlTxAdvice</value>

40.<value>sqlServerTxAdvice</value>

41.<value>oracleTxAdvice</value>

42.</list>

43.</property>

44.</bean>

4.DAO需要使用哪个数据,就配置相应的sessionFactory,如:

Java代码

1.<beanid="userDao"class="com.test.dao.impl.UserDAOImpl"scope="singleton">

2.<propertyname="sessionFactory">

3.<refbean="oracleSessionFactory"/>

4.</property>

5.</bean>

6.

7.<beanid="emplyDAO"class="com.test.dao.dao.impl.Pb_EmplyDAOImpl"scope="singleton">

8.<propertyname="sessionFactory">

9.<refbean="mySqlSessionFactory"/>

10.</property>

11.</bean>