Java Database Connectivity (JDBC)

newbie
We are having a nasty problem with connection pools. Weblogic 10.3.x and just upgraded to Oracle 11g
Worked fine with Oracle 10g.
EJB app runs fine for a day or so then can not get a connection. I have included one error or a good snip of it. If it is a common problem please direct me to the thread thank you.

I'm a QA person - the DBA's are doing most of research right but I was wondering if this maybe a weblogic config or application jdbc usage issue.

2011-04-19 00:55:16,501 ERROR ExecuteThread: '14' for queue: 'default' <<EPS-,>> com.rx.ns.util.j2eeDB.J2EEConnectionProvider -
java.sql.SQLException: Pool connect failed : weblogic.common.ResourceException:
Rx.com Data Source(EPS Dev Connection Pool 2): Pool EPS Dev Connection Pool 2 is disabled, cannot allocate resources to applications..

at weblogic.jdbc.common.internal.JDBCUtil.wrapAndThrowResourceException(JDBCUtil.java:257)
at weblogic.jdbc.pool.Driver.connect(Driver.java:160)
at weblogic.jdbc.jts.Driver.getNonTxConnection(Driver.java:642)
at weblogic.jdbc.jts.Driver.connect(Driver.java:124)
at weblogic.jdbc.common.internal.RmiDataSource.getConnection(RmiDataSource.java:338)
at com.rx.ns.util.j2eeDB.J2EEConnectionProvider.getConnection(J2EEConnectionProvider.java:112)
at com.rx.ns.util.j2eeDB.J2EEConnectionProvider.getConnection(J2EEConnectionProvider.java:63)
at com.rx.ns.util.j2eeDB.J2EEConnectionProvider.getResource(J2EEConnectionProvider.java:58)
at com.rx.ns.util.resourceFactory.ResourceFactory.getResource(ResourceFactory.java:190)
at com.rx.ns.dao.PingDAOOracle.ping(PingDAOOracle.java:66)
at com.rx.ns.ejb.FacadeBean.ping(FacadeBean.java:1468)
at sun.reflect.GeneratedMethodAccessor318.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:600)
at com.bea.core.repackaged.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:281)
at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:187)
at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:154)
at com.bea.core.repackaged.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:126)
at com.bea.core.repackaged.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:100)
at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:176)
at com.bea.core.repackaged.springframework.jee.spi.MethodInvocationVisitorImpl.visit(MethodInvocationVisitorImpl.java:15)
at weblogic.ejb.container.injection.EnvironmentInterceptorCallbackImpl.callback(EnvironmentInterceptorCallbackImpl.java:54)
at com.bea.core.repackaged.springframework.jee.spi.EnvironmentInterceptor.invoke(EnvironmentInterceptor.java:30)
at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:176)
at com.bea.core.repackaged.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89)
at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:176)
at com.bea.core.repackaged.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:126)
at com.bea.core.repackaged.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:100)
at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:176)
at com.bea.core.repackaged.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:210)
at $Proxy148.ping(Unknown Source)
at com.rx.ns.ejb.FacadeBean_yc6i5o_FacadeLocalImpl.ping(FacadeBean_yc6i5o_FacadeLocalImpl.java:2543)
at com.rx.ns.delegate.BusinessDelegate.ping(BusinessDelegate.java:1162)
at com.rx.ns.delegate.EPSController.executePing(EPSController.java:45)
at jsp_servlet.__configuration._jspService(__configuration.java:226)
at weblogic.servlet.jsp.JspBase.service(JspBase.java:34)
at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)
at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125)
at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:292)
at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:175)
at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3495)
at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
at weblogic.security.service.SecurityManager.runAs(Unknown Source)
at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2180)
at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2086)
at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1406)
at weblogic.work.ExecuteRequestAdapter.execute(ExecuteRequestAdapter.java:21)
at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:145)
at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:117)
Caused by:
weblogic.common.ResourceException:
Rx.com Data Source(EPS Dev Connection Pool 2): Pool EPS Dev Connection Pool 2 is disabled, cannot allocate resources to applications..

at weblogic.jdbc.common.internal.MultiPool.searchHighAvail(MultiPool.java:484)
at weblogic.jdbc.common.internal.MultiPool.findPool(MultiPool.java:176)
at weblogic.jdbc.common.internal.ConnectionPoolManager.reserve(ConnectionPoolManager.java:87)
at weblogic.jdbc.common.internal.ConnectionPoolManager.reserve(ConnectionPoolManager.java:106)
at weblogic.jdbc.pool.Driver.connect(Driver.java:149)
... 47 more
2011-04-19 00:55:16,502 ERROR ExecuteThread: '14' for queue: 'default' <<EPS-,>> com.rx.ns.dao.PingDAOOracle - Error attempting to ping cpr database
com.rx.ns.util.resourceFactory.ResourceException: Caught SQLException during getConnection
at com.rx.ns.util.j2eeDB.J2EEConnectionProvider.getConnection(J2EEConnectionProvider.java:72)
at com.rx.ns.util.j2eeDB.J2EEConnectionProvider.getResource(J2EEConnectionProvider.java:58)
at com.rx.ns.util.resourceFactory.ResourceFactory.getResource(ResourceFactory.java:190)
at com.rx.ns.dao.PingDAOOracle.ping(PingDAOOracle.java:66)
at com.rx.ns.ejb.FacadeBean.ping(FacadeBean.java:1468)
at sun.reflect.GeneratedMethodAccessor318.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:600)
at com.bea.core.repackaged.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:281)
at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:187)
at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:154)
at com.bea.core.repackaged.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:126)
at com.bea.core.repackaged.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:100)
at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:176)
at com.bea.core.repackaged.springframework.jee.spi.MethodInvocationVisitorImpl.visit(MethodInvocationVisitorImpl.java:15)
at weblogic.ejb.container.injection.EnvironmentInterceptorCallbackImpl.callback(EnvironmentInterceptorCallbackImpl.java:54)
at com.bea.core.repackaged.springframework.jee.spi.EnvironmentInterceptor.invoke(EnvironmentInterceptor.java:30)
at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:176)
at com.bea.core.repackaged.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89)
at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:176)
at com.bea.core.repackaged.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:126)
at com.bea.core.repackaged.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:100)
at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:176)
at com.bea.core.repackaged.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:210)
at $Proxy148.ping(Unknown Source)
at com.rx.ns.ejb.FacadeBean_yc6i5o_FacadeLocalImpl.ping(FacadeBean_yc6i5o_FacadeLocalImpl.java:2543)
at com.rx.ns.delegate.BusinessDelegate.ping(BusinessDelegate.java:1162)
at com.rx.ns.delegate.EPSController.executePing(EPSController.java:45)
at jsp_servlet.__configuration._jspService(__configuration.java:226)
at weblogic.servlet.jsp.JspBase.service(JspBase.java:34)
at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)
at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125)
at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:292)
at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:175)
at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3495)
at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
at weblogic.security.service.SecurityManager.runAs(Unknown Source)
at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2180)
at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2086)
at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1406)
at weblogic.work.ExecuteRequestAdapter.execute(ExecuteRequestAdapter.java:21)
at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:145)
at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:117)
2011-04-19 00:55:16,510 ERROR ExecuteThread: '14' for queue: 'default' <<EPS-,>> com.rx.ns.util.j2eeDB.J2EEConnectionProvider -
java.sql.SQLException: Pool connect failed : weblogic.common.ResourceException:
Rx.com Data Source(EPS Dev Connection Pool 2): Pool EPS Dev Connection Pool 2 is disabled, cannot allocate resources to applications..

at weblogic.jdbc.common.internal.JDBCUtil.wrapAndThrowResourceException(JDBCUtil.java:257)
at weblogic.jdbc.pool.Driver.connect(Driver.java:160)
at weblogic.jdbc.jts.Driver.getNonTxConnection(Driver.java:642)
at weblogic.jdbc.jts.Driver.connect(Driver.java:124)
at weblogic.jdbc.common.internal.RmiDataSource.getConnection(RmiDataSource.java:338)
at com.rx.ns.util.j2eeDB.J2EEConnectionProvider.getConnection(J2EEConnectionProvider.java:112)
at com.rx.ns.util.j2eeDB.J2EEConnectionProvider.getConnection(J2EEConnectionProvider.java:63)
at com.rx.ns.util.j2eeDB.J2EEConnectionProvider.getResource(J2EEConnectionProvider.java:58)
at com.rx.ns.util.resourceFactory.ResourceFactory.getResource(ResourceFactory.java:190)
at com.rx.ns.adapter.util.AuditLogConsoleDAO.getConnection(AuditLogConsoleDAO.java:683)
at com.rx.ns.adapter.util.AuditLogConsoleDAO.loadDisplayableProperties(AuditLogConsoleDAO.java:665)
at jsp_servlet.__configuration._jspService(__configuration.java:247)
at weblogic.servlet.jsp.JspBase.service(JspBase.java:34)
at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)
at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125)
at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:292)
at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:175)
at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3495)
at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
at weblogic.security.service.SecurityManager.runAs(Unknown Source)
at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2180)
at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2086)
at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1406)
at weblogic.work.ExecuteRequestAdapter.execute(ExecuteRequestAdapter.java:21)
at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:145)
at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:117)
Caused by:
weblogic.common.ResourceException:
Rx.com Data Source(EPS Dev Connection Pool 2): Pool EPS Dev Connection Pool 2 is disabled, cannot allocate resources to applications..

at weblogic.jdbc.common.internal.MultiPool.searchHighAvail(MultiPool.java:484)
at weblogic.jdbc.common.internal.MultiPool.findPool(MultiPool.java:176)
at weblogic.jdbc.common.internal.ConnectionPoolManager.reserve(ConnectionPoolManager.java:87)
at weblogic.jdbc.common.internal.ConnectionPoolManager.reserve(ConnectionPoolManager.java:106)
at weblogic.jdbc.pool.Driver.connect(Driver.java:149)
... 24 more
2011-04-19 00:55:16,511 ERROR ExecuteThread: '14' for queue: 'default' <<EPS-,>> com.rx.ns.adapter.util.AuditLogConsoleDAO - Unable to get displayable properties:
java.sql.SQLException: Unable to get connection. Exception: com.rx.ns.util.resourceFactory.ResourceException: Caught SQLException during getConnection
at com.rx.ns.adapter.util.AuditLogConsoleDAO.getConnection(AuditLogConsoleDAO.java:685)
at com.rx.ns.adapter.util.AuditLogConsoleDAO.loadDisplayableProperties(AuditLogConsoleDAO.java:665)
at jsp_servlet.__configuration._jspService(__configuration.java:247)
at weblogic.servlet.jsp.JspBase.service(JspBase.java:34)
at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)
at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125)
at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:292)
at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:175)
at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3495)
at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
at weblogic.security.service.SecurityManager.runAs(Unknown Source)
at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2180)
at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2086)
at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1406)
at weblogic.work.ExecuteRequestAdapter.execute(ExecuteRequestAdapter.java:21)
at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:145)
at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:117)