使用proxool的XML连接池。请教下高手。这个问题我实在找不到原因。帮下忙~~谢谢！
<!--proxool.xml-->
<?xml version="1.0" encoding="UTF-8"?>
<!-- the proxool configuration can be embedded within your own application's.
Anything outside the "proxool" tag is ignored. -->
<something-else-entirely>
<proxool>
<alias>conn1</alias>
<driver-url>jdbc:mysql://localhost:3306/myContent</driver-url>
<driver-class>org.gjt.mm.mysql.Driver</driver-class>
<driver-properties>
<property name="user" value="HaoLing"/>
<property name="password" value="HL"/>
</driver-properties>
<statistics>1m,15m,1d</statistics>
<maximum-connection-count>100</maximum-connection-count>
<minimum-connection-count>25</minimum-connection-count>
<maximum-active-time>60000</maximum-active-time>
<house-keeping-test-sql>select CURRENT_DATE</house-keeping-test-sql>
</proxool>
</something-else-entirely>
=================================================================================
<!---web.xml->
<!--使用proxool-->
<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>
<!--使用proxool查看数据库的运行状态-->
<servlet>
<servlet-name>proxool</servlet-name>
<servlet-class>org.logicalcobwebs.proxool.admin.servlet.AdminServlet</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>proxool</servlet-name>
<url-pattern>/proxool</url-pattern>
</servlet-mapping>
</web-app>
=================================================================================
<!--GdDbConnection.java-->
/*
* 该方法用来获取数据库连接
* @see com.myContent.jdbc.DbConnection#getConnection(java.lang.Object)
*/
public Connection getConnection(Object obj) throws SQLException, ClassNotFoundException {
try{
if(this.objId == obj && this.conn != null && !isClosed()){
System.out.println("*********************连接数据成功！*********************");
return conn;
}
else{
Class.forName("org.logicalcobwebs.proxool.ProxoolDriver");
conn = DriverManager.getConnection("proxool.conn1");
System.out.println("*********************连接数据成功！*********************");
}
}catch(SQLException e){
throw new SQLException("获取数据库连接失败" + obj.getClass().getName() + e);
}catch(Exception e){
System.out.println("GdDbConnection class：getConnection(Object obj) method ERROR--: "+e);
}
return conn;
}
=================================================================================
请问这下面的写法有错嘛？？
Class.forName("org.logicalcobwebs.proxool.ProxoolDriver");
conn = DriverManager.getConnection("proxool.conn1");
为什么老报 别名错误啊。我的。proxool.xml 里声明的和这里的别名一样啊。我实在找不到原因了。
去掉Class.forName("org.logicalcobwebs.proxool.ProxoolDriver");这句话也不对。
我使用原始的方法：
Class.forName("org.logicalcobwebs.proxool.ProxoolDriver");
conn = DriverManager.getConnection("proxool.gd:com.mysql.jdbc.Driver:jdbc:mysql://localhost:3306/myContent","HaoLing","HL");
这样写的话。数据库连接就是正常的。为什么用上面的方法写。就不对啊。
郁闷啊。请教下高人。谢谢~~~~~~~~~~~~~~~~~~
