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 y2javaee.huanjin.ch03.ConnectionManager.getConnection(ConnectionManager.java:21) 
at y2javaee.huanjin.ch03.TitlesBean.getTitles(TitlesBean.java:17) 
at org.apache.jsp.ch03.books_jsp._jspService(books_jsp.java:76) 
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70) 
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803) 
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:374) 
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:337) 
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266) 
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803) 
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) 
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) 
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) 
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175) 
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128) 
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) 
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) 
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286) 
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844) 
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583) 
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447) 
at java.lang.Thread.run(Unknown Source) 
java.lang.NullPointerException 
at y2javaee.huanjin.ch03.TitlesBean.getTitles(TitlesBean.java:18) 
at org.apache.jsp.ch03.books_jsp._jspService(books_jsp.java:76) 
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70) 
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803) 
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:374) 
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:337) 
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266) 
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803) 
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) 
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) 
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) 
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175) 
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128) 
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) 
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) 
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286) 
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844) 
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583) 
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447) 
at java.lang.Thread.run(Unknown Source) 这是报的异常,跪求各位大侠指点迷津!

解决方案 »

  1.   

    连接不上数据库啊,不知道有没有打补丁啊,至少要是Sp4吧!还有就是看看你的驱动.jar文件是否加入了...
      

  2.   

    补丁打的Sp4,jar包也都加好了,从表面上看没有什么问题,我自己怀疑是安装的时候错了,就是不知道是哪一步出的错
    大侠们指点指点
      

  3.   

    java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket,这个问题很普遍啊,你先查看下
    服务器正常启动检查是不是使用1433端口,然后查看防火墙是不是屏蔽1433端口了,cmd->netstat -an  检查下你的1433端口是不是开启,没有的话就打SQL   SERVER的补丁sp3或sp4,应该能解决问题
      

  4.   

    大侠你刚才说的我全部都试了,没有问题都,cmd终究是没有1433端口,而且服务里面也开了,补丁打得sp4,但就是不好啊