Resouce Allocation Exception when connecting to DB using connection pooling.
vikram nalagampalli
Ranch Hand
Joined: Oct 08, 2001
Posts: 91
posted
0
Hello gurus, I am trying to connect to DB using Connection pooling with WSAD. I get the following error when i tried to acess the backend. It Breaks at getConnection() method in my class. I will really appreciate any suggestions or inputs on why i am getting this error.
FreePool E J2CA0046E: Method createManagedConnectionWithMCWrapper caught an exception during creation of the ManagedConnection for resource jdbc/v84dwnlodDS, throwing ResourceAllocationException. Original exception: java.lang.NullPointerException at com.ibm.ws.rsadapter.spi.WSRdbDataSource.getConnection(WSRdbDataSource.java:409) at com.ibm.ws.rsadapter.spi.WSManagedConnectionFactoryImpl.createManagedConnection(WSManagedConnectionFactoryImpl.java:558) at com.ibm.ejs.j2c.poolmanager.FreePool.createManagedConnectionWithMCWrapper(FreePool.java:1170) at com.ibm.ejs.j2c.poolmanager.FreePool.createOrWaitForConnection(FreePool.java:957) at com.ibm.ejs.j2c.poolmanager.PoolManager.reserve(PoolManager.java:1408) at com.ibm.ejs.j2c.ConnectionManager.allocateMCWrapper(ConnectionManager.java:589) at com.ibm.ejs.j2c.ConnectionManager.allocateConnection(ConnectionManager.java:392) at com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource.getConnection(WSJdbcDataSource.java:206) at com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource.getConnection(WSJdbcDataSource.java:182) at com.strykercorp.ortho.persistence.DBUtility.getConnection(DBUtility.java:177) at com.strykercorp.ortho.persistence.demo.DemoServiceImpl.getDomesticSales(DemoServiceImpl.java:51) at com.strykercorp.ortho.action.db2AS400.DailySalesAction.performTask(DailySalesAction.java:96) at com.strykercorp.ortho.action.BaseAction.callPerformTask(BaseAction.java:191) at com.strykercorp.ortho.action.BaseAction.execute(BaseAction.java:136) at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:465) at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274) at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1422) at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:505) at javax.servlet.http.HttpServlet.service(HttpServlet.java:740) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at com.ibm.ws.webcontainer.servlet.StrictServletInstance.doService(StrictServletInstance.java:110) at com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet._service(StrictLifecycleServlet.java:174) at com.ibm.ws.webcontainer.servlet.IdleServletState.service(StrictLifecycleServlet.java:313) at com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet.service(StrictLifecycleServlet.java:116) at com.ibm.ws.webcontainer.servlet.ServletInstance.service(ServletInstance.java:283) at com.ibm.ws.webcontainer.servlet.ValidServletReferenceState.dispatch(ValidServletReferenceState.java:42) at com.ibm.ws.webcontainer.servlet.ServletInstanceReference.dispatch(ServletInstanceReference.java:40) at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.handleWebAppDispatch(WebAppRequestDispatcher.java:923) at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.dispatch(WebAppRequestDispatcher.java:528) at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.forward(WebAppRequestDispatcher.java:176) at com.ibm.ws.webcontainer.srt.WebAppInvoker.doForward(WebAppInvoker.java:79) at com.ibm.ws.webcontainer.srt.WebAppInvoker.handleInvocationHook(WebAppInvoker.java:201) at com.ibm.ws.webcontainer.cache.invocation.CachedInvocation.handleInvocation(CachedInvocation.java:71) at com.ibm.ws.webcontainer.srp.ServletRequestProcessor.dispatchByURI(ServletRequestProcessor.java:182) at com.ibm.ws.webcontainer.oselistener.OSEListenerDispatcher.service(OSEListener.java:334) at com.ibm.ws.webcontainer.http.HttpConnection.handleRequest(HttpConnection.java:56) at com.ibm.ws.http.HttpConnection.readAndHandleRequest(HttpConnection.java:516) at com.ibm.ws.http.HttpConnection.run(HttpConnection.java:366) at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:593) ---------------------------------------------------------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------- [3/3/04 12:58:05:196 EST] 4403c89 ConnectionMan E J2CA0020E: The Connection Pool Manager could not allocate a Managed Connection: javax.resource.spi.ResourceAllocationException at com.ibm.ejs.j2c.poolmanager.FreePool.createManagedConnectionWithMCWrapper(FreePool.java:1223) at com.ibm.ejs.j2c.poolmanager.FreePool.createOrWaitForConnection(FreePool.java:957) at com.ibm.ejs.j2c.poolmanager.PoolManager.reserve(PoolManager.java:1408) at com.ibm.ejs.j2c.ConnectionManager.allocateMCWrapper(ConnectionManager.java:589) at com.ibm.ejs.j2c.ConnectionManager.allocateConnection(ConnectionManager.java:392) at com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource.getConnection(WSJdbcDataSource.java:206) at com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource.getConnection(WSJdbcDataSource.java:182) at com.strykercorp.ortho.persistence.DBUtility.getConnection(DBUtility.java:177) at com.strykercorp.ortho.persistence.demo.DemoServiceImpl.getDomesticSales(DemoServiceImpl.java:51) at com.strykercorp.ortho.action.db2AS400.DailySalesAction.performTask(DailySalesAction.java:96) at com.strykercorp.ortho.action.BaseAction.callPerformTask(BaseAction.java:191) at com.strykercorp.ortho.action.BaseAction.execute(BaseAction.java:136) at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:465) at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274) at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1422) at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:505) at javax.servlet.http.HttpServlet.service(HttpServlet.java:740) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at com.ibm.ws.webcontainer.servlet.StrictServletInstance.doService(StrictServletInstance.java:110) at com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet._service(StrictLifecycleServlet.java:174) at com.ibm.ws.webcontainer.servlet.IdleServletState.service(StrictLifecycleServlet.java:313) at com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet.service(StrictLifecycleServlet.java:116) at com.ibm.ws.webcontainer.servlet.ServletInstance.service(ServletInstance.java:283) at com.ibm.ws.webcontainer.servlet.ValidServletReferenceState.dispatch(ValidServletReferenceState.java:42) at com.ibm.ws.webcontainer.servlet.ServletInstanceReference.dispatch(ServletInstanceReference.java:40) at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.handleWebAppDispatch(WebAppRequestDispatcher.java:923) at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.dispatch(WebAppRequestDispatcher.java:528) at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.forward(WebAppRequestDispatcher.java:176) at com.ibm.ws.webcontainer.srt.WebAppInvoker.doForward(WebAppInvoker.java:79) at com.ibm.ws.webcontainer.srt.WebAppInvoker.handleInvocationHook(WebAppInvoker.java:201) at com.ibm.ws.webcontainer.cache.invocation.CachedInvocation.handleInvocation(CachedInvocation.java:71) at com.ibm.ws.webcontainer.srp.ServletRequestProcessor.dispatchByURI(ServletRequestProcessor.java:182) at com.ibm.ws.webcontainer.oselistener.OSEListenerDispatcher.service(OSEListener.java:334) at com.ibm.ws.webcontainer.http.HttpConnection.handleRequest(HttpConnection.java:56) at com.ibm.ws.http.HttpConnection.readAndHandleRequest(HttpConnection.java:516) at com.ibm.ws.http.HttpConnection.run(HttpConnection.java:366) at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:593) ---- Begin backtrace for Nested Throwables java.lang.NullPointerException at com.ibm.ws.rsadapter.spi.WSRdbDataSource.getConnection(WSRdbDataSource.java:409) at com.ibm.ws.rsadapter.spi.WSManagedConnectionFactoryImpl.createManagedConnection(WSManagedConnectionFactoryImpl.java:558) at com.ibm.ejs.j2c.poolmanager.FreePool.createManagedConnectionWithMCWrapper(FreePool.java:1170) at com.ibm.ejs.j2c.poolmanager.FreePool.createOrWaitForConnection(FreePool.java:957) at com.ibm.ejs.j2c.poolmanager.PoolManager.reserve(PoolManager.java:1408) at com.ibm.ejs.j2c.ConnectionManager.allocateMCWrapper(ConnectionManager.java:589) at com.ibm.ejs.j2c.ConnectionManager.allocateConnection(ConnectionManager.java:392) at com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource.getConnection(WSJdbcDataSource.java:206) at com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource.getConnection(WSJdbcDataSource.java:182) at com.strykercorp.ortho.persistence.DBUtility.getConnection(DBUtility.java:177) at com.strykercorp.ortho.persistence.demo.DemoServiceImpl.getDomesticSales(DemoServiceImpl.java:51) at com.strykercorp.ortho.action.db2AS400.DailySalesAction.performTask(DailySalesAction.java:96) at com.strykercorp.ortho.action.BaseAction.callPerformTask(BaseAction.java:191) at com.strykercorp.ortho.action.BaseAction.execute(BaseAction.java:136) at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:465) at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274) at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1422) at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:505) at javax.servlet.http.HttpServlet.service(HttpServlet.java:740) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at com.ibm.ws.webcontainer.servlet.StrictServletInstance.doService(StrictServletInstance.java:110) at com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet._service(StrictLifecycleServlet.java:174) at com.ibm.ws.webcontainer.servlet.IdleServletState.service(StrictLifecycleServlet.java:313) at com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet.service(StrictLifecycleServlet.java:116) at com.ibm.ws.webcontainer.servlet.ServletInstance.service(ServletInstance.java:283) at com.ibm.ws.webcontainer.servlet.ValidServletReferenceState.dispatch(ValidServletReferenceState.java:42) at com.ibm.ws.webcontainer.servlet.ServletInstanceReference.dispatch(ServletInstanceReference.java:40) at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.handleWebAppDispatch(WebAppRequestDispatcher.java:923) at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.dispatch(WebAppRequestDispatcher.java:528) at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.forward(WebAppRequestDispatcher.java:176) at com.ibm.ws.webcontainer.srt.WebAppInvoker.doForward(WebAppInvoker.java:79) at com.ibm.ws.webcontainer.srt.WebAppInvoker.handleInvocationHook(WebAppInvoker.java:201) at com.ibm.ws.webcontainer.cache.invocation.CachedInvocation.handleInvocation(CachedInvocation.java:71) at com.ibm.ws.webcontainer.srp.ServletRequestProcessor.dispatchByURI(ServletRequestProcessor.java:182) at com.ibm.ws.webcontainer.oselistener.OSEListenerDispatcher.service(OSEListener.java:334) at com.ibm.ws.webcontainer.http.HttpConnection.handleRequest(HttpConnection.java:56) at com.ibm.ws.http.HttpConnection.readAndHandleRequest(HttpConnection.java:516) at com.ibm.ws.http.HttpConnection.run(HttpConnection.java:366) at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:593) ---------------------------------------------------------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------- . [3/3/04 12:58:05:286 EST] 4403c89 SystemErr R com.strykercorp.ortho.exception.persistenceException.DBException: SQLException while getting a pooled connection. Check parameter settings. [3/3/04 12:58:05:286 EST] 4403c89 SystemErr R at com.strykercorp.ortho.persistence.DBUtility.getConnection(DBUtility.java:183) [3/3/04 12:58:05:286 EST] 4403c89 SystemErr R at com.strykercorp.ortho.persistence.demo.DemoServiceImpl.getDomesticSales(DemoServiceImpl.java:51) [3/3/04 12:58:05:286 EST] 4403c89 SystemErr R at com.strykercorp.ortho.action.db2AS400.DailySalesAction.performTask(DailySalesAction.java:96) [3/3/04 12:58:05:286 EST] 4403c89 SystemErr R at com.strykercorp.ortho.action.BaseAction.callPerformTask(BaseAction.java:191) [3/3/04 12:58:05:286 EST] 4403c89 SystemErr R at com.strykercorp.ortho.action.BaseAction.execute(BaseAction.java:136) [3/3/04 12:58:05:286 EST] 4403c89 SystemErr R at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:465) [3/3/04 12:58:05:286 EST] 4403c89 SystemErr R at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274) [3/3/04 12:58:05:286 EST] 4403c89 SystemErr R at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1422) [3/3/04 12:58:05:286 EST] 4403c89 SystemErr R at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:505) [3/3/04 12:58:05:286 EST] 4403c89 SystemErr R at javax.servlet.http.HttpServlet.service(HttpServlet.java:740) [3/3/04 12:58:05:286 EST] 4403c89 SystemErr R at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) [3/3/04 12:58:05:286 EST] 4403c89 SystemErr R at com.ibm.ws.webcontainer.servlet.StrictServletInstance.doService(StrictServletInstance.java:110) [3/3/04 12:58:05:286 EST] 4403c89 SystemErr R at com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet._service(StrictLifecycleServlet.java:174) [3/3/04 12:58:05:286 EST] 4403c89 SystemErr R at com.ibm.ws.webcontainer.servlet.IdleServletState.service(StrictLifecycleServlet.java:313) [3/3/04 12:58:05:286 EST] 4403c89 SystemErr R at com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet.service(StrictLifecycleServlet.java:116) [3/3/04 12:58:05:286 EST] 4403c89 SystemErr R at com.ibm.ws.webcontainer.servlet.ServletInstance.service(ServletInstance.java:283) [3/3/04 12:58:05:286 EST] 4403c89 SystemErr R at com.ibm.ws.webcontainer.servlet.ValidServletReferenceState.dispatch(ValidServletReferenceState.java:42) [3/3/04 12:58:05:286 EST] 4403c89 SystemErr R at com.ibm.ws.webcontainer.servlet.ServletInstanceReference.dispatch(ServletInstanceReference.java:40) [3/3/04 12:58:05:286 EST] 4403c89 SystemErr R at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.handleWebAppDispatch(WebAppRequestDispatcher.java:923) [3/3/04 12:58:05:286 EST] 4403c89 SystemErr R at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.dispatch(WebAppRequestDispatcher.java:528) [3/3/04 12:58:05:286 EST] 4403c89 SystemErr R at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.forward(WebAppRequestDispatcher.java:176) [3/3/04 12:58:05:286 EST] 4403c89 SystemErr R at com.ibm.ws.webcontainer.srt.WebAppInvoker.doForward(WebAppInvoker.java:79) [3/3/04 12:58:05:286 EST] 4403c89 SystemErr R at com.ibm.ws.webcontainer.srt.WebAppInvoker.handleInvocationHook(WebAppInvoker.java:201) [3/3/04 12:58:05:286 EST] 4403c89 SystemErr R at com.ibm.ws.webcontainer.cache.invocation.CachedInvocation.handleInvocation(CachedInvocation.java:71) [3/3/04 12:58:05:286 EST] 4403c89 SystemErr R at com.ibm.ws.webcontainer.srp.ServletRequestProcessor.dispatchByURI(ServletRequestProcessor.java:182) [3/3/04 12:58:05:286 EST] 4403c89 SystemErr R at com.ibm.ws.webcontainer.oselistener.OSEListenerDispatcher.service(OSEListener.java:334) [3/3/04 12:58:05:286 EST] 4403c89 SystemErr R at com.ibm.ws.webcontainer.http.HttpConnection.handleRequest(HttpConnection.java:56) [3/3/04 12:58:05:286 EST] 4403c89 SystemErr R at com.ibm.ws.http.HttpConnection.readAndHandleRequest(HttpConnection.java:516) [3/3/04 12:58:05:286 EST] 4403c89 SystemErr R at com.ibm.ws.http.HttpConnection.run(HttpConnection.java:366) [3/3/04 12:58:05:286 EST] 4403c89 SystemErr R at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:593) [3/3/04 12:58:05:286 EST] 4403c89 SystemErr R com.strykercorp.ortho.exception.BaseException: PerformTask: dto object from API is null [3/3/04 12:58:05:286 EST] 4403c89 SystemErr R at com.strykercorp.ortho.action.db2AS400.DailySalesAction.performTask(DailySalesAction.java:99) [3/3/04 12:58:05:286 EST] 4403c89 SystemErr R at com.strykercorp.ortho.action.BaseAction.callPerformTask(BaseAction.java:191) [3/3/04 12:58:05:286 EST] 4403c89 SystemErr R at com.strykercorp.ortho.action.BaseAction.execute(BaseAction.java:136) [3/3/04 12:58:05:286 EST] 4403c89 SystemErr R at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:465) [3/3/04 12:58:05:286 EST] 4403c89 SystemErr R at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274) [3/3/04 12:58:05:286 EST] 4403c89 SystemErr R at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1422) [3/3/04 12:58:05:286 EST] 4403c89 SystemErr R at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:505) [3/3/04 12:58:05:286 EST] 4403c89 SystemErr R at javax.servlet.http.HttpServlet.service(HttpServlet.java:740) [3/3/04 12:58:05:286 EST] 4403c89 SystemErr R at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) [3/3/04 12:58:05:286 EST] 4403c89 SystemErr R at com.ibm.ws.webcontainer.servlet.StrictServletInstance.doService(StrictServletInstance.java:110) [3/3/04 12:58:05:286 EST] 4403c89 SystemErr R at com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet._service(StrictLifecycleServlet.java:174) [3/3/04 12:58:05:286 EST] 4403c89 SystemErr R at com.ibm.ws.webcontainer.servlet.IdleServletState.service(StrictLifecycleServlet.java:313) [3/3/04 12:58:05:286 EST] 4403c89 SystemErr R at com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet.service(StrictLifecycleServlet.java:116) [3/3/04 12:58:05:286 EST] 4403c89 SystemErr R at com.ibm.ws.webcontainer.servlet.ServletInstance.service(ServletInstance.java:283) [3/3/04 12:58:05:286 EST] 4403c89 SystemErr R at com.ibm.ws.webcontainer.servlet.ValidServletReferenceState.dispatch(ValidServletReferenceState.java:42) [3/3/04 12:58:05:286 EST] 4403c89 SystemErr R at com.ibm.ws.webcontainer.servlet.ServletInstanceReference.dispatch(ServletInstanceReference.java:40) [3/3/04 12:58:05:296 EST] 4403c89 SystemErr R at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.handleWebAppDispatch(WebAppRequestDispatcher.java:923) [3/3/04 12:58:05:296 EST] 4403c89 SystemErr R at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.dispatch(WebAppRequestDispatcher.java:528) [3/3/04 12:58:05:296 EST] 4403c89 SystemErr R at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.forward(WebAppRequestDispatcher.java:176) [3/3/04 12:58:05:306 EST] 4403c89 SystemErr R at com.ibm.ws.webcontainer.srt.WebAppInvoker.doForward(WebAppInvoker.java:79) [3/3/04 12:58:05:306 EST] 4403c89 SystemErr R at com.ibm.ws.webcontainer.srt.WebAppInvoker.handleInvocationHook(WebAppInvoker.java:201) [3/3/04 12:58:05:306 EST] 4403c89 SystemErr R at com.ibm.ws.webcontainer.cache.invocation.CachedInvocation.handleInvocation(CachedInvocation.java:71) [3/3/04 12:58:05:306 EST] 4403c89 SystemErr R at com.ibm.ws.webcontainer.srp.ServletRequestProcessor.dispatchByURI(ServletRequestProcessor.java:182) [3/3/04 12:58:05:306 EST] 4403c89 SystemErr R at com.ibm.ws.webcontainer.oselistener.OSEListenerDispatcher.service(OSEListener.java:334) [3/3/04 12:58:05:306 EST] 4403c89 SystemErr R at com.ibm.ws.webcontainer.http.HttpConnection.handleRequest(HttpConnection.java:56) [3/3/04 12:58:05:306 EST] 4403c89 SystemErr R at com.ibm.ws.http.HttpConnection.readAndHandleRequest(HttpConnection.java:516) [3/3/04 12:58:05:306 EST] 4403c89 SystemErr R at com.ibm.ws.http.HttpConnection.run(HttpConnection.java:366) [3/3/04 12:58:05:306 EST] 4403c89 SystemErr R at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:593)
0
