Guest User

Untitled

a guest
Mar 3rd, 2018
77
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 5.01 KB | None | 0 0
  1. 2007-04-23 13:25:36.036::WARN: Nested in org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot get a connection, pool error Timeout waiting for idle object:
  2. org.apache.commons.dbcp.SQLNestedException: Cannot get a connection, pool error Timeout waiting for idle object
  3. at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:104)
  4. at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880)
  5. at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:113)
  6. at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:79)
  7. at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:522)
  8. at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:586)
  9. at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:611)
  10. at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:643)
  11. at org.springframework.jdbc.object.SqlQuery.execute(SqlQuery.java:111)
  12. at org.springframework.jdbc.object.SqlQuery.execute(SqlQuery.java:198)
  13. at org.springframework.jdbc.object.SqlQuery.execute(SqlQuery.java:206)
  14. at org.lifewithchrist.dao.WeblogJdbcDao.get(Unknown Source)
  15. at org.lifewithchrist.web.BaseWeblogDisplayController.handleRequestInternal(Unknown Source)
  16. at org.lifewithchrist.web.WeblogDisplayIndexController.handleRequestInternal(Unknown Source)
  17. at org.springframework.web.servlet.mvc.AbstractController.handleRequest(AbstractController.java:153)
  18. at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:48)
  19. at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:839)
  20. at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:774)
  21. at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:460)
  22. at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:415)
  23. at javax.servlet.http.HttpServlet.service(HttpServlet.java:707)
  24. at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
  25. at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:491)
  26. at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:367)
  27. at org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:185)
  28. at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:181)
  29. at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:689)
  30. at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:391)
  31. at org.mortbay.jetty.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:146)
  32. at org.mortbay.jetty.handler.HandlerCollection.handle(HandlerCollection.java:114)
  33. at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:139)
  34. at org.mortbay.jetty.Server.handle(Server.java:285)
  35. at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:457)
  36. at org.mortbay.jetty.HttpConnection$RequestHandler.headerComplete(HttpConnection.java:751)
  37. at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:500)
  38. at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:209)
  39. at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:357)
  40. at org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:329)
  41. at org.mortbay.thread.BoundedThreadPool$PoolThread.run(BoundedThreadPool.java:475)
  42. Caused by: java.util.NoSuchElementException: Timeout waiting for idle object
  43. at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:825)
  44. at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:96)
  45. ... 38 more
  46.  
  47. My configuration is:
  48.  
  49. <bean id="dataSource" destroy-method="close"
  50. class="org.apache.commons.dbcp.BasicDataSource">
  51. <property name="driverClassName"><value>org.postgresql.Driver</value></property>
  52. <property name="url"><value>jdbc:postgresql:lwc3_spring</value></property>
  53. <property name="username"><value>user</value></property>
  54. <property name="password"><value>password</value></property>
  55.  
  56. <!-- Connection pool parameters -->
  57. <property name="defaultAutoCommit" value="true" />
  58. <property name="initialSize" value="8" />
  59. <property name="maxActive" value="20" />
  60. <property name="maxIdle" value="10" />
  61. <property name="maxWait" value="10000" />
  62. <property name="minIdle" value="1" />
  63. <property name="testOnBorrow" value="false" />
  64. <property name="testOnReturn" value="false" />
  65. <property name="testWhileIdle" value="true" />
  66. <property name="timeBetweenEvictionRunsMillis" value="300000" />
  67. <property name="validationQuery" value="select 1" />
  68. </bean>
Add Comment
Please, Sign In to add comment