How to configure multiple data sources for ibatis

How to configure multiple data sources for ibatis

Document category: Database

1. applicationcontext. xml Java code

1. <! -- Define the data source datasource -->
2. <Bean id = "datasource"
3. Class = "org. Apache. commons. DBCP. basicdatasource">
4. <Property name = "driverclassname"
5. Value = "ianywhere. ml. jdbcodbc. jdbc3.idriver">
6. </Property>
7. <Property name = "url"
8. Value = "JDBC: ODBC: Driver = SQL Anywhere 11; Eng = ZYX; links = TCPIP {Host = 10.144.99.46; Port = 2998};">
9. </Property>
10. <Property name = "username" value = "ZYX"> </property>
11. <Property name = "password" value = "ZYX"> </property>
12. <Property name = "initialsize" value = "1"> </property>
13. <Property name = "maxactive" value = "500"> </property>
14. <Property name = "maxidle" value = "5"> </property>
15. <Property name = "minidle" value = "1"> </property>
16. </Bean>
18. <! -- Define the data source Oracle -->
19. <Bean id = "ceceoracle" class = "org. Apache. commons. DBCP. basicdatasource">
20. <Property name = "driverclassname" value = "oracle. JDBC. Driver. oracledriver"> </property>
21. <Property name = "url" value = "JDBC: oracle: thin: @ 10.144.99.114: 1521/sanexcfg"> </property>
22. <Property name = "username" value = "sanex"> </property>
23. <Property name = "password" value = "sanex"> </property>
24. <Property name = "initialsize" value = "1"> </property>
25. <Property name = "maxactive" value = "500"> </property>
26. <Property name = "maxidle" value = "5"> </property>
27. <Property name = "minidle" value = "1"> </property>
28. </Bean>
30. <! -- Define the data source sqlserver datasource -->
31. <Bean id = "datasourcesqlserver"
32. Class = "org. Apache. commons. DBCP. basicdatasource">
34. <Property name = "driverclassname"
35. Value = "com. Microsoft. JDBC. sqlserver. sqlserverdriver">
36. </Property>
37. <Property name = "url"
38. Value = "JDBC: Microsoft: sqlserver: // 10.71.158.50: 1433; databasename = mon;">
39. </Property>
40. <Property name = "username" value = "sa"> </property>
41. <Property name = "password" value = "sa"> </property>
43. <Property name = "initialsize" value = "1"> </property>
44. <Property name = "maxactive" value = "500"> </property>
45. <Property name = "maxidle" value = "5"> </property>
46. <Property name = "minidle" value = "1"> </property>
47. </Bean>
48. <! -- Configure sqlmapclient of ibatis -->
49. <Bean id = "sqlmapclient"
50. Class = "org. springframework. Orm. ibatis. sqlmapclientfactorybean">
51. <Property name = "configlocation"
52. Value = "/WEB-INF/sqlmapconfig. xml"/>
53. <Property name = "datasource" ref = "datasource"/>
54. </Bean>
55. <Bean id = "sqlmapclientorac"
56. Class = "org. springframework. Orm. ibatis. sqlmapclientfactorybean">
57. <Property name = "configlocation"
58. Value = "/WEB-INF/sqlmapconfig. xml"/>
59. <Property name = "datasource" ref = "ceceoracle"/>
60. </Bean>

<! -- Define the data source datasource --> <bean id = "datasource" class = "org. apache. commons. DBCP. basicdatasource "> <property name =" driverclassname "value =" ianywhere. ML. jdbcodbc. jdbc3.idriver "> </property> <property name =" url "value =" JDBC: ODBC: Driver = SQL Anywhere 11; Eng = ZYX; links = TCPIP {Host = 10.144.99.46; port = 2998 }; "> </property> <property name =" username "value =" ZYX "> </property> <property name =" password "value =" ZYX "> </property> <PR Operty name = "initialsize" value = "1" type = "codeph" text = "codeph"> </property> <property name = "maxactive" value = "500" type = "codeph" text = "/codeph"> <property name = "maxidle" value = "5"> </property> <property name = "minidle" value = "1"> </property> </bean> <! -- Define the data source Oracle --> <bean id = "ceceoracle" class = "org. apache. commons. DBCP. basicdatasource "> <property name =" driverclassname "value =" oracle. JDBC. driver. oracledriver "> </property> <property name =" url "value =" JDBC: oracle: thin: @ 10.144.99.114: 1521/sanexcfg "> </property> <property name =" username "value =" sanex "> </property> <property name =" password "value =" sanex "> </property> <property name = "initialsize" value =" 1 "> </property> <property name =" maxactive "value =" 500 "> </property> <property name =" maxidle "value =" 5 "> </Property> <property name = "minidle" value = "1"> </property> </bean> <! -- Define the data source sqlserver datasource --> <bean id = "datasourcesqlserver" class = "org. apache. commons. DBCP. basicdatasource "> <property name =" driverclassname "value =" com. microsoft. JDBC. sqlserver. sqlserverdriver "> </property> <property name =" url "value =" JDBC: Microsoft: sqlserver: // 10.71.158.50: 1433; databasename = mon; "> </property> <property name =" username "value =" sa "> </property> <property name =" password "value =" sa "> </proper Ty> <property name = "initialsize" value = "1"> </property> <property name = "maxactive" value = "500"> </property> <property name = "maxidle" value = "5"> </property> <property name = "minidle" value = "1"> </property> </bean> <! -- Configure sqlmapclient of ibatis --> <bean id = "sqlmapclient" class = "org. springframework. orm. ibatis. sqlmapclientfactorybean "> <property name =" configlocation "value ="/WEB-INF/sqlmapconfig. XML "/> <property name =" datasource "ref =" datasource "/> </bean> <bean id =" sqlmapclientorac "class =" org. springframework. orm. ibatis. sqlmapclientfactorybean "> <property name =" configlocation "value ="/WEB-INF/sqlmapconfig. XML "/> <property name =" datasource "ref =" ceceoracle "/> </bean>

2. Nothing is set in the sqlmapconfig. xml file. Only the custom query XML file is placed.

3. spring annotations are used in the Code. The name in the resource must correspond to applicationcontext. the bean ID in XML, which can find the corresponding bean and reference the Java code of the data source you want to operate on.

1. @ Resource (name = "sqlmapclient ")
2. Private sqlmapclient;
4. @ Resource (name = "sqlmapclientorac ")
5. Private sqlmapclient sqlmapclientorac;
7. Public void executesp (MAP map) throws exception {
8. Sqlmapclient. queryforlist ("userpercept. useranalyse. addusefulprocedure", MAP );
9. }
11. Public list <cell> getcelllist () throws exception {
12. Return sqlmapclientorac. queryforlist ("userpercept. useranalyse. getcelllist ");
13. }
15. Public placecell getcell (long ID) throws exception {
16. Placecell cell = (placecell) sqlmapclient
17. . Queryforobject ("userpercept. useranalyse. selectcell", ID );
18. Return cell;
19. }