当前页面: 开发资料首页 → J2SE 专题 → 跪求高手解答连接池问题，谢谢！！！

跪求高手解答连接池问题，谢谢！！！

摘要: 跪求高手解答连接池问题，谢谢！！！

tomcat5.5配置连接池：

jdbc3个驱动包已经拷贝到了F:/jdk1.5.0_02/jre/lib/ext和F:/tomcat5.5
/common/lib下面：
在tomcat中F:/tomcat5.5/conf/server.xml代码如下：
.........
-#60;Context path=-#34;/iosystem-#34; docBase=-#34;F:/tomcat5.5
/webapps/iosystem-#34; debug=-#34;0-#34; reloadable=-#34;true-#34;
crossContext=-#34;true-#34;-#62;
-#60;Resource name=-#34;jdbc/bn-#34; auth=-#34;Container-#34;
type=-#34;javax.sql.DataSource-#34;/-#62;
-#60;ResourceParams name=-#34;jdbc/bn-#34;-#62;
-#60;parameter-#62;
-#60;name-#62;factory-#60;/name-#62;
-#60;value-#62;org.apache.commons.dbcp.BasicDataSourceFactory-#60;/value-#62;
-#60;/parameter-#62;
-#60;parameter-#62;
-#60;name-#62;driverClassName-#60;/name-#62;
-#60;value-#62;com.microsoft.jdbc.sqlserver.SQLServerDriver-#60;/value-#62;
-#60;/parameter-#62;
-#60;parameter-#62;
-#60;name-#62;url-#60;/name-#62;
-#60;value-#62;jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=iosystem-#60;
/value-#62;
-#60;/parameter-#62;
-#60;parameter-#62;
-#60;name-#62;username-#60;/name-#62;
-#60;value-#62;sa-#60;/value-#62;
-#60;/parameter-#62;
-#60;parameter-#62;
-#60;name-#62;password-#60;/name-#62;
-#60;value-#62;-#60;/value-#62;
-#60;/parameter-#62;
-#60;parameter-#62;
-#60;name-#62;maxActive-#60;/name-#62;
-#60;value-#62;20-#60;/value-#62;
-#60;/parameter-#62;
-#60;parameter-#62;
-#60;name-#62;maxIdle-#60;/name-#62;
-#60;value-#62;10-#60;/value-#62;
-#60;/parameter-#62;
-#60;parameter-#62;
-#60;name-#62;maxWait-#60;/name-#62;
-#60;value-#62;-1-#60;/value-#62;
-#60;/parameter-#62;
-#60;/ResourceParams-#62;
-#60;/Context-#62;
-#60;/Host-#62;
-#60;/Engine-#62;
-#60;/Service-#62;
-#60;/Server-#62;
不知道是不是server.xml配置有问题，因为我用
以下方法连接是成功的。
Connection conn = null;
String url =-#34;jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=iosystem-#34;;

String user = -#34;sa-#34;;
String password = -#34;-#34;;
int count=0;
try {
Class.forName(-#34;com.microsoft.jdbc.sqlserver.SQLServerDriver-#34;).newInstance();
conn = DriverManager.getConnection(url, user, password);
Statement stmt=conn.createStatement();
ResultSet rs=stmt.executeQuery(-#34;select * from users-#34;);

恳请高手帮忙改正,最好能贴出正确的server.xml的全部代码。再次感谢！！！
tomcat报错如下：
org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create JDBC driver of cla
ss -#39;-#39; for connect URL -#39;null-#39;

---

web.xml中配置了
resource-ref-#62;
-#60;res-ref-name-#62;jdbc/bn-#60;/res-ref-name-#62;
-#60;res-type-#62;javax.sql.DataSource-#60;/res-type-#62;
-#60;res-auth-#62;Container-#60;/res-auth-#62;
-#60;/resource-ref-#62;

在程序中加上Context ctx = new InitialContext();
DataSource ds = (DataSource) ctx.lookup(-#34;java:comp/env/jdbc/bn-#34;);
Connection cn = ds.getConnection();

---

5.5.17版有个context.xml文件
在这个文件里可以进行如下配置

-#60;!-- The contents of this file will be loaded for each web application ---#62;
-#60;Context-#62;

-#60;!-- Default set of monitored resources ---#62;
-#60;WatchedResource-#62;WEB-INF/web.xml-#60;/WatchedResource-#62;

-#60;!-- Uncomment this to disable session persistence across Tomcat restarts ---#62;
-#60;!--
-#60;Manager pathname=-#34;-#34; /-#62;
---#62;


-#60;!-- 数据源 ---#62;
-#60;Resource
name=-#34;jdbc/test-#34;
type=-#34;javax.sql.DataSource-#34;
password=-#34;-#34;
driverClassName=-#34;com.mysql.jdbc.Driver-#34;
maxIdle=-#34;2-#34;
maxWait=-#34;5000-#34;
username=-#34;root-#34;
url=-#34;jdbc:mysql://localhost:3306/test?autoReconnect=true-#34;
maxActive=-#34;4-#34;/-#62;

-#60;/Context-#62;

还可以在conf/Catalina/localhost下建立一个XML文件。Tomcat会在启动的时候加载这个目录下的所有XML文件
比如有一个BookShop的工程

新建BookShop.xml

内容如下
-#60;?xml version=-#34;1.0-#34; encoding=-#34;UTF-8-#34;?-#62;
-#60;Context
docBase=-#34;D:/tomcat-5.5.17/webapps/BookShop-#34;
privileged=-#34;true-#34;-#62;
-#60;Resource
auth=-#34;Container-#34;
name=-#34;jdbc/tiwen-#34;
type=-#34;javax.sql.DataSource-#34;
password=-#34;-#34;
driverClassName=-#34;com.microsoft.jdbc.sqlserver.SQLServerDriver-#34;
maxIdle=-#34;10-#34;
maxWait=-#34;100000-#34;
username=-#34;sa-#34;
url=-#34;jdbc:microsoft:sqlserver://localhost:1433;databasename=BookShop-#34;
maxActive=-#34;20-#34;/-#62;
-#60;/Context-#62;

这样两种都可以。。试试吧

---

谢谢大家，问题已经解决了
特别要谢谢楼上的，-#60;Context-#62;...-#60;/Context-#62;直接的参数不能按我那样写

---

恭喜楼主 同时接分

---

tomcat5.0和5.5的配置方法不一样，具体差别在楼上已经写出了

---