关于spring+hibernate配置多个数据源的问题

 由于项目需要在多个数据库中进行开发 所以今天在网上找找了多个数据源同时并存的开发模式

其实也很简单  只不过是多增加了一个数据源而已

更改他的sessionFactory，hibernateTemplate，以及dataSource即可

在引用时注意dao调用的hibernateTemplate即可

1. <?xml version="1.0" encoding="UTF-8"?>
2. <beans
3.     xmlns="http://www.springframework.org/schema/beans"
4.     xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
5.     xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-2.5.xsd">
8.     <bean id="dataSource"
9.         class="org.apache.commons.dbcp.BasicDataSource">
10.         <property name="driverClassName"
11.             value="com.mysql.jdbc.Driver">
12.         </property>
13.         <property name="url" value="jdbc:mysql://localhost:3306/jxt"></property>
14.         <property name="username" value="1111"></property>
15.         <property name="password" value="2222"></property>
16.     </bean>
17.     <bean id="sessionFactory"
18.         class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
19.         <property name="dataSource">
20.             <ref bean="dataSource" />
21.         </property>
22.         <property name="hibernateProperties">
23.             <props>
24.                 <prop key="hibernate.dialect">
25.                     org.hibernate.dialect.MySQLDialect
26.                 </prop>
27.             </props>
28.         </property>
29.         <property name="mappingResources">
30.             <list>
31.             
32.                 <value>com/vo/User.hbm.xml</value>
33.                 </list>
34.         </property></bean>
35.         
36.              <bean id="hibernateTemplate"
37.         class="org.springframework.orm.hibernate3.HibernateTemplate"
38.         abstract="false" lazy-init="default" autowire="default"
39.         dependency-check="default">
40.         <property name="sessionFactory">
41.             <ref bean="sessionFactory" />
42.         </property>
43.     </bean>
45.     <bean id="oraDataSource"
46.     class="org.apache.commons.dbcp.BasicDataSource">
47.         <property name="driverClassName"
48.             value="oracle.jdbc.driver.OracleDriver">
49.         </property>
50.         <property name="url"
51.             value="jdbc:oracle:thin:@192.168.0.215:1521:orcl">
52.         </property>
53.         <property name="username" value="1111"></property>
54.         <property name="password" value="2222"></property>
55.     </bean>
56.     <bean id="oraSessionFactory"
57.         class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
58.         <property name="dataSource">
59.             <ref bean="oraDataSource" />
60.         </property>
61.         <property name="hibernateProperties">
62.             <props>
63.                 <prop key="hibernate.dialect">
64.                         org.hibernate.dialect.Oracle9Dialect
65.                 </prop>
66.             </props>
67.         </property>
68.         <property name="mappingResources">
69.             <list>
70.             <value>com/vo/Test.hbm.xml</value>
71.                 </list>
72.         </property></bean>
73.         <bean id="oraHibernateTemplate"
74.         class="org.springframework.orm.hibernate3.HibernateTemplate"
75.         abstract="false" lazy-init="default" autowire="default"
76.         dependency-check="default">
77.         <property name="sessionFactory">
78.             <ref bean="oraSessionFactory" />
79.         </property>
80.         </bean>
82.     <bean id="userDao" class="com.dao.IUserDao" abstract="true"></bean>
83.     <bean id="userDaoImpl" class="com.dao.impl.UserDAO" parent="userDao" abstract="false"
84.         lazy-init="default" autowire="default" dependency-check="default">
85.         <property name="hibernateTemplate">
86.             <ref bean="hibernateTemplate" />
87.         </property>
88.     </bean>
89.     
90.     <bean id="userService" class="com.service.IUserService" abstract="true"></bean>
91.     
92.     <bean id="userServiceImpl" class="com.service.impl.UserServiceImpl" parent="userService" abstract="false"
93.         lazy-init="default" autowire="default" dependency-check="default">
94.         <property name="userDao">
95.             <ref bean="userDaoImpl" />
96.         </property>
97.     </bean>
98.     <bean name="/user" class="com.ncjk.struts.action.UserAction" abstract="false" lazy-init="default"
99.         autowire="default" dependency-check="default">
100.         <property name="userService">
101.             <ref bean="userServiceImpl" />
102.         </property>
103.     </bean> 
104.     
105.     
106.     <bean id="testDao" class="com.dao.ITestDao" abstract="true"></bean>
107.     <bean id="testDaoImpl" class="com.dao.impl.TestDAO" parent="testDao" abstract="false"
108.         lazy-init="default" autowire="default" dependency-check="default">
109.             <property name="hibernateTemplate">
110.             <ref bean="oraHibernateTemplate" />
111.         </property>
112.     </bean>
113.     <bean id="testService" class="com.service.ITestService" abstract="true"></bean>
114.     
115.     <bean id="testServiceImpl" class="com.service.impl.TestServiceImpl" parent="testService" abstract="false"
116.         lazy-init="default" autowire="default" dependency-check="default">
117.         <property name="testDao">
118.             <ref bean="testDaoImpl" />
119.         </property>
120.     </bean> 
121.     <bean name="/test" class="com.ncjk.struts.action.TestAction" abstract="false" lazy-init="default"
122.         autowire="default" dependency-check="default">
123.         <property name="testService">
124.             <ref bean="testServiceImpl" />
125.         </property>
126.     </bean>
127. </beans>

以上就是连接oracle和mysql的实例  测试成功 还有就是要注意一些低级错误 NND  今天一个dao没实现报了一大堆莫名其妙的错误  呵呵  如果有问题回帖吧