iBatis如何连接多个数据库

Question

现在Struts+iBatis的测试程序正常。但目前配置是仅指定的一个数据库。我想连接多个数据库，该如何配置？
SQL MAP文件 部分如下： <settings cacheModelsEnabled="true" enhancementEnabled="true"
lazyLoadingEnabled="true" maxRequests="32" maxSessions="10"
maxTransactions="5" useStatementNamespaces="true" /> <transactionManager type="JDBC">
<dataSource type="SIMPLE">
<property name="JDBC.Driver"
value="oracle.jdbc.driver.OracleDriver" />
<property name="JDBC.ConnectionURL"
value="jdbc:oracle:thin:@【myIP】:1521:【数据库名】" />
<property name="JDBC.Username" value="【用户名】" />
<property name="JDBC.Password" value="【密码】" /> <property name="Pool.MaximumActiveConnections" value="10" />
<property name="Pool.MaximumIdleConnections" value="5" />
<property name="Pool.MaximumCheckoutTime" value="120000" />
<property name="Pool.TimeToWait" value="10000" />
<property name="Pool.PingQuery" value="select * from dual" />
<property name="Pool.PingEnabled" value="false" />
<property name="Pool.PingConnectionsOlderThan" value="0" />
<property name="Pool.PingConnectionsNotUsedFor" value="0" />
</dataSource>
</transactionManager>

Answer 1

你在程序中有选择resource指向哪个xml文件吗？

Answer 2

用JTA试一下,好像是配置两个数据源
<transactionManager type="JTA" >
<property name="UserTransaction" value="java:/ctx/con/UserTransaction"/>
<dataSource type="JNDI">
<property name="DataSource1" value="java:comp/env/jdbc/jpetstore"/>
<property name="DataSource2" value="java:comp/env/jdbc/jpetstore2"/>
</dataSource>
</transactionManager>

Answer 3

不用JTA 下的JNDI就没有办法了吗？？？

Answer 4

按有几个群，你不妨加进去,可以和大家一起讨论啊.........46986340,28039577,4804620                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               
在那里看看有无能回答你的,谢谢,LZ,甭忘了给俺分哦,谢谢LZ

Answer 5

你连数据库               String resource = "ConfigXML/sql_map_config.xml";               com.ibatis.sqlmap.client.SqlMapClient sqlMap = null;               try {                      java.io.Reader reader = com.ibatis.common.resources.Resources.getResourceAsReader(resource);                      sqlMap = SqlMapClientBuilder.buildSqlMapClient(reader);               } catch (Exception e) {                      e.printStackTrace();               }是不是这样连?  sql_map_config.xml对应数据库连接 你写多个配置文件不就完了？ 想连哪个加载哪个不就OK了？

Answer 6

按有几个群，你不妨加进去,可以和大家一起讨论啊.........46986340,28039577,4804620                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               
在那里看看有无能回答你的,谢谢,LZ,甭忘了给俺分哦,谢谢LZ