【环境】
jdk1.5.0_06+Tomcat 5.5+mysql-essential-5.0.19-win32(1).msi
+mysql-connector-java-5.0.0-beta.【驱动配置】
mysql-connector-java-5.0.0-beta-bin.jar放入c:\jdk1.5.0_06\jdbc中.
mysql-connector-java-5.0.0-beta-bin-g.jar放入c:\jdk1.5.0_06\lib中.【classpaht配置】
classpath=.;%JAVA_HOME%\lib\dt.jar;%JAVA_HOME%\lib\tools.jar;%JAVA_HOME%\JDBC\mysql-connector-java-5.0.0-beta-bin.jar;%TOMCAT_HOME%\common\lib\servlet-api.jar;%JAVA_HOME%\lib\mysql-connector-java-5.0.0-beta-bin-g.jar【测试文件】
<%@ page contentType="text/html;charset=GB2312" %>
<%@ page language="java" import="java.sql.*"%>
<%
java.sql.Connection conn;
java.lang.String strConn;
Class.forName("org.gjt.mm.mysql.Driver").newInstance();
conn= java.sql.DriverManager.getConnection("jdbc:mysql://localhost/myapp/first","test","123456");
Statement stmt=conn.createStatement();
ResultSet rs=null;
rs=stmt.executeQuery("select * from first");
while(rs.next()) {%>
您的第一个字段内容为:<%=rs.getString(1)%>
<%out.print("\n\n");%>
您的第二个字段内容为:<%=rs.getString(2)%>
<%out.print("\n\n");%>
<%}%>
<%out.print("\n数据库操作成功,恭喜你\n");%>
<%out.print("\nJSP+TOMCAT+MYSQL环境配置完成!\n");%>
<%rs.close();
stmt.close();
conn.close();
%> 【报错】
type Exception reportmessage description The server encountered an internal error () that prevented it from fulfilling this request.exception org.apache.jasper.JasperException: org.gjt.mm.mysql.Driver
org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:510)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:375)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
root cause javax.servlet.ServletException: org.gjt.mm.mysql.Driver
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:858)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:791)
org.apache.jsp.first_jsp._jspService(first_jsp.java:96)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:332)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
root cause java.lang.ClassNotFoundException: org.gjt.mm.mysql.Driver
org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1352)
org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1198)
org.apache.jasper.servlet.JasperLoader.loadClass(JasperLoader.java:127)
org.apache.jasper.servlet.JasperLoader.loadClass(JasperLoader.java:65)
java.lang.ClassLoader.loadClassInternal(ClassLoader.java:319)
java.lang.Class.forName0(Native Method)
java.lang.Class.forName(Class.java:164)
org.apache.jsp.first_jsp._jspService(first_jsp.java:48)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:332)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
note The full stack trace of the root cause is available in the Apache Tomcat/5.5.16 logs.
jdk1.5.0_06+Tomcat 5.5+mysql-essential-5.0.19-win32(1).msi
+mysql-connector-java-5.0.0-beta.【驱动配置】
mysql-connector-java-5.0.0-beta-bin.jar放入c:\jdk1.5.0_06\jdbc中.
mysql-connector-java-5.0.0-beta-bin-g.jar放入c:\jdk1.5.0_06\lib中.【classpaht配置】
classpath=.;%JAVA_HOME%\lib\dt.jar;%JAVA_HOME%\lib\tools.jar;%JAVA_HOME%\JDBC\mysql-connector-java-5.0.0-beta-bin.jar;%TOMCAT_HOME%\common\lib\servlet-api.jar;%JAVA_HOME%\lib\mysql-connector-java-5.0.0-beta-bin-g.jar【测试文件】
<%@ page contentType="text/html;charset=GB2312" %>
<%@ page language="java" import="java.sql.*"%>
<%
java.sql.Connection conn;
java.lang.String strConn;
Class.forName("org.gjt.mm.mysql.Driver").newInstance();
conn= java.sql.DriverManager.getConnection("jdbc:mysql://localhost/myapp/first","test","123456");
Statement stmt=conn.createStatement();
ResultSet rs=null;
rs=stmt.executeQuery("select * from first");
while(rs.next()) {%>
您的第一个字段内容为:<%=rs.getString(1)%>
<%out.print("\n\n");%>
您的第二个字段内容为:<%=rs.getString(2)%>
<%out.print("\n\n");%>
<%}%>
<%out.print("\n数据库操作成功,恭喜你\n");%>
<%out.print("\nJSP+TOMCAT+MYSQL环境配置完成!\n");%>
<%rs.close();
stmt.close();
conn.close();
%> 【报错】
type Exception reportmessage description The server encountered an internal error () that prevented it from fulfilling this request.exception org.apache.jasper.JasperException: org.gjt.mm.mysql.Driver
org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:510)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:375)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
root cause javax.servlet.ServletException: org.gjt.mm.mysql.Driver
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:858)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:791)
org.apache.jsp.first_jsp._jspService(first_jsp.java:96)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:332)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
root cause java.lang.ClassNotFoundException: org.gjt.mm.mysql.Driver
org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1352)
org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1198)
org.apache.jasper.servlet.JasperLoader.loadClass(JasperLoader.java:127)
org.apache.jasper.servlet.JasperLoader.loadClass(JasperLoader.java:65)
java.lang.ClassLoader.loadClassInternal(ClassLoader.java:319)
java.lang.Class.forName0(Native Method)
java.lang.Class.forName(Class.java:164)
org.apache.jsp.first_jsp._jspService(first_jsp.java:48)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:332)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
note The full stack trace of the root cause is available in the Apache Tomcat/5.5.16 logs.
这个放到tomcat\common\lib下或者应用目录的WEB-INF\lib下试试。
和WEB-INF\lib都试了,都不行
org.gjt.mm.mysql.Driver -> com.mysql.jdbc.Driver改成这样
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<%
try {
Class.forName("org.gjt.mm.mysql.Driver").newInstance();
out.println("Success loading Mysql Driver!");
}
catch (Exception E) {
out.println("Unable to load driver.");
}
程序改成这样也不行。
一运行就这么直接报错了
Unable to load driver. SQLException: No suitable driver SQLState: 08001 VendorError: 0
应该是连驱动都没找到
org.gjt.mm.mysql.Driver不要用,改成com.mysql.jdbc.Driver
org.gjt.mm.mysql.Driver和com.mysql.jdbc.Driver我都试了,就是不行
org\gjt\mm\mysql\Driver还是com\mysql\jdbc\Driver 看了再来说一下
解压了是org\gjt\mm\mysql\Driver.class
我装过tomcat4+jdk1.4.2,连换个class都要重起.
用了tomcat5.5+jdk1.5.0_06后,class变了,不用重起了,servlet照样运行。所以我就没有重起tomcat5.5了。刚才重起了一下,就好了。