断网后出现获取数据库连接异常

[东莞IT男]

本来开发一直正常，可是突然断网了，等网络恢复以后，我就链接不上服务器的数据，出现一下异常（注意，本来一直是正常的）：

javax.servlet.ServletException:
异常原因：获取数据库连接异常
解决办法：检查应用服务器数据库连接池配置是否正确
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:846)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:779)
org.apache.jsp.index_jsp._jspService(index_jsp.java:3747)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:328)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:315)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
com.sunline.jraf.web.EncodingFilter.doFilter(EncodingFilter.java:34)
com.dic.szclue.web.filter.VerificationAuthorityFilter.doFilter(VerificationAuthorityFilter.java:141)
org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:75)
org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:77)




org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Listener refused the connection with the following error:
ORA-12519, TNS:no appropriate service handler found
The Connection descriptor used by the client was:
192.168.1.148:1521:oracl
)
org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:855)
org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:540)
com.dic.iportal.cms.database.JdbcTemplate.createConntectionByJndi(JdbcTemplate.java:205)
com.dic.iportal.cms.database.JdbcTemplate.createConntectionByJndi(JdbcTemplate.java:186)
com.dic.iportal.cms.dao.ImgDAO.getImgIDByCloId(ImgDAO.java:596)
com.dic.iportal.cms.br.InfoManager.getImgIDByCloId(InfoManager.java:168)
org.apache.jsp.index_jsp._jspService(index_jsp.java:78)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:328)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:315)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
com.sunline.jraf.web.EncodingFilter.doFilter(EncodingFilter.java:34)
com.dic.szclue.web.filter.VerificationAuthorityFilter.doFilter(VerificationAuthorityFilter.java:141)
org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:75)
org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:77)

[叶涛网站推广优化]

重启数据库

[东莞IT男]

我重启了我的电脑就行了，呵呵

[junnef]

数据库连接池出问题了，最好根据用的连接池类型，配置属性，在使用连接前判断是否可用，就是加个sql语句的判断。

[东莞IT男]

配置一定是没有错的，因为一直都是正常的

[crazylaa]

[Quote=引用 4 楼 stephenyindezhi 的回复:]

配置一定是没有错的，因为一直都是正常的
[/Quote]

重启你的应用和oracle服务即可。主要可能时ip变动了。另一个就是应用的连接池没有实现断线重连机制

[youyudetufei]

没别的错误，只是网络连接中断造成数据库连中断啦，重启服务器就一切oK啦！

[fczfr]

有什么办法，可以不需要重启服务器