服务器报错问题。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

报错之后的操作过程
我首先， 是对数据库进行连接打开。却是链接不上，提示报错如下图


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


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

[孟子E章]

No buffer space available (maximum connections reached?): connect 看错误是不是数据库的最大连接数设置的太小了 这一般是没有采用数据库连接池，或者连接没有正确关闭的导致