晓风残月
新手上路
BlogJava
首页
新随笔
新文章
联系
聚合
管理
posts - 6,comments - 49,trackbacks - 0
<
2006年6月
>
日
一
二
三
四
五
六
28
29
30
31
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
1
2
3
4
5
6
7
8
常用链接
我的随笔
我的评论
我的参与
最新评论
留言簿
(1)
给我留言
查看公开留言
查看私人留言
随笔分类
Java Prime(3)
JNI
Miscellaneous(1)
乐^_^(1)
随笔档案
2006年6月 (1)
2006年5月 (5)
Miscellaneous
搜索
最新评论
1. re: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.[未登录]
同出现这个问题，上面的都试过不行，求解决方案！！！297020949@qq.com
--123
2. re: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.
汗，慢慢研究
--o2o
3. re: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.
@jinglecat
--大道
4. re: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.
其实问题也许很简单，检查下防火墙是不是开着呢，关闭->搞定
--ltsznh
5. re: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.
我的是XP系统装SQL2005也是出现上述问题！！跪求高手帮助！！邮箱qq429626538@163.com
--钱宇皓
阅读排行榜
1. java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.(22194)
2. java.io.IOException: open HTTP connection failed(4926)
3. int to bytes to int(1288)
4. 新店开张咯^_^(275)
5. What's IIOP&&AXIS?(263)
评论排行榜
1. java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.(41)
2. java.io.IOException: open HTTP connection failed(5)
3. int to bytes to int(3)
4. 新店开张咯^_^(0)
5. 【转载】老婆说明书(0)
2006年6月10日
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.
使用MS Sql2000 for JDBC SP3连接MS Sql2000出现如下错误：
java.sql.SQLException:
[
Microsoft
][
SQLServer 2000 Driver for JDBC
]
Error establishing socket.
at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source)
at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.microsoft.jdbc.sqlserver.tds.TDSConnection.<init>(Unknown Source)
at com.microsoft.jdbc.sqlserver.SQLServerImplConnection.open(Unknown Source)
at com.microsoft.jdbc.base.BaseConnection.getNewImplConnection(Unknown Source)
at com.microsoft.jdbc.base.BaseConnection.open(Unknown Source)
at com.microsoft.jdbc.base.BaseDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at drawServlet.doGet(drawServlet.java:
50
)
at drawServlet.doPost(drawServlet.java:
18
)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:
709
)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:
802
)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:
237
)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:
157
)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:
214
)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:
104
)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:
520
)
at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:
198
)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:
152
)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:
104
)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:
520
)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:
137
)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:
104
)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:
118
)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:
102
)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:
520
)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:
109
)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:
104
)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:
520
)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:
929
)
at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:
160
)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:
799
)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:
705
)
at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:
577
)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:
683
)
at java.lang.Thread.run(Unknown Source)
java.sql.SQLException:
[
Microsoft
][
SQLServer 2000 Driver for JDBC
]
End of stream was detected on a read.
at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source)
at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processReply(Unknown Source)
at com.microsoft.jdbc.sqlserver.SQLServerImplConnection.open(Unknown Source)
at com.microsoft.jdbc.base.BaseConnection.getNewImplConnection(Unknown Source)
at com.microsoft.jdbc.base.BaseConnection.open(Unknown Source)
at com.microsoft.jdbc.base.BaseDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at drawServlet.doGet(drawServlet.java:
92
)
at drawServlet.doPost(drawServlet.java:
18
)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:
709
)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:
802
)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:
237
)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:
157
)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:
214
)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:
104
)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:
520
)
at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:
198
)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:
152
)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:
104
)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:
520
)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:
137
)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:
104
)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:
118
)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:
102
)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:
520
)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:
109
)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:
104
)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:
520
)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:
929
)
at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:
160
)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:
799
)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:
705
)
at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:
577
)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:
683
)
at java.lang.Thread.run(Unknown Source)
原因：由于开发环境是Win 2003 Server，故SQL 2000需要补丁包，不然在2k3下，SQL默认关闭了TCP连接
解决：打上SQL serverSP4 就OK了
posted @
2006-06-10 15:35
jinglecat 阅读(22194) |
评论 (41)
|
编辑
收藏