問題描述
在java文件的main方法中調(diào)試mysql連接及查詢時沒有問題
在web project 項目工連接mysql報錯
錯誤信息
java.sql.SQLException: No suitable driver found for jdbc:mysql://localhost:3306/phpmyadmin?useUnicode=true&characterEncoding=UTF-8
at java.sql.DriverManager.getConnection(DriverManager.java:689)
at java.sql.DriverManager.getConnection(DriverManager.java:247)
at util.DBHelper.getConnection(DBHelper.java:34)
at dao.ItemsDAO.getAllItems(ItemsDAO.java:22)
at org.apache.jsp.index_jsp._jspService(index_jsp.java:176)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:742)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:443)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:386)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:330)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:742)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
原因：
在連接mysql數(shù)據(jù)庫時幅骄，正常的java application可以連接劫窒，但是到j(luò)avabean web中就出錯，說是Class.forName(dirver)找不到驅(qū) 動拆座。
解決辦法：
我將oracle的mysql-connector-java-5.1.13-bin.jar的包放到了web-inf下的lib文件夾下
參考：at org.apache.catalina.loader.WebappClassLoader.loadClass問題處理
