我的tomcat是6.0版本。tomcat的dbcp和mysql的jdbc驱动已经放到tomcat的lib目录下和项目的web-inf的lib下。配置连接池如下:
server.xml:
<Context path="/HelloWorld" reloadable="true" docBase="D:\eclipse\workspace\HelloWorld" crosscontext="true" workDir="D:\eclipse\workspace\HelloWorld\work" >
<Resource name="jdbc/student" auth="Container"
type="javax.sql.DataSource"/>
<ResourceParams name="jdbc/student">
<parameter>
<name>factory</name>
<value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
</parameter>
<parameter>
<name>username</name>
<value>root</value>
</parameter>
<parameter>
<name>password</name>
<value>sa</value>
</parameter>
<parameter>
<name>driverClassName</name>
<value>com.mysql.jdbc.Driver</value>
</parameter>
<parameter>
<name>url</name>
<value>jdbc:mysql://localhost:3306/student?useUnicode=true&characterEncoding=UTF-8</value>
</parameter>
<parameter>
<name>maxActive</name>
<value>20</value>
</parameter>
<parameter>
<name>maxIdle</name>
<value>5</value>
</parameter>
<parameter>
<name>maxWait</name>
<value>10000</value>
</parameter>
</ResourceParams>
</Context>web.xml:
<resource-ref>
<res-ref-name>jdbc/student</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>jsp中访问:
Context initContext = new InitialContext();
Context envContext = (Context)initContext.lookup("java:/comp/env");
DataSource ds = (DataSource)envContext.lookup("jdbc/student");
con = ds.getConnection();
stmt = con.createStatement();
String upd = "INSERT INTO stud(StuID, stuName) VALUES ("+ first_name + ", '"+last_name + "')";
stmt.executeUpdate(upd);
stmt1 = con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE);
String query = "SELECT * FROM stud";
rs = stmt1.executeQuery(query);
rs.last( );
new_last_name = rs.getString("StuID");
new_first_name = rs.getString("stuName");提示错误:sqle=org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create JDBC driver of class '' for connect URL 'null'
我配了几天了,还是没办法。网上的办法都试过,不行。
server.xml:
<Context path="/HelloWorld" reloadable="true" docBase="D:\eclipse\workspace\HelloWorld" crosscontext="true" workDir="D:\eclipse\workspace\HelloWorld\work" >
<Resource name="jdbc/student" auth="Container"
type="javax.sql.DataSource"/>
<ResourceParams name="jdbc/student">
<parameter>
<name>factory</name>
<value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
</parameter>
<parameter>
<name>username</name>
<value>root</value>
</parameter>
<parameter>
<name>password</name>
<value>sa</value>
</parameter>
<parameter>
<name>driverClassName</name>
<value>com.mysql.jdbc.Driver</value>
</parameter>
<parameter>
<name>url</name>
<value>jdbc:mysql://localhost:3306/student?useUnicode=true&characterEncoding=UTF-8</value>
</parameter>
<parameter>
<name>maxActive</name>
<value>20</value>
</parameter>
<parameter>
<name>maxIdle</name>
<value>5</value>
</parameter>
<parameter>
<name>maxWait</name>
<value>10000</value>
</parameter>
</ResourceParams>
</Context>web.xml:
<resource-ref>
<res-ref-name>jdbc/student</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>jsp中访问:
Context initContext = new InitialContext();
Context envContext = (Context)initContext.lookup("java:/comp/env");
DataSource ds = (DataSource)envContext.lookup("jdbc/student");
con = ds.getConnection();
stmt = con.createStatement();
String upd = "INSERT INTO stud(StuID, stuName) VALUES ("+ first_name + ", '"+last_name + "')";
stmt.executeUpdate(upd);
stmt1 = con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE);
String query = "SELECT * FROM stud";
rs = stmt1.executeQuery(query);
rs.last( );
new_last_name = rs.getString("StuID");
new_first_name = rs.getString("stuName");提示错误:sqle=org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create JDBC driver of class '' for connect URL 'null'
我配了几天了,还是没办法。网上的办法都试过,不行。
解决方案 »
- JQuery联动 怎么接受后台传来的数据?帮帮忙!
- Java网页正文抽取问题
- hashmap 从list中得到数据的问题??????????
- 大姐求救:我用的是JBOSS,当出现汉字“祎”等的字时,显示“\u794e”,怎么办,如何解决?
- 请教open(url,"loader"),open(url,"_blank")参数的含义,
- ssh报错
- 求JasperReports与ireport的详细文档
- 我是一个JSP新手,想请教一个问题,望各位高手赐教!
- 我的tomcat好像出了问题!
- 使用strtus2竟然连helloworld程序都运行不通了
- struts 和 struts2 有那些不一样的地方?
- Cell组件/插件 解决报表开发的问题!
jdbc:mysql://localhost:3306/student?useUnicode=true&characterEncoding=UTF-8
拿你看看这个是不是有问题你确定下面有student??
maxActive="100" maxIdle="30" maxWait="10000"
username="javauser" password="javadude" driverClassName="com.mysql.jdbc.Driver"
url="jdbc:mysql://localhost:3306/javatest?autoReconnect=true"/>