当前位置: 代码迷 >> Java Web开发 >> jsp连接SQL数据库的的问题
  详细解决方案

jsp连接SQL数据库的的问题

热度:120   发布时间:2007-05-30 17:03:46.0
jsp连接SQL数据库的的问题

我的机器的环境已经配好了可是就是连接不上SQL数据库求高手帮忙!错误信息如下:
type Exception report

message

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

exception

javax.servlet.ServletException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:846)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:779)
org.apache.jsp._01_jsp._jspService(_01_jsp.java:80)
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: [Microsoft][SQLServer 2000 Driver for JDBC]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._01_jsp._jspService(_01_jsp.java:52)
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.30 logs.

以上就是我的机器上显示的信息,望高手看后快回!谢谢!

搜索更多相关主题的帖子: SQL  数据库  jsp  

----------------解决方案--------------------------------------------------------

你的什么操作系统?xp的2000server要打sp3以上的补丁


----------------解决方案--------------------------------------------------------
又是SQLSERVER。。。。已经有人发过N次了。。

1:看补丁打没
2:看驱动有没
3:看端口占用了没。
----------------解决方案--------------------------------------------------------

用mysql吧,就没这么麻烦!


----------------解决方案--------------------------------------------------------
楼上正解
----------------解决方案--------------------------------------------------------

不知为什么还是不行呀!我的操作系是XP的能帮我解决的高手加的QQ:76539995在这里先给你说声谢谢!


----------------解决方案--------------------------------------------------------
回复:(jingdongya)不知为什么还是不行呀!我的操作...

去网上下个SQL2000的SP4补丁安装一下就可以了


----------------解决方案--------------------------------------------------------
MYSQL和SQL SERVER两手都要抓!嘿嘿

----------------解决方案--------------------------------------------------------
我更郁闷~~~
上次我去面试...那个人 叫我 用mysql ,结果,,,中文数据添加不进去,,,是版本问题么?
我觉得的是..............


----------------解决方案--------------------------------------------------------
  相关解决方案