注册 登录
编程论坛 J2EE论坛

jsp连接SQL数据库的的问题

jingdongya 发布于 2007-05-30 17:03, 1156 次点击

我的机器的环境已经配好了可是就是连接不上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.

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

8 回复
#2
神vLinux飘飄2007-05-30 17:17

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

#3
支离破碎2007-05-30 17:31
又是SQLSERVER。。。。已经有人发过N次了。。

1:看补丁打没
2:看驱动有没
3:看端口占用了没。
#4
风月_无边2007-05-30 18:08

用mysql吧,就没这么麻烦!

#5
想你的天空2007-05-30 18:23
楼上正解
#6
jingdongya2007-05-30 20:31

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

#7
NiceGirl2007-05-31 01:11
回复:(jingdongya)不知为什么还是不行呀!我的操作...

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

#8
lgdcky2007-05-31 01:38
MYSQL和SQL SERVER两手都要抓!嘿嘿
#9
being2007-05-31 13:31
我更郁闷~~~
上次我去面试...那个人 叫我 用mysql ,结果,,,中文数据添加不进去,,,是版本问题么?
我觉得的是..............

1