开发者社区> 问答> 正文

Tomcat连接池提示驱动错误,请教如何解决?

tomcat中的server.xml

    <Resource name="jdbc/webdb2" auth="Container"
    type="javax.sql.DataSource"
    driverClassName="com.mysql.jdbc.Driver"
    url="jdbc:mysql://localhost:3306/webdb?characterEncoding=utf-8"
    username="root"
    password="sa123456"
    maxActive="200"
    maxIdle="50"
    maxWait="3000"
    />

tomcat中的webdemo3.xml

<Context path="/webdemo3" docBase="webdemo3" debug="0">
<ResourceLink name="jdbc/webdb2" global="jdbc/webdb2" type="javax.sql.DataSource"/>
</Context>

项目里的web.xml

<?xml version="1.0" encoding="UTF-8"?>
<web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://xmlns.jcp.org/xml/ns/javaee" xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/javaee http://xmlns.jcp.org/xml/ns/javaee/web-app_3_1.xsd" id="WebApp_ID" version="3.1">
  <display-name>webdemo3</display-name>
  <welcome-file-list>
    <welcome-file>index.html</welcome-file>
    <welcome-file>index.htm</welcome-file>
    <welcome-file>index.jsp</welcome-file>
    <welcome-file>default.html</welcome-file>
    <welcome-file>default.htm</welcome-file>
    <welcome-file>default.jsp</welcome-file>
  </welcome-file-list>
  <servlet>
    <servlet-name>viewDictory</servlet-name>
    <servlet-class>webdemo3.chapter04.ViewDictionary</servlet-class>
  </servlet>
  <servlet-mapping>
    <servlet-name>viewDictory</servlet-name>
    <url-pattern>/servlet/ViewDictionary</url-pattern>
  </servlet-mapping>
  <resource-ref>
    <description>DB Connection</description>
    <res-ref-name>jdbc/webdb2</res-ref-name>
    <res-type>javax.sql.DataSource</res-type>
    <res-auth>Container</res-auth>
  </resource-ref>
</web-app>

项目中的ViewDictionary.java

package webdemo3.chapter04;

import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

/**
 * Servlet implementation class ViewDictionary
 */
public class ViewDictionary extends HttpServlet {
private static final long serialVersionUID = 1L;
       
    /**
     * @see HttpServlet#HttpServlet()
     */
    public ViewDictionary() {
        super();
        // TODO Auto-generated constructor stub
    }

/**
* @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
*/
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
response.setContentType("text/html;charset=UTF-8");
PrintWriter out=response.getWriter();
try{
javax.naming.Context ctx=new javax.naming.InitialContext();
javax.sql.DataSource ds=(javax.sql.DataSource)ctx.lookup("java:/comp/env/jdbc/webdb2");
Connection conn=ds.getConnection();

PreparedStatement pstmt=conn.prepareStatement("select * from t_dictionary");

ResultSet rs=pstmt.executeQuery();

StringBuilder table=new StringBuilder();
table.append("<table border='1'>");
table.append("<tr><td>书名</td><td>价格</td></tr>");
while(rs.next()){
table.append("<tr><td>"+rs.getString("english")+"</td><td>"+rs.getString("chinese")+"</td></tr>");
}
table.append("</table>");
out.println(table.toString());
pstmt.close();
}catch(Exception e){
e.printStackTrace();
out.println(e.getMessage());
}
}

/**
* @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
*/
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
// TODO Auto-generated method stub
}

}

控制台错误信息:
1
2
jar包好用,在项目和tomcat都有
还有个问题一直没有解决,不知道和这个有没有关:
conn=DriverManager.getConnection("jdbc:mysql://localhost:3360/newsmanager","root","sa123456");
conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/newsmanager?user=root&password=sa123456");
第一个不好使 第二个好使 为什么

展开
收起
落地花开啦 2016-06-02 13:32:03 1966 0
1 条回答
写回答
取消 提交回答
  • 喜欢技术,喜欢努力的人

    Caused by: java.sql.SQLException: No suitable driver
    把你mysql的驱动放到到lib目录下去

    2019-07-17 19:24:43
    赞同 展开评论 打赏
问答排行榜
最热
最新

相关电子书

更多
Apache Tomcat 的云原生演进 立即下载
低代码开发师(初级)实战教程 立即下载
阿里巴巴DevOps 最佳实践手册 立即下载