Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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:
- org.apache.commons.dbcp.SQLNestedException: Cannot get a connection, pool error Timeout waiting for idle object
- at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:104)
- at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880)
- at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:113)
- at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:79)
- at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:522)
- at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:586)
- at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:611)
- at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:643)
- at org.springframework.jdbc.object.SqlQuery.execute(SqlQuery.java:111)
- at org.springframework.jdbc.object.SqlQuery.execute(SqlQuery.java:198)
- at org.springframework.jdbc.object.SqlQuery.execute(SqlQuery.java:206)
- at org.lifewithchrist.dao.WeblogJdbcDao.get(Unknown Source)
- at org.lifewithchrist.web.BaseWeblogDisplayController.handleRequestInternal(Unknown Source)
- at org.lifewithchrist.web.WeblogDisplayIndexController.handleRequestInternal(Unknown Source)
- at org.springframework.web.servlet.mvc.AbstractController.handleRequest(AbstractController.java:153)
- at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:48)
- at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:839)
- at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:774)
- at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:460)
- at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:415)
- at javax.servlet.http.HttpServlet.service(HttpServlet.java:707)
- at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
- at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:491)
- at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:367)
- at org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:185)
- at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:181)
- at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:689)
- at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:391)
- at org.mortbay.jetty.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:146)
- at org.mortbay.jetty.handler.HandlerCollection.handle(HandlerCollection.java:114)
- at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:139)
- at org.mortbay.jetty.Server.handle(Server.java:285)
- at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:457)
- at org.mortbay.jetty.HttpConnection$RequestHandler.headerComplete(HttpConnection.java:751)
- at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:500)
- at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:209)
- at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:357)
- at org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:329)
- at org.mortbay.thread.BoundedThreadPool$PoolThread.run(BoundedThreadPool.java:475)
- Caused by: java.util.NoSuchElementException: Timeout waiting for idle object
- at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:825)
- at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:96)
- ... 38 more
- My configuration is:
- <bean id="dataSource" destroy-method="close"
- class="org.apache.commons.dbcp.BasicDataSource">
- <property name="driverClassName"><value>org.postgresql.Driver</value></property>
- <property name="url"><value>jdbc:postgresql:lwc3_spring</value></property>
- <property name="username"><value>user</value></property>
- <property name="password"><value>password</value></property>
- <!-- Connection pool parameters -->
- <property name="defaultAutoCommit" value="true" />
- <property name="initialSize" value="8" />
- <property name="maxActive" value="20" />
- <property name="maxIdle" value="10" />
- <property name="maxWait" value="10000" />
- <property name="minIdle" value="1" />
- <property name="testOnBorrow" value="false" />
- <property name="testOnReturn" value="false" />
- <property name="testWhileIdle" value="true" />
- <property name="timeBetweenEvictionRunsMillis" value="300000" />
- <property name="validationQuery" value="select 1" />
- </bean>
Add Comment
Please, Sign In to add comment