proxool 连接多个数据库的问题
我在web应用的web-inf下新建一个xml文件,在其中写
<proxool>
<alias>test </alias>
<driver-url>jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=guitojsp</driver-url>
<driver-class>com.microsoft.jdbc.sqlserver.SQLServerDriver </driver-class>
<statistics>1m,15m,1d </statistics>
<driver-properties>
<property name="user" value="sa"/>
<property name="password" value="sa"/>
</driver-properties>
<maximum-connection-count>100 </maximum-connection-count>
<minimum-connection-count>25 </minimum-connection-count>
<maximum-active-time>8000 </maximum-active-time>
<house-keeping-test-sql>select CURRENT_DATE </house-keeping-test-sql>
</proxool>
我连的是sql2000,然后在应用的WEB-INF/lib下放proxool的jar文件,我的jar文件名是proxool-0.9.ORC3.JAR和commons-logging.jar
在WEB-INF的web.xml中添加
<servlet>
<servlet-name>ServletConfigurator </servlet-name>
<servlet-class>org.logicalcobwebs.proxool.configuration.ServletConfigurator </servlet-class>
<init-param>
<param-name>xmlFile </param-name>
<param-value>WEB-INF/proxool.xml </param-value>
</init-param>
<load-on-startup>1 </load-on-startup>
</servlet>
连接数据库时的代码
try {
String dbname="test"
Class.forName("org.logicalcobwebs.proxool.ProxoolDriver");
conn = DriverManager.getConnection("proxool."+dbname);
} catch (ClassNotFoundException e) {
// TODO 自动生成 catch 块
e.printStackTrace();
} catch (SQLException e) {
// TODO 自动生成 catch 块
e.printStackTrace();
我想连接多个数据库要怎么实现呢?我有这样写过:
<proxool>
<alias>test </alias>
<driver-url>jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=guitojsp</driver-url>
<driver-class>com.microsoft.jdbc.sqlserver.SQLServerDriver </driver-class>
<statistics>1m,15m,1d </statistics>
<driver-properties>
<property name="user" value="sa"/>
<property name="password" value="sa"/>
</driver-properties>
<maximum-connection-count>100 </maximum-connection-count>
<minimum-connection-count>25 </minimum-connection-count>
<maximum-active-time>8000 </maximum-active-time>
<house-keeping-test-sql>select CURRENT_DATE </house-keeping-test-sql>
<alias>jspsql</alias>
<driver-url>jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=guitojsp</driver-url>
<driver-class>com.microsoft.jdbc.sqlserver.SQLServerDriver </driver-class>
<statistics>1m,15m,1d </statistics>
<driver-properties>
<property name="user" value="sa"/>
<property name="password" value="sa"/>
</driver-properties>
<maximum-connection-count>100 </maximum-connection-count>
<minimum-connection-count>25 </minimum-connection-count>
<maximum-active-time>8000 </maximum-active-time>
<house-keeping-test-sql>select CURRENT_DATE </house-keeping-test-sql>
</proxool>