tomcat mysql连接池 我已按照tomcat 文档上做的 但还是错！
我用tomcat 配置了一个mysql连接池
server.xml 内容为
<!--mysql Root Context -->
<Context path="myweb" docBase="/myweb">
<Resource name="jdbc/sqldb" auth="Container" type="javax.sql.DataSource"/>
<ResourceParams name="jdbc/sqldb">
<parameter>
<name>factory</name>
<value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
</parameter>
<!-- DBCP database connection settings -->
<parameter>
<name>url</name>
<value>jdbc:mysql://localhost/test</value>
</parameter>
<parameter>
<name>driverClassName</name>
<value>org.gjt.mm.mysql.Driver</value>
</parameter>
<parameter>
<name>username</name>
<value>root</value>
</parameter>
<parameter>
<name>password</name>
<value></value>
</parameter>
<!-- DBCP connection pooling options -->
<parameter>
<name>maxWait</name>
<value>5000</value>
</parameter>
<parameter>
<name>maxIdle</name>
<value>2</value>
</parameter>
<parameter>
<name>maxActive</name>
<value>4</value>
</parameter>
</ResourceParams>
</Context>
web.xml 内容为
<description>MySQL Test App</description>
<resource-ref>
<description>DB Connection</description>
<res-ref-name>jdbc/sqldb</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>
测试用的jsp 内容为
<%@ page contentType="text/html;charset=GBK"%>
<%@ page import= "java.sql.* "%>
<%@ page import= "javax.naming.* "%>
<%@ page import= "javax.sql.*"%>
<%
try{
InitialContext ic = new InitialContext();
DataSource ds = (DataSource)ic.lookup("java:comp/env/jdbc/sqldb");
Connection conn = ds.getConnection();
Statement stmt = conn.createStatement();
String strSql = " insert into test(id,name) values('00001','fany')";
stmt.executeUpdate(strSql);
strSql = " select id,name from test ";
ResultSet rs = stmt.executeQuery(strSql);
if(rs.next()){
out.println(rs.getString(1));
out.println(rs.getString(2));
}
System.out.println("test is successful");
}catch(Exception ex){
ex.printStackTrace();
throw new SQLException("cannot get Connection pool.");
}
%>
运行时报错
java.sql.SQLException: Cannot load JDBC driver class 'null'
at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSou
rce.java:529)
at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource
.java:312)
at org.apache.jsp.index_jsp._jspService(index_jsp.java:61)
我已把mysql的jdbc 驱动 mm.mysql-2.0.14-bin.jar放在 Tomcat 4.1\common\lib下为何还是说 找不到JDBC driver 呢？
tomcat 的版本为4.1.24
问题点数：0、回复次数：4Top
1 楼newpaul（）回复于 2003-08-02 06:34:06 得分 0
upTop
2 楼naxin（痴呆男人--我痴呆,我自豪!!）回复于 2003-08-02 08:33:27 得分 0
楼主啊, 请参考我的这篇文章:
http://www.csdn.net/Develop/read_article.asp?id=19196Top
3 楼xqi8（星期八）回复于 2003-08-02 08:34:09 得分 0
学习~Top
4 楼luckyfanjian（luckyfan）回复于 2003-08-02 08:47:10 得分 0
把他同时放到你的工程的web-inf/lib目录下！Top
5 楼naxin（痴呆男人--我痴呆,我自豪!!）回复于 2003-08-02 09:00:34 得分 0
<value>jdbc:mysql://localhost:3306/test</value>
没写3306端口号
Top
