LINUX下JSP连接MYSQL的问题.......

freelyl 2004-03-24 04:31:52
<%@ page contentType="text/html;charset=gb2312" %>
<%@ page import="java.sql.*"%>
<%
try{
Class.forName("com.mysql.jdbc.Driver").newInstance();
String url="jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=gb2312";
String user="admin";
String password="admin";
Connection conn= DriverManager.getConnection(url,user,password);
conn.close();
catch(Exception e){out.println("Error:"+e.toString());}
%>


上面代码在WIN2K下完全成功,但不知怎么的放到LINUX下面就不成功了。
原来WIN2K下用户还是用空的都行如下:
String user="";
String password="";
后来转到LINUX下说
Server configuration denies access to data source
于是我就
GRANT ALL PRIVILEGES ON *.* to admin@'localhost'
GRANT ALL PRIVILEGES ON *.* to admin@'%'
新建了个用户admin这样才不出现Server configuration denies access to data source
但是还是行不通出了大批码出来不知道什么意思,请大家帮帮忙,我的JSP是在TOMCAT5下运行的,LINUX是REDHAT9


Error:java.sql.SQLException: Communication link failure: java.io.IOException, underlying cause: Unexpected end of input stream ** BEGIN NESTED EXCEPTION ** java.io.IOException MESSAGE: Unexpected end of input stream STACKTRACE: java.io.IOException: Unexpected end of input stream at com.mysql.jdbc.MysqlIO.readPacket(MysqlIO.java:1080) at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:619) at com.mysql.jdbc.Connection.createNewIO(Connection.java:1532) at com.mysql.jdbc.Connection.(Connection.java:486) at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:326) at java.sql.DriverManager.getConnection(DriverManager.java:512) at java.sql.DriverManager.getConnection(DriverManager.java:171) at org.apache.jsp.test_jsp._jspService(test_jsp.java:51) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:133) at javax.servlet.http.HttpServlet.service(HttpServlet.java:856) at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:311) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:301) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:248) at javax.servlet.http.HttpServlet.service(HttpServlet.java:856) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:284) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:204) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:257) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:151) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:567) at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:245) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:199) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:151) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:567) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:184) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:151) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:164) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:149) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:567) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:156) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:151) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:567) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:972) at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:206) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:833) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:732) at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:619) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:688) at java.lang.Thread.run(Thread.java:534) ** END NESTED EXCEPTION **


...全文
69 4 打赏 收藏 转发到动态 举报
写回复
用AI写文章
4 条回复
切换为时间正序
请发表友善的回复…
发表回复
freelyl 2004-03-25
  • 打赏
  • 举报
回复
解决了,是JDBC用户权限加JDBC 驱动版本太旧的原因,

唉.......真是伤心,有WIN下面都没事,在LINUX下面有事。搞了我半天。

谢谢回复了。找个人帮忙真难。
china_yx 2004-03-25
  • 打赏
  • 举报
回复
mysql.sock 具体你要查了。注意下在linux下,用户名为root密码为空,默认只有本机可以连接。
freelyl 2004-03-24
  • 打赏
  • 举报
回复
我去改一下目录权限,但删连接文件.....是怎么搞?
china_yx 2004-03-24
  • 打赏
  • 举报
回复
都是数据库连接的错误,我是在linux下使用的默认的root/空 用户,然后将数据库目录设为可写。好像后面的错误要删除一个socket连接文件

56,673

社区成员

发帖
与我相关
我的任务
社区描述
MySQL相关内容讨论专区
社区管理员
  • MySQL
加入社区
  • 近7日
  • 近30日
  • 至今
社区公告
暂无公告

试试用AI创作助手写篇文章吧