java.sql.SQLException: Cannot create PoolableConnectionFactory (Network error IOException: 解决方法
来源:互联网 发布:java获取公网ip地址 编辑:程序博客网 时间:2024/06/13 11:48
最近在安装sql server 2008的数据库,后台用的 是java语言,用的是存储过程,但是在访问数据库的时候报错,出现以下的错误详情,找了很多方法,最终还是没有解决,
因此,卸载了sql server,如此折腾,反复重启计算机,绞尽脑汁啊,,最后,细读错误提示的详情,终于功夫不负有心人,问题解决了,也是以后在配置sql server的这个数据库增加了点
经验,没有白费这几天的思考。。。哈哈哈。
java.sql.SQLException: Cannot create PoolableConnectionFactory (Network error IOException: Connection refused: connect)
java.sql.SQLException: Cannot create PoolableConnectionFactory (Network error IOException: Connection refused: connect) Query:at org.apache.commons.dbutils.AbstractQueryRunner.rethrow(AbstractQueryRunner.java:527)at org.apache.commons.dbutils.QueryRunner.execute(QueryRunner.java:956)at org.apache.commons.dbutils.QueryRunner.execute(QueryRunner.java:853)at com.lg.dao.NetCourseWareInfoDao.getNetCourseWare_InfoByTeacherID(NetCourseWareInfoDao.java:36)at com.lg.service.impl.NetCourseWareInfoServiceImpl.getNetCourseWare_InfoByTeacherID(NetCourseWareInfoServiceImpl.java:54)at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)at java.lang.reflect.Method.invoke(Method.java:606)at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:198)at com.sun.proxy.$Proxy11.getNetCourseWare_InfoByTeacherID(Unknown Source)at com.lg.controller.NetCourseWareInfoController.getNetCourseWareInfoByTeacherID(NetCourseWareInfoController.java:56)at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)at java.lang.reflect.Method.invoke(Method.java:606)at org.springframework.web.method.support.InvocableHandlerMethod.invoke(InvocableHandlerMethod.java:219)at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:132)at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:104)at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandleMethod(RequestMappingHandlerAdapter.java:746)at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:687)at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:80)at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:925)at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:856)at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:915)at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:811)at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:796)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.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)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:857)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(Thread.java:745)粗略看一下错误的第一句话,也就是标题,说明是网络的问题,sql默认的端口是1433,而我的数据库连接也是1433,java用的是jdbc连接类,以下是我连接数据库的配置文件,在连接数据库如有不懂的可以留言哈。
url=jdbc:jtds:sqlserver://ip:1433;DatabaseName=数据库名称username=用户名password=密码同样的,我在sql server的管理工具中,也是对tcp/ip进行了配置,包括通信管道啊都是开启的,但是就是连接不上。
说了这么多,来干货了,是因为sql server 的连接端口是默认1433,如果在重装数据库的时候,有可能对默认的端口进行更改了,包括一些注册表之类的干扰,因此设置的是这样的。
TCP端口并没有给默认的值,因此需要设置为1433
重新启动服务器,输入访问的数据的接口,就可以了。
阅读全文
0 0
- java.sql.SQLException: Cannot create PoolableConnectionFactory (Network error IOException: 解决方法
- org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Network error IOException: Connection refus
- Prototyper.java:98 :ERROR] Prototype java.sql.SQLException: Network error IOException: Connection
- jdbc连接sql server 出现 java.sql.SQLException: Network error IOException: Connection refused:
- 程序连接SQL Sever数据库出现:java.sql.SQLException: Network error IOException: Connection refused: connect 错误
- SqlServer连接异常java.sql.SQLException: Network error IOException: Connection refused: connect
- SqlServer默认端口1433未开放导致java.sql.SQLException: Network error IOException: Connection refused: connect
- java连接sql server2008 r2 错误Cannot create PoolableConnectionFactory 错误
- java.sql.SQLException: Cannot create 错误
- 使用Oracle连接池错误 Cannot create PoolableConnectionFactory(Io 异常: The Network Adapter could not establish the connection )的解决方法
- Cannot create PoolableConnectionFactory
- Cannot create PoolableConnectionFactory
- Cannot create PoolableConnectionFactory
- Cannot create PoolableConnectionFactory
- Cannot create PoolableConnectionFactory
- cannot create poolableconnectionfactory mysqlDataSource
- Cannot create PoolableConnectionFactory
- 出现Cannot create PoolableConnectionFactory
- 浅析json与jsonp区别及通过ajax获得json数据后格式的转换
- 2017长江之星大家唱活动规则
- 设置mysql_real_connect连接超时
- 文盲的数据库指令优化心得:第一部分,关于索引
- x-pack-5.6.0 破解,提供破解后的jar包
- java.sql.SQLException: Cannot create PoolableConnectionFactory (Network error IOException: 解决方法
- 一段判断wap设备的代码
- js中变量和jsp中java代码中变量互相访问解决方案
- sqlserver 统计所有的表的纪录数
- Previous operation has not finished; run 'cleanup' if it was interrupted
- su命令 sudo命令 限制root远程登录
- jQuery获取和计算对象(object)的长度
- ICP定位算法学习笔记(一)
- QCustomplot使用分享(二) 源码解读