问题描述
在运行时出现这个问题我不懂是哪里出了错各位大哥各位大姐到底是什么原因啊java.sql.SQLException:[Microsoft][SQLServer2000DriverforJDBC]Errorestablishingsocket.atcom.microsoft.jdbc.base.BaseExceptions.createException(UnknownSource)atcom.microsoft.jdbc.base.BaseExceptions.getException(UnknownSource)atcom.microsoft.jdbc.base.BaseExceptions.getException(UnknownSource)atcom.microsoft.jdbc.sqlserver.tds.TDSConnection.<init>(UnknownSource)atcom.microsoft.jdbc.sqlserver.SQLServerImplConnection.open(UnknownSource)atcom.microsoft.jdbc.base.BaseConnection.getNewImplConnection(UnknownSource)atcom.microsoft.jdbc.base.BaseConnection.open(UnknownSource)atcom.microsoft.jdbc.base.BaseDriver.connect(UnknownSource)atjava.sql.DriverManager.getConnection(DriverManager.java:582)atjava.sql.DriverManager.getConnection(DriverManager.java:207)atcom.fit.dao.LoginDao.Ku(LoginDao.java:31)atcom.fit.service.LoginService.index(LoginService.java:14)atcom.fit.servlet.LoginServlet.doGet(LoginServlet.java:50)atjavax.servlet.http.HttpServlet.service(HttpServlet.java:690)atjavax.servlet.http.HttpServlet.service(HttpServlet.java:803)atorg.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)atorg.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)atcom.fit.Encoding.Encoding.doFilter(Encoding.java:22)atorg.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)atorg.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)atorg.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:230)atorg.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)atorg.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)atorg.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104)atorg.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)atorg.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:261)atorg.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)atorg.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:581)atorg.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)atjava.lang.Thread.run(Thread.java:619)2011-1-619:53:26org.apache.catalina.core.StandardWrapperValveinvoke严重:Servlet.service()forservletLoginServletthrewexceptionjava.lang.NullPointerExceptionatcom.fit.service.LoginService.index(LoginService.java:15)atcom.fit.servlet.LoginServlet.doGet(LoginServlet.java:50)atjavax.servlet.http.HttpServlet.service(HttpServlet.java:690)atjavax.servlet.http.HttpServlet.service(HttpServlet.java:803)atorg.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)atorg.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)atcom.fit.Encoding.Encoding.doFilter(Encoding.java:22)atorg.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)atorg.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)atorg.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:230)atorg.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)atorg.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)atorg.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104)atorg.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)atorg.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:261)atorg.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)atorg.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:581)atorg.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)atjava.lang.Thread.run(Thread.java:619)
解决方案
解决方案二:
SqlServer2000要打补丁
解决方案三:
引用楼主mycatok的回复:
java.sql.SQLException:[Microsoft][SQLServer2000DriverforJDBC]Errorestablishingsocket.
主要是这个错,后面那个是这个引起的。就是连不到SQLServer2000数据库,请检查请cmd进命令行环境,输入netstat-a-n或者是netstat-an,在结果列表里看是否有类似tcp127.0.0.1(或空、或localhost)1433listening的项。如果没有,你需要确保这几件事情:1.SQLServer服务要启动2.需要给sqlserver2000打上至少sp3的补丁3.防火墙不要阻止1433端口,或干脆关掉防火墙,包括xp自己的windows防火墙4.配SQLServer使用TCP/IP协议和1433端口
解决方案四:
引用2楼magong的回复:
引用楼主mycatok的回复:java.sql.SQLException:[Microsoft][SQLServer2000DriverforJDBC]Errorestablishingsocket.主要是这个错,后面那个是这个引起的。就是连不到SQLServer2000数据库,请检查请cmd进命令行环境,输入netstat-a-n或者是nets……
攒一个
解决方案五:
是补丁没打吧
解决方案六:
java.sql.SQLException:[Microsoft][SQLServer2000DriverforJDBC]Errorestablishingsocket.
同意2楼的。。
解决方案七:
同意楼上的,sql2000要打补丁
解决方案八:
我再厚道点吧如何查看SQLServer补丁的版本?select@@version版本对照表8.00.194SQLServer2000RTM8.00.384SQLServer2000SP18.00.534SQLServer2000SP2November30th,20018.00.760SQLServer2000SP38.00.2039SQLServer2000SP4
解决方案九:
sql2000要打补丁
解决方案十:
XP下要打sp4补丁
解决方案十一:
sql2000连接java程序,最低要达到sp3的补丁