哪位大牛帮助解决一下，我把公司项目带回家里做，tomcat好好地，已发送请求就出说错！说我数据库连不上，我用的是Sql Server 2008 R2 拜托了

liml716 2017-11-29 10:21:39
org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory, cause:
java.sql.SQLException: Network error IOException: Connection refused: connect
at net.sourceforge.jtds.jdbc.ConnectionJDBC2.<init>(ConnectionJDBC2.java:371)
at net.sourceforge.jtds.jdbc.ConnectionJDBC3.<init>(ConnectionJDBC3.java:50)
at net.sourceforge.jtds.jdbc.Driver.connect(Driver.java:188)
at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:82)
at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:300)
at org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:838)
at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:821)
at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:518)
at com.bonc.javax.DataCenter.connect(Unknown Source:187)
at com.bonc.javax.DataCenter.connect(Unknown Source:147)
at com.jh.module.security.login.action.LoginAction.handle(LoginAction.java:48)
at com.bonc.javax.struts.BONCAction.execute(Unknown Source:94)
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:685)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:160)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:641)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:225)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:169)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:927)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407)
at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:999)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:565)
at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:309)
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
Caused by: java.net.ConnectException: Connection refused: connect
at java.net.DualStackPlainSocketImpl.connect0(Native Method)
at java.net.DualStackPlainSocketImpl.socketConnect(Unknown Source)
at java.net.AbstractPlainSocketImpl.doConnect(Unknown Source)
at java.net.AbstractPlainSocketImpl.connectToAddress(Unknown Source)
at java.net.AbstractPlainSocketImpl.connect(Unknown Source)
at java.net.PlainSocketImpl.connect(Unknown Source)
at java.net.SocksSocketImpl.connect(Unknown Source)
at java.net.Socket.connect(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at net.sourceforge.jtds.jdbc.SharedSocket.<init>(SharedSocket.java:275)
at net.sourceforge.jtds.jdbc.ConnectionJDBC2.<init>(ConnectionJDBC2.java:300)
... 33 more
java.lang.NullPointerException
at com.bonc.javax.DataCenter.setAutoCommit(Unknown Source:1275)
at com.jh.module.security.login.action.LoginAction.handle(LoginAction.java:49)
at com.bonc.javax.struts.BONCAction.execute(Unknown Source:94)
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:685)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:160)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:641)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:225)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:169)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:927)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407)
at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:999)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:565)
at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:309)
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
启动失败!
十一月 29, 2017 9:48:48 下午 org.apache.catalina.core.ApplicationDispatcher invoke
SEVERE: Servlet.service() for servlet jsp threw exception
java.lang.NullPointerException
at org.apache.jsp.app.security.login.Login_jsp._jspService(Login_jsp.java:80)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:432)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:390)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:334)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:684)
at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:471)
at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:402)
at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:329)
at org.apache.struts.action.RequestProcessor.doForward(RequestProcessor.java:1054)
at org.apache.struts.action.RequestProcessor.processForwardConfig(RequestProcessor.java:386)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:229)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:685)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:160)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:641)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:225)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:169)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:927)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407)
at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:999)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:565)
at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:309)
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
十一月 29, 2017 9:48:48 下午 org.apache.catalina.core.StandardWrapperValve invoke
SEVERE: Servlet.service() for servlet [action] in context with path [/crm] threw exception [An exception occurred processing JSP page /app/security/login/Login.jsp at line 17
14: //out.println("parent.login_fail();//");
15: <%
16: String flag=(String)request.getAttribute("flag");
17: if(flag.equals("1")){%>
18: alert("");
19: //history.go(-1);
20: <% }%>
Stacktrace:] with root cause
java.lang.NullPointerException
at org.apache.jsp.app.security.login.Login_jsp._jspService(Login_jsp.java:80)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:432)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:390)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:334)
...全文
403 20 打赏 收藏 转发到动态 举报
写回复
用AI写文章
20 条回复
切换为时间正序
请发表友善的回复…
发表回复
吉普赛的歌 2017-11-30
  • 打赏
  • 举报
 回复
引用 5 楼 liml716 的回复:
ip地址没错，端口号昨天也都看了1433，没什么问题
不用程序， 用 ssms ( sqlserver 自身的查询界面 )能不能连接进去？
liml716 2017-11-30
  • 打赏
  • 举报
 回复
ip地址没错，端口号昨天也都看了1433，没什么问题
liml716 2017-11-30
  • 打赏
  • 举报
 回复
我在家用的，用的是Sql Server 2008 R2
二月十六 2017-11-30
  • 打赏
  • 举报
 回复
1、ping一下ip地址看看ping的情况。 2、teinet 端口号看看能不能通。 3、检查一下防火墙设置，把防火墙关闭试试。 4、看看有没有进出站规则之类的设置。
吉普赛的歌 2017-11-30
  • 打赏
  • 举报
 回复
1. SQL Server2008 是你本机吗？ 2. 用 SQL Server 自身的 ssms 能不能连接上？
liml716 2017-11-30
  • 打赏
  • 举报
 回复
十分感谢各位大神对我这么一个菜鸟的帮助，尤其感谢OwenZeng_DBA、_大约在冬季_、二月十六、删库到跑路，谢谢
liml716 2017-11-30
  • 打赏
  • 举报
 回复
本地能连上啦
liml716 2017-11-30
  • 打赏
  • 举报
 回复
应该是公司没给权限吧，出现了正确的错误页面，不在报500错误了
吉普赛的歌 2017-11-30
  • 打赏
  • 举报
 回复

你这里的逗号是全角的。
liml716 2017-11-30
  • 打赏
  • 举报
 回复
按照您之前做的应该是连上了，因为出现了新的错误 update portal_online_user set status = '2' where status <> '0' and datediff(mi,last_time,getdate()) > 5 select Distinct user_name from PORTAL_ONLINE_USER where STATUS=1 java.sql.SQLException: 对象名 'PORTAL_ONLINE_USER' 无效。 at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:364) at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2754) at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2195) at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:620) at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:372) at net.sourceforge.jtds.jdbc.JtdsStatement.executeQuery(JtdsStatement.java:1176) at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:188) at com.bonc.javax.DataCenter.retrieve(Unknown Source:573) at com.bonc.javax.DataCenter.retrieve(Unknown Source:599) at com.jh.module.security.login.action.LoginAction.handle(LoginAction.java:76) at com.bonc.javax.struts.BONCAction.execute(Unknown Source:94) 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:685) at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:160) at javax.servlet.http.HttpServlet.service(HttpServlet.java:641) at javax.servlet.http.HttpServlet.service(HttpServlet.java:722) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:225) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:169) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:927) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407) at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:999) at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:565) at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:307) at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at java.lang.Thread.run(Unknown Source) java.lang.NullPointerException at com.jh.module.security.login.action.LoginAction.handle(LoginAction.java:77) at com.bonc.javax.struts.BONCAction.execute(Unknown Source:94) 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:685) at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:160) at javax.servlet.http.HttpServlet.service(HttpServlet.java:641) at javax.servlet.http.HttpServlet.service(HttpServlet.java:722) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:225) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:169) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:927) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407) at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:999) at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:565) at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:307) at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at java.lang.Thread.run(Unknown Source) 启动失败!
liml716 2017-11-30
  • 打赏
  • 举报
 回复
liml716 2017-11-30
  • 打赏
  • 举报
 回复
哥，我本地连接就连接不上，TCP/IP协议都已经启动了，端口号都是1433，服务也正常运行着，这什么问题？是不是我装的时候装错了，之前我电脑老是蓝屏就把它卸载了，这公司又要用，我就又装上了......
OwenZeng_DBA 2017-11-30
  • 打赏
  • 举报
 回复
这是CSDN问题，，等会重试下
liml716 2017-11-30
  • 打赏
  • 举报
 回复
哥，维护中......
OwenZeng_DBA 2017-11-30
  • 打赏
  • 举报
 回复
http://blog.csdn.net/z10843087/article/category/7225838 参考我的博客试试
liml716 2017-11-30
  • 打赏
  • 举报
 回复
大神，这个应该可以上去的，我以前也没用过这个数据库，截图给您看看哈
删库到跑路 2017-11-30
  • 打赏
  • 举报
 回复
引用 8 楼 liml716 的回复:
哥ssms是啥》怎么弄？




这个操作界面就是
liml716 2017-11-30
  • 打赏
  • 举报
 回复
哥ssms是啥》怎么弄？
marko39 2017-11-30
  • 打赏
  • 举报
 回复
Sql Server 2008 R2 默认是不允许远程连接的，许多修改许多配置信息，我也改过，还要重启！
碧水幽幽泉 2017-11-29
  • 打赏
  • 举报
 回复
网络问题，连接不上Oracle数据库。 应该是公司网络设置了防火墙！
资深大牛带你了解源码！GC+堆排+Tomcat+算法题，牛皮轰轰
如标题所示，我的个人背景非常简单，Java开发经验1年半，学历普通，2本本科毕业，毕业后出来就一直在Crud，在公司每天重复的工作对我的技术提升并没有什么帮助，但小镇出来的我也深知自我努力的重要性，想要改变...
一个 SpringBoot 项目能处理多少请求？
往期热门文章： ...4、大公司为什么禁止在 Spring Boot 项目中使用 @Autowired 注解？ 5、重磅！IDEA 版 Postman 新版发布，太炸了！今天给大家分享一位小伙伴在面试中所遇到的一道面试题：一个 S...
项目1在线交流平台-8.项目总结与部署-3.项目上线部署-linux部署tomcat项目
启动测试 `startup.sh`-启动 `访问nginx服务器` 参考牛客网高级项目教程 尚硅谷Linux教程笔记 功能需求 之前工作均是项目开发阶段，在本地操作测试即可 系统上线，需要将项目部署到远程服务器，例如linux服务器，...
有哪些IT初学者（新人）成长为技术大牛的真实经历？
【有哪些IT初学者（新人）成长为技术大牛的真实经历？】 第一章 定调 IT技术是以年来计算的，为什么会是以年来计算，等你们看完就会明白一点点。 做技术的，会就是会，不会就是不会，做不得假。 这条路从来都是...
秒杀项目（前后端分离）
1p/11p项目开篇 技术点总结 1、安装开发工具 2、项目架构介绍 常见的请求：返回前端页面HTML：Model+HTML模板 ajax异步请求：返回json数据【返回特定格式的字符串只返回Model】 本项目采用前后端分离架构，从视图...
疑难问题

22,210

社区成员

121,727

社区内容

发帖
与我相关
我的任务
社区描述
MS-SQL Server 疑难问题
社区管理员
  • 疑难问题社区
  • 尘觉
加入社区
  • 近7日
  • 近30日
  • 至今

加载中

查看更多榜单
社区公告
暂无公告

试试用AI创作助手写篇文章吧

+ 用AI写文章