具体服务器环境:
2003 server
IIS6 Apache TOMCAT6整合.
DB:MSSQL2000,MYSQL5
现IIS上有几个ASP站点使用MSSQL,其中一PHP站点应用MYSQL,其使用正常.
安装TOMCAT6后,于MYSQL里建数据库,连接出错.连最基本的连接都不行.
于虚拟机环境测试正常.服务器的MYSQL帐号权限开放过最大也不行.
测试代码:
<%@page contentType="text/html"%><%@page pageEncoding="UTF-8"%><%@page language="java" import="java.sql.*"%><%java.sql.Connection conn;java.lang.String strConn; conn=null;try{Class.forName("org.gjt.mm.mysql.Driver").newInstance();conn=java.sql.DriverManager.getConnection("jdbc:mysql://localhost/mysql","root","密码");}catch(Exception e){ System.out.println("连接错误"); }Statement stmt=conn.createStatement();ResultSet RS_result=null;%><html><head><title>JSP Page</title></head><body> <%-- <jsp:useBean id="beanInstanceName" scope="session" class="beanPackage.BeanClassName" /> --%><%-- <jsp:getProperty name="beanInstanceName" property="propertyName" /> --%><%RS_result=stmt.executeQuery("select * from user");String Name;while (RS_result.next()){ Name=RS_result.getString("user");%> <%=Name%><%}RS_result.close();stmt.close();conn.close();%></body></html>错误信息如下:
type Exception reportmessage description The server encountered an internal error () that prevented it from fulfilling this request.exception org.apache.jasper.JasperException: An exception occurred processing JSP page /ctest.jsp at line 3128:
29: }
30:
31: Statement stmt=conn.createStatement();
32:
33: ResultSet RS_result=null;
34:
Stacktrace:
org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:505)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:416)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:342)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:267)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
root cause java.lang.NullPointerException
org.apache.jsp.ctest_jsp._jspService(ctest_jsp.java:84)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:374)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:342)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:267)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
note The full stack trace of the root cause is available in the Apache Tomcat/6.0.18 logs.
分不多,望高手分析一下是什么问题.头很大,谢谢!!!
2003 server
IIS6 Apache TOMCAT6整合.
DB:MSSQL2000,MYSQL5
现IIS上有几个ASP站点使用MSSQL,其中一PHP站点应用MYSQL,其使用正常.
安装TOMCAT6后,于MYSQL里建数据库,连接出错.连最基本的连接都不行.
于虚拟机环境测试正常.服务器的MYSQL帐号权限开放过最大也不行.
测试代码:
<%@page contentType="text/html"%><%@page pageEncoding="UTF-8"%><%@page language="java" import="java.sql.*"%><%java.sql.Connection conn;java.lang.String strConn; conn=null;try{Class.forName("org.gjt.mm.mysql.Driver").newInstance();conn=java.sql.DriverManager.getConnection("jdbc:mysql://localhost/mysql","root","密码");}catch(Exception e){ System.out.println("连接错误"); }Statement stmt=conn.createStatement();ResultSet RS_result=null;%><html><head><title>JSP Page</title></head><body> <%-- <jsp:useBean id="beanInstanceName" scope="session" class="beanPackage.BeanClassName" /> --%><%-- <jsp:getProperty name="beanInstanceName" property="propertyName" /> --%><%RS_result=stmt.executeQuery("select * from user");String Name;while (RS_result.next()){ Name=RS_result.getString("user");%> <%=Name%><%}RS_result.close();stmt.close();conn.close();%></body></html>错误信息如下:
type Exception reportmessage description The server encountered an internal error () that prevented it from fulfilling this request.exception org.apache.jasper.JasperException: An exception occurred processing JSP page /ctest.jsp at line 3128:
29: }
30:
31: Statement stmt=conn.createStatement();
32:
33: ResultSet RS_result=null;
34:
Stacktrace:
org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:505)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:416)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:342)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:267)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
root cause java.lang.NullPointerException
org.apache.jsp.ctest_jsp._jspService(ctest_jsp.java:84)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:374)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:342)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:267)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
note The full stack trace of the root cause is available in the Apache Tomcat/6.0.18 logs.
分不多,望高手分析一下是什么问题.头很大,谢谢!!!
解决方案 »
- id parentId 查询 求帮忙
- delete 语句找不到字段,是不是应该用连结,帮写下
- 通过程序进行了一些批量操作,能不能在后台通过日志什么的将数据库回滚到之前某个时间点
- 求SQL
- 丢失了ibdata1文件如何恢复数据库
- 请教高手 数出本表中同SID同tn的值生成对应的新表 这样可能吗?会有这样的语句吗~~~~~~~~~~~~~~
- 数据库类型转换!?
- mysql中的sql语句疑点!
- 如何安装postgresql在linux下?
- 求推荐一款优秀的开源的数据库管理工具,可以支持mysql、oracle、sqlserver、db2等。
- linux下安装mysql问题,急,搞到现在了
- 付费请人处理access数据库中的数据并导入到mysql数据库中
确认你root的密码 就是 "密码"然后以mysql命令工具或某种GUI登录你的mysql,
grant all on *.* to root@%;这样把权限授给你的ROOT,允许ROOT在任何一台机login.
你说的权限分配我试过了.我试过把ROOT权限对外全部放开.也是不行.
其他机器用工具连接也连不到服务器的MYSQL上.我只是很奇怪,为什么那个PHP站点连接就很正常.
我不太清楚具体别人在初始安装的时候做过什么操作,但我试过好多种方法在服务器上把MYSQL重装,或停掉原来的PHP站点,
但JSP就是连接不上,ROOT权限开放给其他机器,也是连接不上!