Question

>>proxooll连接池问题

proxool.xml配置如下：
<something-else-entirely>
<proxool>
<alias>dbs</alias>
<driver-url>jdbc:mysql://localhost:3306/libdb</driver-url>
<driver-class>com.mysql.jdbc.Driver</driver-class>
<driver-properties>
<property name="user" value="root"/>
<property name="password" value="sa"/>
</driver-properties>
<!-- <house-keeping-test-sql>
select CURRENT_DATE
</house-keeping-test-sql>-->
<maximum-connection-count>10</maximum-connection-count>
</proxool>
</something-else-entirely>

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>

<servlet>
<servlet-name>admin</servlet-name>
<servlet-class>org.logicalcobwebs.proxool.admin.servlet.AdminServlet</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>admin</servlet-name>
<url-pattern>/admin</url-pattern>
</servlet-mapping>

测试类：

import java.sql.*;
public class Dbc {

Connection conn;
PreparedStatement ps;
Statement stmt;
ResultSet rs;
int num;

public Dbc() {
try {
conn = DriverManager.getConnection("proxool.dbs");
if (conn != null) {
System.out.println("=============Success.");
} else {
System.out.println("===============Fail.");
}
ps = null;
stmt = conn.createStatement();
rs = null;
num = 0;
} catch (Exception e) {
System.out.println("==========" + e);
}
}

public static void main(String agrs[]) {
new Dbc();
}
}

异常：java.sql.SQLException: No suitable driver found for proxool.dbs

所用jar包：
mysql-connector-java-5.1.5-bin.jar
commons-logging.jar
proxool-0.9.1.jar

＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝
求解？

Answer 1

异常说没找到合适的驱动
所以貌似还是缺少某个jar包啊
刚看网上有人说缺少proxool-pool.jar包
你试试

Answer 2

少了一个jar包：proxool-cglib.jar