社区

京东店铺
淘宝店铺
当当店铺
拼多多店铺

APP下载

扫描下载官方APP

VIP会员

JavaWeb图书答疑

+关注

已有49人关注

+发表新帖

所属版块： JavaWeb答疑区

yaoying

学分:0

+关注

私信

立即签到

版块推荐

jsp 在线考试系统学习数据库连接失败请帮忙看看错误

发表在JavaWeb图书答疑 2012-05-14

是否精华是否

版块置顶: 是否

获取的查询字符串：login
com.microsoft.sqlserver.jdbc.SQLServerException: 到主机的 TCP/IP 连接失败。 java.net.NoRouteToHostException: No route to host: connect
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.loginWithoutFailover(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at com.wgh.core.ConnDB.getConnection(ConnDB.java:35)
at com.wgh.core.ConnDB.executeQuery(ConnDB.java:56)
at com.wgh.dao.ManagerDAO.checkManager(ManagerDAO.java:15)
at com.wgh.action.Manager.managerLogin(Manager.java:44)
at com.wgh.action.Manager.execute(Manager.java:22)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:419)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:224)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1194)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
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:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
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:298)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
at java.lang.Thread.run(Unknown Source)
警告: DbConnectionManager.getConnection() 获得数据库链接失败.

链接类型:com.microsoft.sqlserver.jdbc.SQLServerDriver
链接位置:jdbc:sqlserver://192.168.1.199:1433;DatabaseName=db_netExam
用户/密码sa/111
2012-5-14 12:25:42 org.apache.struts.action.RequestProcessor processException
警告: Unhandled Exception thrown: class java.lang.NullPointerException
2012-5-14 12:25:42 org.apache.catalina.core.StandardWrapperValve invoke
严重: Servlet.service() for servlet action threw exception
java.lang.NullPointerException
at com.wgh.core.ConnDB.executeQuery(ConnDB.java:57)
at com.wgh.dao.ManagerDAO.checkManager(ManagerDAO.java:15)
at com.wgh.action.Manager.managerLogin(Manager.java:44)
at com.wgh.action.Manager.execute(Manager.java:22)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:419)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:224)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1194)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
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:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
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:298)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
at java.lang.Thread.run(Unknown Source)

分享到：

关注

支持(0)

反对(0)

精彩评论 1

无语_mrkj

学分：3155 LV11

+关注

私信

2012-05-14

沙发

请问您使用的SQL Server数据库是2000还是2005.还有您是否对源程序中的连接数据库的代码进行了修改？
如果是2005，那么需要设置ICP/IP协议启动，具体如下：
   （1）打开SQL Server Configuration Manager
   （2）转到SQL Server 2005 Network Configuration->Protocols for MAHAIBO
   （3）将TCP/IP设置为Enabled（启用）
   （4）双击TCP/IP项，转到IP Addresses页
   （5）IP All中设置TCP Port为1433
   （6）重新启动服务

支持(0)

反对(0)

首页上一页 1 下一页尾页 1 条记录 1/1页