jsp连接MYSQL的问题，出错org.apache.jasper.JasperException: com.mysql.jdbc.Driver

[chenlianjia]

我在网上下栽mysql-connector-java-3.0.9-stable-bin.jar，也把他放到CLASSPATH里面了，并且考到 jre/lib/ext下了，
代码如下：
<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="java.sql.*"%>
<%
Class.forName("com.mysql.jdbc.Driver").newInstance();
%>

错误提示：

org.apache.jasper.JasperException: com.mysql.jdbc.Driver
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:254)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:295)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:256)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2416)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:171)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:223)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:601)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:392)
at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:565)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:619)
at java.lang.Thread.run(Thread.java:536)

[bbfish]

你用winrar拆jar包看看路径对不对?
那个或者换个org.gjt.mm.mysql.Driver的驱动试试

[chenlianjia]

改成这个org.gjt.mm.mysql.Driver还是不行，我是参考这个http://www.csdn.net/develop/Read_Article.asp?Id=19229配置的，不知道问题出在哪里，

[wangchq]

可能是你的驱动程序并没有被真正的加载到classpath里去，或者是你的数据的版本不匹配，在检查一下。
如果你的jsp是在一个webapp里面，那末你的mysql-connector-java-3.0.9-stable-bin.jar必须在WEB-INF/lib路径下。

[babysoftboy]

Class.forName("com.jdbc.odbc.Driver").newInstance();ni 你试一试

[yiyky]

use " Class.forName("%JAVA_HOME%\JRE\LIB\EXT 目录下你下载的驱动的路径.driver"); "

[coolfeel]

wangchq(阿宝)

说得不错 一般 可能是驱动没被真正加载到CLASSPATH 也就是说可能 你是原来添加的lib修改过了，你看看你的mysql驱动是不是红色