用eclipse老出这个错误:我该改的都该了啊。比如,我已经把架包放入了lib下,tomcat下jre下,重启了tomcat,重装了eclipse还是不行啊。
SELECT COUNT(*) FROM R_Login WHERE Email = '[email protected]'
Get DB Connection Error:java.sql.SQLException: No suitable driver found for
java.sql.SQLException: No suitable driver found for
at java.sql.DriverManager.getConnection(DriverManager.java:602)
at java.sql.DriverManager.getConnection(DriverManager.java:185)
at sinody.common.utils.DBConnectionPool.newConnection(DBConnectionPool.java:365)
at sinody.common.utils.DBConnectionPool.initConnections(DBConnectionPool.java:381)
at sinody.common.utils.DBConnectionPool.<init>(DBConnectionPool.java:90)
at sinody.common.utils.DBConnectionManager.createPools(DBConnectionManager.java:224)
at sinody.common.utils.DBAccess.<init>(DBAccess.java:54)
at sinody.common.utils.InitDB.getSQLAccess(InitDB.java:47)
at sinody.login.CheckEmail.doPost(CheckEmail.java:60)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:849)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:454)
at java.lang.Thread.run(Thread.java:619)
SELECT COUNT(*) FROM R_Login WHERE Email = '[email protected]'
Get DB Connection Error:java.sql.SQLException: No suitable driver found for
java.sql.SQLException: No suitable driver found for
at java.sql.DriverManager.getConnection(DriverManager.java:602)
at java.sql.DriverManager.getConnection(DriverManager.java:185)
at sinody.common.utils.DBConnectionPool.newConnection(DBConnectionPool.java:365)
at sinody.common.utils.DBConnectionPool.initConnections(DBConnectionPool.java:381)
at sinody.common.utils.DBConnectionPool.<init>(DBConnectionPool.java:90)
at sinody.common.utils.DBConnectionManager.createPools(DBConnectionManager.java:224)
at sinody.common.utils.DBAccess.<init>(DBAccess.java:54)
at sinody.common.utils.InitDB.getSQLAccess(InitDB.java:47)
at sinody.login.CheckEmail.doPost(CheckEmail.java:60)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:849)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:454)
at java.lang.Thread.run(Thread.java:619)
eclipse的还是你自己安装的
suitable:适当的
driver :驱动
楼主这么大的字你都没看见????
没有给数据库找到合适的驱动啊!!!!!
LZ要学会看错误信息.. 看看你的Class.forName()中是否加载正确的驱动名
java.sql.SQLException: No suitable driver found for 把数据库驱动jar包加入你的工程lib下,重新部署
看看吧。仔细些。。
其次就是 tomcat 的问题 。。有些 tomcat 是有问题。。我曾经用5.0 -----6.0
但是 我发现 有些就是有问题。。有可能你下载的是某个人 修改过的。建议你 用 6.0
一、驱动名称写错了。
二、jar包没导入,或jar包不匹配。