爱不爱由你 发表于 2008-4-27 11:31

jsp连接不到SQL数据库

jsp连接不到SQL数据库，不知道是tomcat配置问题还是其他问题，请高手指教一下！请加Q：190961293
以下是返回的信息：
HTTP Status 500 -

--------------------------------------------------------------------------------

type Exception report

message

description The server encountered an internal error () that prevented it from fulfilling this request.

exception

javax.servlet.ServletException: Error establishing socket.
      org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:825)
      org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:758)
      org.apache.jsp.sql_jsp._jspService(sql_jsp.java:127)
      org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
      javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
      org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324)
      org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
      org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
      javax.servlet.http.HttpServlet.service(HttpServlet.java:802)


root cause

java.sql.SQLException: Error establishing socket.
      com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source)
      com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
      com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
      com.microsoft.jdbc.sqlserver.tds.TDSConnection.<init>(Unknown Source)
      com.microsoft.jdbc.sqlserver.SQLServerImplConnection.open(Unknown Source)
      com.microsoft.jdbc.base.BaseConnection.getNewImplConnection(Unknown Source)
      com.microsoft.jdbc.base.BaseConnection.open(Unknown Source)
      com.microsoft.jdbc.base.BaseDriver.connect(Unknown Source)
      java.sql.DriverManager.getConnection(DriverManager.java:512)
      java.sql.DriverManager.getConnection(DriverManager.java:171)
      org.apache.jsp.sql_jsp._jspService(sql_jsp.java:69)
      org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
      javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
      org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324)
      org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
      org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
      javax.servlet.http.HttpServlet.service(HttpServlet.java:802)


note The full stack trace of the root cause is available in the Apache Tomcat/5.0.28 logs.

[ 本帖最后由 爱不爱由你 于 2008-4-27 11:36 编辑 ]

萧茗 发表于 2008-4-27 12:05

1. 查看是否防火墙阻止了访问,
2. 查看数据库的连接端口是否正确
3. 如果 SQL SERVER 是2000 SP2 的，建议升级到 SP3。

hjack 发表于 2008-4-27 13:35

Please refer to https://www.gdutbbs.com/viewthread.php?tid=28274
Maybe it can give you a hand.

xinggg22 发表于 2008-4-27 23:25

SQL Server 记得打上SP3的补丁。
   异常抛出应该是端口问题。

china-coffeee 发表于 2008-5-3 09:43

页: [1]
查看完整版本: jsp连接不到SQL数据库