TAG:
.bash_profile文件为 PATH=$PATH:$HOME/bin:/yin/tomcat311/bin:/yin/apache132/bin:/yin/mysql/bin/:/yin/jdk122/lib: BASH_ENV=$HOME/.bashrc USERNAME="root" export USERNAME BASH_ENV PATH JAVA_HOME=/yin/jdk122 PATH=$PATH:$JAVA_HOME/bin CLASSPATH=/yin/jdk122/lib/tools.jar:/yin/jdk122/lib/: export JAVA_HOME export PATH CALSSPATH 我将mysql的jdbc连接文件(org.gjt.mm.mysql目录)解压后拷贝到/yin/jdk122/lib下 我的jsp程序是: <%@ page import="java.sql.*"%> <% Connection Conn; Statement Stmt; ResultSet Rst; try { Class.forName("org.gjt.mm.mysql.Driver").newInstance(); } catch(ClassNotFoundException e) { out.print("数据库连接文件没有找到,请正确配置classpath参数!!! "); out.print(e); } String url="jdbc:mysql://10.110.1.88/longte?user=root&password=123456&useUnicode=true&characterEncoding=8859_1"; Conn=DriverManager.getConnection(url); Stmt=Conn.createStatement(); %> 执行显示: Error: 500 Location: /data.jsp Internal Servlet Error: javax.servlet.ServletException: No suitable driver at org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:386) at _0002fdata_0002ejspdata_jsp_3._jspService(_0002fdata_0002ejspdata_jsp_3.java:113) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:126) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.jasper.runtime.JspServlet$JspServletWrapper.service(JspServlet.java:174) at org.apache.jasper.runtime.JspServlet.serviceJspFile(JspServlet.java:261) at org.apache.jasper.runtime.JspServlet.service(JspServlet.java:369) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.tomcat.core.ServletWrapper.handleRequest(ServletWrapper.java:503) at org.apache.tomcat.core.ContextManager.service(ContextManager.java:559) at org.apache.tomcat.service.http.HttpConnectionHandler.processConnection(HttpConnectionHandler.java:160) at org.apache.tomcat.service.TcpConnectionThread.run(SimpleTcpEndpoint.java:338) at java.lang.Thread.run(Thread.java:472) Root cause: java.sql.SQLException: No suitable driver at java.sql.DriverManager.getConnection(DriverManager.java:470) at java.sql.DriverManager.getConnection(DriverManager.java:152) at _0002fdata_0002ejspdata_jsp_3._jspService(_0002fdata_0002ejspdata_jsp_3.java:101) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:126) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.jasper.runtime.JspServlet$JspServletWrapper.service(JspServlet.java:174) at org.apache.jasper.runtime.JspServlet.serviceJspFile(JspServlet.java:261) at org.apache.jasper.runtime.JspServlet.service(JspServlet.java:369) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.tomcat.core.ServletWrapper.handleRequest(ServletWrapper.java:503) at org.apache.tomcat.core.ContextManager.service(ContextManager.java:559) at org.apache.tomcat.service.http.HttpConnectionHandler.processConnection(HttpConnectionHandler.java:160) at org.apache.tomcat.service.TcpConnectionThread.run(SimpleTcpEndpoint.java:338) at java.lang.Thread.run(Thread.java:472) 连接mysql的jdbc文件没有找到,请问是什么原因??? 谢谢!!! (yjdabc) |