I am getting "Cannot get a connection, pool exhausted" and "Timeout waiting for idle object" and web server getting slow
| 0:30:49,713 INFO [stdout] (http-/10.68.38.11:8080-79) | at com.estel.mbanking.webcommon.vendoropt.commonservices.UserLoginControler.listAllByUserId(UserLoginControler.java:1280) |
| 10:30:49,713 INFO [stdout] (http-/10.68.38.11:8080-79) | at com.estel.mbanking.webcommon.servlet.CheckUserServlet.service(CheckUserServlet.java:131) |
| 10:30:49,713 INFO [stdout] (http-/10.68.38.11:8080-79) | at javax.servlet.http.HttpServlet.service(HttpServlet.java:847) |
| 10:30:49,713 INFO [stdout] (http-/10.68.38.11:8080-79) | at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:329) |
| 10:30:49,713 INFO [stdout] (http-/10.68.38.11:8080-79) | at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248) |
| 10:30:49,714 INFO [stdout] (http-/10.68.38.11:8080-79) | at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:275) |
| 10:30:49,714 INFO [stdout] (http-/10.68.38.11:8080-79) | at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:161) |
| 10:30:49,714 INFO [stdout] (http-/10.68.38.11:8080-79) | at org.jboss.as.web.security.SecurityContextAssociationValve.invoke(SecurityContextAssociationValve.java:153) |
| 10:30:49,714 INFO [stdout] (http-/10.68.38.11:8080-79) | at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:155) |
| 10:30:49,714 INFO [stdout] (http-/10.68.38.11:8080-79) | at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) |
| 10:30:49,714 INFO [stdout] (http-/10.68.38.11:8080-79) | at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) |
| 10:30:49,714 INFO [stdout] (http-/10.68.38.11:8080-79) | at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:368) |
| 10:30:49,714 INFO [stdout] (http-/10.68.38.11:8080-79) | at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:877) |
| 10:30:49,714 INFO [stdout] (http-/10.68.38.11:8080-79) | at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:679) |
| 10:30:49,714 INFO [stdout] (http-/10.68.38.11:8080-79) | at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:931) |
| 10:30:49,714 INFO [stdout] (http-/10.68.38.11:8080-79) | at java.lang.Thread.run(Thread.java:619) |
10:30:49,714 INFO [stdout] (http-/10.68.38.11:8080-79) Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot get a connection, pool exhausted
| 10:30:49,715 INFO [stdout] (http-/10.68.38.11:8080-79) | at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:103) |
| 10:30:49,715 INFO [stdout] (http-/10.68.38.11:8080-79) | at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:540) |
| 10:30:49,715 INFO [stdout] (http-/10.68.38.11:8080-79) | at org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider.getConnection(LocalDataSourceConnectionProvider.java:81 |
)
| 10:30:49,715 INFO [stdout] (http-/10.68.38.11:8080-79) | at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:417) |
| 10:30:49,724 INFO [stdout] (http-/10.68.38.11:8080-79) | ... 39 more |
10:30:49,724 INFO [stdout] (http-/10.68.38.11:8080-79) Caused by: java.util.NoSuchElementException: Timeout waiting for idle object
| 10:30:49,732 INFO [stdout] (http-/10.68.38.11:8080-79) | at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:825) |
| 10:30:49,732 INFO [stdout] (http-/10.68.38.11:8080-79) | at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:95) |
| 10:30:49,732 INFO [stdout] (http-/10.68.38.11:8080-79) | ... 42 more |
10:30:49,732 INFO [stdout] (http-/10.68.38.11:8080-14) 17 Jul 2014 10:30:33,734 - DEBUG - | End! UserRightsServiceImpl - listAllRigtsByUserId()
10:30:49,733 INFO [stdout] (http-/10.68.38.11:8080-79) 17 Jul 2014 10:30:49,732 - ERROR - | Exception! UserRightsServiceImpl - listAllRigtsByUserId(): JDBC exception on Hibernate data access
; nested exception is org.hibernate.exception.GenericJDBCException: Cannot open connectioncom.estel.mbanking.webcommon.service.ReportsMenuServiceImpl.listAllMenuByUserId.91()!
10:30:49,733 INFO [stdout] (http-/10.68.38.11:8080-127) 17 Jul 2014 10:30:33,731 - WARN - | SQL Error: 0, SQLState: null
10:30:49,737 INFO [stdout] (http-/10.68.38.11:8080-127) 17 Jul 2014 10:30:49,733 - ERROR - | Cannot get a connection, pool exhausted
10:30:49,745 INFO [stdout] (http-/10.68.38.11:8080-14) 17 Jul 2014 10:30:49,732 - DEBUG - | userRights = 5
10:30:49,746 INFO [stdout] (http-/10.68.38.11:8080-39) 17 Jul 2014 10:30:49,688 - WARN - | SQL Warning: 0, SQLState: 01I01
10:30:49,750 INFO [stdout] (http-/10.68.38.11:8080-113) 17 Jul 2014 10:30:49,583 - DEBUG - | End! UserRightsServiceImpl - listAllRigtsByUserId()
10:30:49,750 INFO [stdout] (http-/10.68.38.11:8080-127) 17 Jul 2014 10:30:49,746 - ERROR - | Exception! UserRightsServiceImpl - listAllRigtsByUserId(): JDBC exception on Hibernate data acces
s; nested exception is org.hibernate.exception.GenericJDBCException: Cannot open connectioncom.estel.mbanking.webcommon.service.UserRightsServiceImpl.listAllRigtsByUserId.100()!
10:30:49,751 INFO [stdout] (http-/10.68.38.11:8080-36) 17 Jul 2014 10:30:49,582 - DEBUG - | End! UserRightsServiceImpl - listAllRigtsByUserId()
10:30:49,751 INFO [stdout] (http-/10.68.38.11:8080-116) 17 Jul 2014 10:30:49,579 - DEBUG - | End! UserLoginServiceImpl - getUserByName(GUJ_AE_gmehta)
10:30:49,751 INFO [stdout] (http-/10.68.38.11:8080-15) 17 Jul 2014 10:30:49,575 - ERROR - | ReportPropertyReader Exception ::com.estel.utilities.ReportPropertyReader.getProperty.113()!
10:30:49,751 INFO [stdout] (http-/10.68.38.11:8080-149) 17 Jul 2014 10:30:49,575 - DEBUG - | Start! UserLoginControler - userRights(2113)