服务器报错问题。org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get
org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is java.sql.SQLException: Network error IOException: No buffer space available (maximum connections reached?): connect
org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:80)
org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:382)
org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:456)
org.springframework.jdbc.core.JdbcTemplate.queryForRowSet(JdbcTemplate.java:499)
com.xc.xc.getRs(xc.java:605)
com.xc.xc.IsEmptySql(xc.java:2164)
com.xc.xc.IsEmptyTable(xc.java:2159)
com.xc.xc.GetSysVarX(xc.java:2983)
com.use.dm.xchead(dm.java:31)
com.use.dm.xchead(dm.java:12)
org.apache.jsp.mainmenu2_jsp._jspService(mainmenu2_jsp.java:71)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:377)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
com.xc.sso.LoginFilter.doFilter(LoginFilter.java:93)
org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)
org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)
root cause
java.sql.SQLException: Network error IOException: No buffer space available (maximum connections reached?): connect
net.sourceforge.jtds.jdbc.ConnectionJDBC2.<init>(ConnectionJDBC2.java:372)
net.sourceforge.jtds.jdbc.ConnectionJDBC3.<init>(ConnectionJDBC3.java:50)
net.sourceforge.jtds.jdbc.Driver.connect(Driver.java:178)
java.sql.DriverManager.getConnection(DriverManager.java:582)
java.sql.DriverManager.getConnection(DriverManager.java:154)
org.logicalcobwebs.proxool.DefaultConnectionBuilder.buildConnection(DefaultConnectionBuilder.java:39)
org.logicalcobwebs.proxool.Prototyper.buildConnection(Prototyper.java:159)
org.logicalcobwebs.proxool.ConnectionPool.getConnection(ConnectionPool.java:211)
org.logicalcobwebs.proxool.ProxoolDataSource.getConnection(ProxoolDataSource.java:97)
org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:111)
org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:77)
org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:382)
org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:456)
org.springframework.jdbc.core.JdbcTemplate.queryForRowSet(JdbcTemplate.java:499)
com.xc.xc.getRs(xc.java:605)
com.xc.xc.IsEmptySql(xc.java:2164)
com.xc.xc.IsEmptyTable(xc.java:2159)
com.xc.xc.GetSysVarX(xc.java:2983)
com.use.dm.xchead(dm.java:31)
com.use.dm.xchead(dm.java:12)
org.apache.jsp.mainmenu2_jsp._jspService(mainmenu2_jsp.java:71)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:377)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
com.xc.sso.LoginFilter.doFilter(LoginFilter.java:93)
org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)
org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)
root cause
java.net.SocketException: No buffer space available (maximum connections reached?): connect
java.net.PlainSocketImpl.socketConnect(Native Method)
java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:333)
java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:195)
java.net.PlainSocketImpl.connect(PlainSocketImpl.java:182)
java.net.SocksSocketImpl.connect(SocksSocketImpl.java:366)
java.net.Socket.connect(Socket.java:519)
sun.reflect.GeneratedMethodAccessor42.invoke(Unknown Source)
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
java.lang.reflect.Method.invoke(Method.java:597)
net.sourceforge.jtds.jdbc.SharedSocket.createSocketForJDBC3(SharedSocket.java:28
这是昨晚的报错信息。
运行环境:服务器系统是windows server 2008 R2 内存4G 使用的数据库是SQL Server 2008 R2 服务是tomcat 6.0
报错之后的操作过程
我首先, 是对数据库进行连接打开。却是链接不上,提示报错如下图

重启服务还是报错,如下图

花费了很多时间想办法,去重新连接数据库 ,但还是没有效果。没办法只能对服务器进行重启操作。
服务器重启问题就解决了。但这只是临时的处理方法。各位大牛们帮忙看看吧。小弟我不尽感谢了
org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:80)
org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:382)
org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:456)
org.springframework.jdbc.core.JdbcTemplate.queryForRowSet(JdbcTemplate.java:499)
com.xc.xc.getRs(xc.java:605)
com.xc.xc.IsEmptySql(xc.java:2164)
com.xc.xc.IsEmptyTable(xc.java:2159)
com.xc.xc.GetSysVarX(xc.java:2983)
com.use.dm.xchead(dm.java:31)
com.use.dm.xchead(dm.java:12)
org.apache.jsp.mainmenu2_jsp._jspService(mainmenu2_jsp.java:71)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:377)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
com.xc.sso.LoginFilter.doFilter(LoginFilter.java:93)
org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)
org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)
root cause
java.sql.SQLException: Network error IOException: No buffer space available (maximum connections reached?): connect
net.sourceforge.jtds.jdbc.ConnectionJDBC2.<init>(ConnectionJDBC2.java:372)
net.sourceforge.jtds.jdbc.ConnectionJDBC3.<init>(ConnectionJDBC3.java:50)
net.sourceforge.jtds.jdbc.Driver.connect(Driver.java:178)
java.sql.DriverManager.getConnection(DriverManager.java:582)
java.sql.DriverManager.getConnection(DriverManager.java:154)
org.logicalcobwebs.proxool.DefaultConnectionBuilder.buildConnection(DefaultConnectionBuilder.java:39)
org.logicalcobwebs.proxool.Prototyper.buildConnection(Prototyper.java:159)
org.logicalcobwebs.proxool.ConnectionPool.getConnection(ConnectionPool.java:211)
org.logicalcobwebs.proxool.ProxoolDataSource.getConnection(ProxoolDataSource.java:97)
org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:111)
org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:77)
org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:382)
org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:456)
org.springframework.jdbc.core.JdbcTemplate.queryForRowSet(JdbcTemplate.java:499)
com.xc.xc.getRs(xc.java:605)
com.xc.xc.IsEmptySql(xc.java:2164)
com.xc.xc.IsEmptyTable(xc.java:2159)
com.xc.xc.GetSysVarX(xc.java:2983)
com.use.dm.xchead(dm.java:31)
com.use.dm.xchead(dm.java:12)
org.apache.jsp.mainmenu2_jsp._jspService(mainmenu2_jsp.java:71)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:377)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
com.xc.sso.LoginFilter.doFilter(LoginFilter.java:93)
org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)
org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)
root cause
java.net.SocketException: No buffer space available (maximum connections reached?): connect
java.net.PlainSocketImpl.socketConnect(Native Method)
java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:333)
java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:195)
java.net.PlainSocketImpl.connect(PlainSocketImpl.java:182)
java.net.SocksSocketImpl.connect(SocksSocketImpl.java:366)
java.net.Socket.connect(Socket.java:519)
sun.reflect.GeneratedMethodAccessor42.invoke(Unknown Source)
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
java.lang.reflect.Method.invoke(Method.java:597)
net.sourceforge.jtds.jdbc.SharedSocket.createSocketForJDBC3(SharedSocket.java:28
这是昨晚的报错信息。
运行环境:服务器系统是windows server 2008 R2 内存4G 使用的数据库是SQL Server 2008 R2 服务是tomcat 6.0
报错之后的操作过程
我首先, 是对数据库进行连接打开。却是链接不上,提示报错如下图

重启服务还是报错,如下图

花费了很多时间想办法,去重新连接数据库 ,但还是没有效果。没办法只能对服务器进行重启操作。
服务器重启问题就解决了。但这只是临时的处理方法。各位大牛们帮忙看看吧。小弟我不尽感谢了

...全文
相关推荐
Springboot+MySQL,出现Could not get JDBC Connection
在Spring Boot应用中集成MySQL数据库时,可能会遇到“Could not get JDBC Connection”的错误,这个问题通常是由于数据源配置问题、数据库连接参数错误或者数据库权限问题所导致的
Spring JDBC模板类—org.springframework.jdbc.core.JdbcTemplate
在实际开发中,我们通常通过Spring Bean配置来注入`JdbcTemplate`,如下所示:```xml<bean id="jdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate
springboot报错:NoClassDefFoundError: org/springframework/transaction/ReactiveTransactionManager
"在Spring Boot应用中遇到一个启动错误,具体表现为`NoClassDefFoundError: org/springframework/transaction/ReactiveTransac
org.springframework.jdbc-3.0.2.RELEASE.jar
org.springframework.jdbc-3.0.2.RELEASE.jar, org.springframework.jdbc-3.0.2.RELEASE.jar
org.springframework.jdbc-3.1.2.RELEASE.jar
org.springframework.jdbc-3.1.2.RELEASE.jar


