问题描述
报的异常如下:org.apache.tomcat.dbcp.dbcp.SQLNestedException:Cannotgetaconnection,poolerrorTimeoutwaitingforidleobjectatorg.apache.tomcat.dbcp.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:104)atorg.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880)atssh.SqlConn.getStatement(SqlConn.java:37)atssh.SqlConn.<init>(SqlConn.java:23)atorg.apache.jsp.index_jsp._jspService(index_jsp.java:79)atorg.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)atjavax.servlet.http.HttpServlet.service(HttpServlet.java:803)atorg.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:331)atorg.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:329)atorg.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)atjavax.servlet.http.HttpServlet.service(HttpServlet.java:803)atorg.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)atorg.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)atorg.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)atorg.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174)atorg.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)atorg.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)atorg.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)atorg.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174)atorg.apache.coyote.http11.Http11Processor.process(Http11Processor.java:874)atorg.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)atorg.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)atorg.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)atorg.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)atjava.lang.Thread.run(UnknownSource)Causedby:java.util.NoSuchElementException:Timeoutwaitingforidleobjectatorg.apache.tomcat.dbcp.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:958)atorg.apache.tomcat.dbcp.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:96)...24more注:我已经在后台关闭连接了为什么还是不行??
解决方案
解决方案二:
这个可能对你有帮助
解决方案三:
谢谢
解决方案四:
你怎么配的啊看一下才好帮你解决
解决方案五:
配置是这样的::<Resourcename="jdbc/jydb"auth="Container"maxWait="10000"type="javax.sql.DataSource"username="test1213"password="test123"driverClassName="net.sourceforge.jtds.jdbcx.JtdsDataSource"url="jdbc:jtds:sqlserver://210.21.20.200:1863/JYDB"maxActive="100"maxIdle="30"/>