org.springframework.jdbc.CannotGetJdbcConnectionEx ception

[tanmay]

Hi,
We are using springframework and in our QA and stagging environment we are getting org.springframework.jdbc.CannotGetJdbcConnectionEx ception:
and com.ibm.websphere.ce.cm.ConnectionWaitTimeoutExcep tion:.
We are not getting such exception in unit testing and development environment. Is Spring database connection management is not working???????

[robh]

Can you post the stack trace? Are you sure that the configuration in your production environment points to a real database?

Rob

[tanmay]

Hi,
Thanks for your response. As per your request i am putting stack trace. Actually we have left connection management on Spring, but some how connections are not released back to database.
17:17:24 04/22/2005 [Servlet.Engine.Transports : 35] ERROR org.apache.velocity.app.VelocityEngine - RHS of #set statement is null. Context will not be modified. general/dump_xml.vm [line 1, column 1]
17:17:24 04/22/2005 [Servlet.Engine.Transports : 7] WARN org.springframework.web.servlet.DispatcherServlet - Handler execution resulted in exception - forwarding to resolved error view
org.springframework.jdbc.CannotGetJdbcConnectionEx ception: Could not get JDBC connection; nested exception is com.ibm.websphere.ce.cm.ConnectionWaitTimeoutExcep tion: Connection not available, Timed out wait
ing.
com.ibm.websphere.ce.cm.ConnectionWaitTimeoutExcep tion: Connection not available, Timed out waiting.
at com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource.getConn ection(WSJdbcDataSource.java(Compiled Code))
at com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource.getConn ection(WSJdbcDataSource.java(Compiled Code))
at org.springframework.jdbc.datasource.DataSourceUtil s.doGetConnection(DataSourceUtils.java(Compiled Code))
at org.springframework.jdbc.datasource.DataSourceUtil s.getConnection(DataSourceUtils.java(Inlined Compiled Code))
at org.springframework.jdbc.datasource.DataSourceUtil s.getConnection(DataSourceUtils.java(Inlined Compiled Code))
at org.springframework.jdbc.core.JdbcTemplate.execute (JdbcTemplate.java(Compiled Code))
at org.springframework.jdbc.core.JdbcTemplate.query(J dbcTemplate.java(Compiled Code))
at org.springframework.jdbc.core.JdbcTemplate.query(J dbcTemplate.java(Inlined Compiled Code))
at org.springframework.jdbc.core.JdbcTemplate.query(J dbcTemplate.java(Inlined Compiled Code))
at org.springframework.jdbc.object.SqlQuery.execute(S qlQuery.java(Compiled Code))
at org.springframework.jdbc.object.SqlQuery.execute(S qlQuery.java:124)
at com.xyz.gs.main.StartPageDAO.getStartPageDocument( StartPageDAO.java:37)
at com.xyz.gs.main.MainController.refreshStartPage(Ma inController.java:129)
at java.lang.reflect.Method.invoke(Native Method)
at org.springframework.web.servlet.mvc.multiaction.Mu ltiActionController.invokeNamedMethod(MultiActionC ontroller.java:352)
at org.springframework.web.servlet.mvc.multiaction.Mu ltiActionController.handleRequestInternal(MultiAct ionController.java:305)
at org.springframework.web.servlet.mvc.AbstractContro ller.handleRequest(AbstractController.java(Compile d Code))
at org.springframework.web.servlet.mvc.SimpleControll erHandlerAdapter.handle(SimpleControllerHandlerAda pter.java(Compiled Code))
at org.springframework.web.servlet.DispatcherServlet. doService(DispatcherServlet.java(Compiled Code))
at org.springframework.web.servlet.FrameworkServlet.s erviceWrapper(FrameworkServlet.java(Compiled Code))
at org.springframework.web.servlet.FrameworkServlet.d oGet(FrameworkServlet.java:317)
at javax.servlet.http.HttpServlet.service(HttpServlet .java(Compiled Code))
at javax.servlet.http.HttpServlet.service(HttpServlet .java(Compiled Code))
at com.ibm.ws.webcontainer.servlet.StrictServletInsta nce.doService(StrictServletInstance.java(Compiled Code))
at com.ibm.ws.webcontainer.servlet.StrictLifecycleSer vlet._service(StrictLifecycleServlet.java(Compiled Code))
at com.ibm.ws.webcontainer.servlet.IdleServletState.s ervice(StrictLifecycleServlet.java(Compiled Code))
at com.ibm.ws.webcontainer.servlet.StrictLifecycleSer vlet.service(StrictLifecycleServlet.java(Inlined Compiled Code))
at com.ibm.ws.webcontainer.servlet.ServletInstance.se rvice(ServletInstance.java(Compiled Code))
at com.ibm.ws.webcontainer.servlet.ValidServletRefere nceState.dispatch(ValidServletReferenceState.java( Compiled Code))
at com.ibm.ws.webcontainer.servlet.ServletInstanceRef erence.dispatch(ServletInstanceReference.java(Inli ned Compiled Code))
at com.ibm.ws.webcontainer.webapp.WebAppRequestDispat cher.handleWebAppDispatch(WebAppRequestDispatcher. java(Compiled Code))
at com.ibm.ws.webcontainer.webapp.WebAppRequestDispat cher.dispatch(WebAppRequestDispatcher.java(Compile d Code))
at com.ibm.ws.webcontainer.webapp.WebAppRequestDispat cher.forward(WebAppRequestDispatcher.java(Compiled Code))
at com.ibm.ws.webcontainer.srt.WebAppInvoker.doForwar d(WebAppInvoker.java(Compiled Code))
at com.ibm.ws.webcontainer.srt.WebAppInvoker.handleIn vocationHook(WebAppInvoker.java(Compiled Code))
at com.ibm.ws.webcontainer.cache.invocation.CachedInv ocation.handleInvocation(CachedInvocation.java(Com piled Code))
at com.ibm.ws.webcontainer.srp.ServletRequestProcesso r.dispatchByURI(ServletRequestProcessor.java(Compi led Code))
at com.ibm.ws.webcontainer.oselistener.OSEListenerDis patcher.service(OSEListener.java(Compiled Code))
at com.ibm.ws.webcontainer.http.HttpConnection.handle Request(HttpConnection.java(Compiled Code))
at com.ibm.ws.http.HttpConnection.readAndHandleReques t(HttpConnection.java(Compiled Code))
at com.ibm.ws.http.HttpConnection.run(HttpConnection. java(Compiled Code))
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.j ava:672)

[Rod Johnson]

What's your transaction management strategy?

[jadebuddha]

Was there ever a resolution to this issue or was it user error and never closed?