Spring+hibernate Configuring multiple data sources

Configuration Instructions

In practical applications, read and write separations are often used, and this is where the Spring+hibernate multi-data source is configured. The configuration here only allows the Read method to manipulate a database, and write a method to manipulate the other database.

Note: My configuration of the JDBC connection here is placed in the properties file, of course you can also write directly in the Applicationcpntext.xml file or other configuration method.

Configuring step 1, configuring multiple databases

In JDBC. Properties, configure a connection for two databases. Here are the examples below (I am using MySQL here, if you want to use the other one please replace the driver):

[Java]View Plaincopy

1. # # MySQL Local
2. Jdbc.driverclassname=com.mysql.jdbc.driver
3. Jdbc.url= jdbc:mysql://localhost:3306/Database name?createdatabaseifnotexist=true&useunicode=true& Characterencoding=utf-8&zerodatetimebehavior=converttonull
4. Jdbc.username=root
5. Jdbc.password=root
7. # # MYSQL Server
8. Jdbc_t.driverclassname=com.mysql.jdbc.driver
9. Jdbc_t.url= jdbc:mysql://Server ip:3306/database name (may not be the same as above)?createdatabaseifnotexist=true&useunicode=true& Characterencoding=utf-8&zerodatetimebehavior=converttonull
10. Jdbc_t.username=root
11. jdbc_t.password= Root

Note: Jdbc.driverclassname and JDBC_ T.driverclassname can use Jdbc.driverclassname, if the use of one is in the back of the applicationcontext.xml configuration of the same can be, here to facilitate the description, separate write. Similarly, if the user name and password are the same, you can use just one configuration.

2, Configuration DataSource

The DBCP connection pool is used here.

[XHTML]View Plaincopy

2. <!--Configure the data source with the DBCP database connection pool--
4. <bean id= "DataSource" class= "Org.apache.commons.dbcp.BasicDataSource" destroy-method= "Close" >
6. <property name= "Driverclassname" value= "${jdbc.driverclassname}"/>
8. <property name= "url" value= "${jdbc.url}"/>
10. <property name= "username" value= "${jdbc.username}"/>
12. <property name= "Password" value= "${jdbc.password}"/>
14. <property name= "maxactive" value= "/>"
16. <property name= "maxwait" value= "/>"
18. <property name= "Poolpreparedstatements" value= "true"/>
20. <property name= "Defaultautocommit" value= "true"/>
22. <property name= "removeabandoned" value= "true"/>
24. <property name= "logabandoned" value= "true"/>
26. <property name= "Minevictableidletimemillis" value= "ten"/>
28. <property name= "Removeabandonedtimeout" value= "5"/>
30. </bean>
32. <bean id= "datasource_t" class= "Org.apache.commons.dbcp.BasicDataSource" destroy-method= "Close" >
34. <property name= "Driverclassname" value= "${jdbc_t.driverclassname}"/>
36. <property name= "url" value= "${jdbc_t.url}"/>
38. <property name= "username" value= "${jdbc_t.username}"/>
40. <property name= "Password" value= "${jdbc_t.password}"/>
42. <property name= "maxactive" value= "/>"
44. <property name= "maxwait" value= "/>"
46. <property name= "Poolpreparedstatements" value= "true"/>
48. <property name= "Defaultautocommit" value= "true"/>
50. <property name= "removeabandoned" value= "true"/>
52. <property name= "logabandoned" value= "true"/>
54. <property name= "Minevictableidletimemillis" value= "ten"/>
56. <property name= "Removeabandonedtimeout" value= "5"/>
58. </bean>

Note: IDs cannot be duplicated, so the latter uses datasource_t and DataSource to differentiate, so that a database can be distinguished using that one. If the above driverclassname configuration is the same, you can use jdbc.driverclassname without configuring Jdbc_t.driverclassname.

3, Configuration Sessionfactory

Please pay attention to the marked red and bold places:

[XHTML]View Plaincopy

2. <bean id= "Sessionfactory" class= "Org.springframework.orm.hibernate3.annotation.AnnotationSessionFactoryBean" >
4. <property name= "DataSource" ref= "DataSource"/>
6. <property name= "Configlocations" >
8. <list>
10. <value>classpath:hibernate.cfg.xml</value>
12. </list>
14. </property>
18. <bean id= "sessionfactory_t" class= "Org.springframework.orm.hibernate3.annotation.AnnotationSessionFactoryBean ">
20. <property name= "DataSource" ref= "datasource_t"/>
22. <property name= "Configlocations" >
24. <list>
26. <value>classpath:hibernate_t.cfg.xml</value>
28. </list>
30. </property>

Note: Hibernate.cfg.xml and Hibernate_t.cfg.xml can be based on the actual situation to see if it should be differentiated. You can also share one copy.

4. Configure DAO

When you need to use a local database (not necessarily local for your project), configure the following:

<property name= "Sessionfactory" ref= "Sessionfactory"/>

When you need to use the server's database, configure the following:

<property name= "Sessionfactory" ref= "sessionfactory_t"/>

Of course you can also configure multiple, as needed to configure more.

Spring+hibernate Configuring multiple data sources