Cannot create JDBC driver of class '' for connect URL 'null'

今天搞tomcat5.528配置数据源连接池,在tomcat admin的界面上配置好以后,写了一个serverlet测试,结果报了一个Cannot create JDBC driver of class '' for connect URL 'null'的错,

org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create JDBC driver of class '' for connect URL 'null'
 at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1150)
 at org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880)
 at test.TestServerlet.service(TestServerlet.java:29)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
 at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
 at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:172)
 at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
 at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
 at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
 at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174)
 at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:873)
 at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)
 at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)
 at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
 at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)
 at java.lang.Thread.run(Thread.java:595)
Caused by: java.sql.SQLException: No suitable driver
 at java.sql.DriverManager.getDriver(DriverManager.java:243)
 at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1143)
 ... 17 more

,在网上一搜,都说5.5配都出错,有的说换了版本就没出现这个错了,我觉肯定是哪里配置不对,并不是版本不支持,java.sql.SQLException: No suitable driver
看了这段还错以为是mysql的驱动版本不对,又换了一个还是一样,后来在网上找到一个人说"然后在WebApp的Context.xml中加入"这里配置,我查找了一下context.xml这个文件打开一看

<Resource
    auth="Container"
    description="dmst"
    name="jdbc/dmst"
    type="javax.sql.DataSource"
    driverClassName=""
 />

直觉告诉我问题就在这里了driverClassName=""这里不就是"",错误不就是说Cannot create JDBC driver of class '' for connect URL 'null';driverclass为空,url为null;于是我就把driverClassName="com.mysql.jdbc.Driver"
 url="jdbc:mysql://localhost:3306/qxxt?useUnicode=true&amp;characterEncoding=GBK"这两句加上去,重启,哈哈

访问serverlet,哈哈,那个错终于没有了,但是还是有错是说阻止我连接数据库,一看就知道是用户名没有,于是又把用户名密码加上去,一切oK

 

好吧我把整个代码发出来吧

%tomcat_home%/conf/server.xml

<Resource name="jdbc/dmst" type="javax.sql.DataSource" driverClassName="com.mysql.jdbc.Driver" password="root" maxIdle="2" maxWait="5000" username="root" url="jdbc:mysql://localhost:3306/qxxt?useUnicode=true&characterEncoding=GBK" maxActive="4"/>

关键的发出来,其他就不发了吧.

webapp项目的web.xml

<?xml version="1.0" encoding="UTF-8"?> <web-app version="2.5" xmlns="http://java.sun.com/xml/ns/javaee" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd"> <servlet> <description>This is the description of my J2EE component</description> <display-name>This is the display name of my J2EE component</display-name> <servlet-name>TreeServerlet</servlet-name> <servlet-class>com.pmsm.serverlet.TreeServerlet</servlet-class> </servlet> <servlet> <description>This is the description of my J2EE component</description> <display-name>This is the display name of my J2EE component</display-name> <servlet-name>TestServerlet</servlet-name> <servlet-class>test.TestServerlet</servlet-class> </servlet> <servlet-mapping> <servlet-name>TreeServerlet</servlet-name> <url-pattern>/servlet/treeServerlet</url-pattern> </servlet-mapping> <servlet-mapping> <servlet-name>TestServerlet</servlet-name> <url-pattern>/servlet/TestServerlet</url-pattern> </servlet-mapping> <welcome-file-list> <welcome-file>index.jsp</welcome-file> </welcome-file-list> <resource-ref> <description>dmst</description> <res-ref-name>jdbc/dmst</res-ref-name> <res-type>javax.sql.DataSource</res-type> <res-auth>Container</res-auth> </resource-ref> </web-app>

这里我的测试serverlet是TestServerlet

Testserverlet.java

package test; import java.io.IOException; import java.io.PrintWriter; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; import javax.naming.InitialContext; import javax.naming.NamingException; import javax.servlet.ServletException; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import javax.sql.DataSource; public class TestServerlet extends HttpServlet { @Override protected void service(HttpServletRequest arg0, HttpServletResponse arg1) throws ServletException, IOException { DataSource ds = null; try { InitialContext ctx = new InitialContext(); ds = (DataSource) ctx.lookup("java:comp/env/jdbc/dmst"); Connection conn = ds.getConnection(); PreparedStatement ps=conn.prepareStatement("select * from sm_user"); ResultSet rs=ps.executeQuery(); while(rs.next()){ System.out.println(rs.getString(1)+","+rs.getString(2)); } rs.close(); ps.close(); conn.close(); } catch (NamingException e) { // TODO Auto-generated catch block e.printStackTrace(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } }

关键的地方:

webapps/项目名/META-INF/context.xml

<?xml version="1.0" encoding="UTF-8"?> <Context> <Listener className="org.apache.catalina.startup.TldConfig"/> <Listener className="org.apache.catalina.startup.TldConfig"/> <Listener className="org.apache.catalina.startup.TldConfig"/> <Listener className="org.apache.catalina.startup.TldConfig"/> <Resource auth="Container" description="dmst" name="jdbc/dmst" password="root" username="root" type="javax.sql.DataSource" driverClassName="com.mysql.jdbc.Driver" url="jdbc:mysql://localhost:3306/qxxt?useUnicode=true&characterEncoding=GBK" </Context>

OK测试去,一切都OK了