.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程序是:
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)
如果觉得《linux jsp连接mysql_linux下jsp连接mysql出现无法在入mysql连接文件的问题???》对你有帮助,请点赞、收藏,并留下你的观点哦!