org.jboss.util.NestedSQLException 这个是怎么回事啊 有没有人遇到过 该怎么解决

06:58:09,918 ERROR [STDERR] org.jboss.util.NestedSQLException: No ManagedConnections available within configured blocking timeout ( 30000 [ms] ); - nested throwable: (javax.resource.ResourceException:No ManagedConnections available within configured blocking timeout ( 30000 [ms] ))
06:58:09,919 ERROR [STDERR]     at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:95)
06:58:09,919 ERROR [STDERR]     at common.dao.DAOFactory.getKmConnection(DAOFactory.java:121)
06:58:09,920 ERROR [STDERR]     at com.sunline.portal.PersonUIDao.getbosid(PersonUIDao.java:133)
06:58:09,920 ERROR [STDERR]     at com.sunline.portal.PersonUIConfigDelegate.SetwidgetsData(PersonUI
ConfigDelegate.java:43)
06:58:09,921 ERROR [STDERR]     at org.apache.jsp.homepage.savewidget_jsp._jspService(savewidget_jsp
.java:61)
06:58:09,922 ERROR [STDERR]     at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
06:58:09,923 ERROR [STDERR]     at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
06:58:09,924 ERROR [STDERR]     at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:373)
06:58:09,924 ERROR [STDERR]     at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:336)
06:58:09,925 ERROR [STDERR]     at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)
06:58:09,926 ERROR [STDERR]     at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
06:58:09,926 ERROR [STDERR]     at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
06:58:09,927 ERROR [STDERR]     at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
06:58:09,927 ERROR [STDERR]     at common.filter.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:45)
06:58:09,928 ERROR [STDERR]     at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
06:58:09,928 ERROR [STDERR]     at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
06:58:09,929 ERROR [STDERR]     at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
06:58:09,930 ERROR [STDERR]     at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
06:58:09,930 ERROR [STDERR]     at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
06:58:09,931 ERROR [STDERR]     at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:230)
06:58:09,931 ERROR [STDERR]     at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
06:58:09,932 ERROR [STDERR]     at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:182)
06:58:09,932 ERROR [STDERR]     at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:84)
06:58:09,933 ERROR [STDERR]     at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
06:58:09,933 ERROR [STDERR]     at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
06:58:09,934 ERROR [STDERR]     at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
06:58:09,934 ERROR [STDERR]     at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:262)
06:58:09,935 ERROR [STDERR]     at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
06:58:09,935 ERROR [STDERR]     at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
06:58:09,936 ERROR [STDERR]     at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:446)
06:58:09,936 ERROR [STDERR]     at java.lang.Thread.run(Thread.java:595)
06:58:09,937 ERROR [STDERR] Caused by: javax.resource.ResourceException: No ManagedConnections available within configured blocking timeout ( 30000 [ms] )
06:58:09,938 ERROR [STDERR]     at org.jboss.resource.connectionmanager.InternalManagedConnectionPoo
l.getConnection(InternalManagedConnectionPool.java:303)
06:58:09,938 ERROR [STDERR]     at org.jboss.resource.connectionmanager.JBossManagedConnectionPool$BasePool.getConnection(JBossManagedConnectionPool.java:575)
06:58:09,940 ERROR [STDERR]     at org.jboss.resource.connectionmanager.BaseConnectionManager2.getManagedConnection(BaseConnectionManager2.java:347)
06:58:09,940 ERROR [STDERR]     at org.jboss.resource.connectionmanager.TxConnectionManager.getManagedConnection(TxConnectionManager.java:330)
06:58:09,940 ERROR [STDERR]     at org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionManager2.java:402)
06:58:09,942 ERROR [STDERR]     at org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateConnection(BaseConnectionManager2.java:849)
06:58:09,942 ERROR [STDERR]     at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:89)
06:58:09,942 ERROR [STDERR]     ... 30 more


06:58:39,971 INFO  [STDOUT] 是否成功:false

2 个解决方案

#1

应该是有耗时较长的sql占着会话

#2

http://www.emsflow.com/bbs/dispbbs.asp?boardID=16&ID=79&page=1

连接数不够了