server.xml中 <Context path="dbpool" docBase="dbpool" debug="0" reloadable="true">
<Resource name="jdbc/dbpool" auth="Container"
type="javax.sql.DataSource"/>
<ResourceParams name="jdbc/dbpool">
<parameter>
<name>username</name>
<value>root</value>
</parameter>
<parameter>
<name>password</name>
<value></value>
</parameter>
<parameter>
<name>driverClassName</name>
<value>org.gjt.mm.mysql.Driver</value>
</parameter>
<parameter>
<name>url</name>
<value>jdbc:mysql://127.0.0.1/guestbook?autoReconnect=true</value>
</parameter>
<parameter>
<name>maxActive</name>
<value>50</value>
</parameter>
<parameter>
<name>maxIdle</name>
<value>20</value>
</parameter>
<parameter>
<name>maxWait</name>
<value>10000</value>
</parameter>
</ResourceParams>
</Context>
web.xml中<?xml version="1.0" encoding="ISO-8859-1"?><web-app xmlns="http://java.sun.com/xml/ns/j2ee"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://java.sun.com/xml/ns/j2ee http://java.sun.com/xml/ns/j2ee/web-app_2_4.xsd"
version="2.4"> <display-name>jervis</display-name>
<description>
jervis
</description>
<resource-ref>
<description>DB Connection</description>
<res-ref-name>jdbc/dbpool</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref></web-app>基本是按照tomcat的官方文档试着玩的
最后的test.jsp的用其他地方的
<%@page contentType="text/html;charset=gb2312"%>
<%@page import="java.sql.*"%>
<%@page import="javax.sql.DataSource"%>
<%@page import="javax.naming.*"%>
<html>
<body>
<%
Context initContext = new InitialContext();
Context envContext = (Context)initContext.lookup("java:/comp/env");
DataSource ds = (DataSource)envContext.lookup("jdbc/dbpool");
out.print("aaa");
//Connection conn = ds.getConnection("root","");
Connection conn=null;
try{
conn = ds.getConnection();
out.print("ccc");
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery("select * from content");
while(rs.next())
{ out.print(rs.getString(1)+" ");
}
rs.close();
stmt.close();
conn.close();
}
catch(Exception e)
{ out.print(e);}
%>
</body>
</html>
结果是老是报错:
aaaorg.apache.commons.dbcp.SQLNestedException: Cannot load JDBC driver class 'org.gjt.mm.mysql.Driver' 发现程序执行到conn = ds.getConnection();就挂了!
这是什么问题啊,郁闷啊!谁帮偶解决哈把,谢谢了!!!!!!!!
<Resource name="jdbc/dbpool" auth="Container"
type="javax.sql.DataSource"/>
<ResourceParams name="jdbc/dbpool">
<parameter>
<name>username</name>
<value>root</value>
</parameter>
<parameter>
<name>password</name>
<value></value>
</parameter>
<parameter>
<name>driverClassName</name>
<value>org.gjt.mm.mysql.Driver</value>
</parameter>
<parameter>
<name>url</name>
<value>jdbc:mysql://127.0.0.1/guestbook?autoReconnect=true</value>
</parameter>
<parameter>
<name>maxActive</name>
<value>50</value>
</parameter>
<parameter>
<name>maxIdle</name>
<value>20</value>
</parameter>
<parameter>
<name>maxWait</name>
<value>10000</value>
</parameter>
</ResourceParams>
</Context>
web.xml中<?xml version="1.0" encoding="ISO-8859-1"?><web-app xmlns="http://java.sun.com/xml/ns/j2ee"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://java.sun.com/xml/ns/j2ee http://java.sun.com/xml/ns/j2ee/web-app_2_4.xsd"
version="2.4"> <display-name>jervis</display-name>
<description>
jervis
</description>
<resource-ref>
<description>DB Connection</description>
<res-ref-name>jdbc/dbpool</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref></web-app>基本是按照tomcat的官方文档试着玩的
最后的test.jsp的用其他地方的
<%@page contentType="text/html;charset=gb2312"%>
<%@page import="java.sql.*"%>
<%@page import="javax.sql.DataSource"%>
<%@page import="javax.naming.*"%>
<html>
<body>
<%
Context initContext = new InitialContext();
Context envContext = (Context)initContext.lookup("java:/comp/env");
DataSource ds = (DataSource)envContext.lookup("jdbc/dbpool");
out.print("aaa");
//Connection conn = ds.getConnection("root","");
Connection conn=null;
try{
conn = ds.getConnection();
out.print("ccc");
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery("select * from content");
while(rs.next())
{ out.print(rs.getString(1)+" ");
}
rs.close();
stmt.close();
conn.close();
}
catch(Exception e)
{ out.print(e);}
%>
</body>
</html>
结果是老是报错:
aaaorg.apache.commons.dbcp.SQLNestedException: Cannot load JDBC driver class 'org.gjt.mm.mysql.Driver' 发现程序执行到conn = ds.getConnection();就挂了!
这是什么问题啊,郁闷啊!谁帮偶解决哈把,谢谢了!!!!!!!!
解决方案 »
- 求助,oracle修改语句
- spring依赖注入问题~急求
- linux+tomcat+mysql+java能满足WEB运行吗?
- 最新的DreamWeaver CS4中 jsp似乎无法连数据库啊?
- tomcat启动错误
- 大家来看看JB这个骗子!
- 如何配置tomcat4.1?如何更改工作路径,把自己写的jsp程序放在D:\Tomcat 4.1\webapps\ROOT以外的地方?
- 2000里的CLASSPATH中可不可以这样写:D:\ApacheGroup\Tomcat4.1\common\lib\
- 在jsp页面中的刷新问题,如果在.jsp文件中加入了插入数据的语句。那么一点刷新不就总是插入相同的一条么?如果主键是id,而id值又是递增
- 高分求助,Jsp有没有办法做得和C/S一样好用,我的e进销存做起来真要命啊,高手请进
- 使用JavaBean的简单问题
- ---->>>>大大救救我的Tomcat吧.<<<---------
http://mysql.mirror.vmmatrix.net/Downloads/Connector-J/mysql-connector-java-3.1.12.zip
然后解压得到:mysql-connector-java-3.1.12-bin.jar把它复制到 tomcat的common/lib目录下面,重新启动tomcat。