3 Replies Latest reply: Jun 28, 2013 12:18 AM by AnveshReddy RSS

    Unable to get database connection!   Root Cause: Unable to get database con

    Savitha-Oracle
      Hello All,

      There is a SR logged for Retail product and while reviewing the issue, few errors logged in server log file.

      Server Log Data:

      2011-07-15 10:55:34,419 ERROR [[ACTIVE] ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)'][dataaccess.DataSourceDbThreadLocalConnectionFactory] getThreadLocalConnection could not look up a connection: jdbc/SimDataSource
      2011-07-15 10:55:34,419 ERROR [[ACTIVE] ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)'][polling-coordinator] throwable caught: oracle.retail.sim.closed.common.SimServerException: Unable to get database connection!
      2011-07-15 10:55:34,419 ERROR [[ACTIVE] ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)'][polling-timers] *problem in handleTimeout()! [EJB Timer]* id: 2 pk: 1 info: oracle.retail.sim.closed.polling.PollingTimerThreadInfoObject@8fc16c2 timer: 1310707534416.4187651(5000) state: 2 ejb: PollingCoordinatorThreadBean(Application: sim-server, EJBComponent: sim-ejb3.jar) Thread: Thread[[ACTIVE] ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)',5,Pooled Threads]
      ERROR-474133 User: PollingCoordinatorThreadBean Time: 7/15/11 10:55 AM Type: SimServerException Message: oracle.retail.sim.closed.common.SimServerException: Unable to get database connection!   Root Cause: Unable to get database connection!
      oracle.retail.sim.closed.common.SimServerException: Unable to get database connection!
           at oracle.retail.sim.closed.dataaccess.BaseOracleDao.getConnection(Unknown Source)
           at oracle.retail.sim.closed.dataaccess.BaseOracleDao.query(Unknown Source)
           at oracle.retail.sim.closed.dataaccess.BaseOracleDao.query(Unknown Source)
           at oracle.retail.sim.shared.dataaccess.dao.PollingTimerOracleDao.selectPollingTimers(Unknown Source)
           at oracle.retail.sim.shared.dataaccess.dao.StagedMessageOracleDao.createWorkQueue(Unknown Source)
           at oracle.retail.sim.closed.polling.StagedMessageServerServices.getWorkQueue(Unknown Source)
           at oracle.retail.sim.closed.polling.PollingTimerWorkManager.refreshWorkQueue(Unknown Source)
           at oracle.retail.sim.closed.ejb.PollingCoordinatorThreadBean.doHandleTimeout(Unknown Source)
           at oracle.retail.sim.closed.ejb.AbstractTimerThreadBean.handleTimeout(Unknown Source)
           at sun.reflect.GeneratedMethodAccessor159.invoke(Unknown Source)
           at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
           at java.lang.reflect.Method.invoke(Method.java:597)
           at com.bea.core.repackaged.springframework.jee.spi.EjbProxyMetadata$TimedObjectImpl.ejbTimeout(EjbProxyMetadata.java:315)
           at sun.reflect.GeneratedMethodAccessor158.invoke(Unknown Source)
           at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
           at java.lang.reflect.Method.invoke(Method.java:597)
           at com.bea.core.repackaged.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:310)
           at com.bea.core.repackaged.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:106)
           at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
           at com.bea.core.repackaged.springframework.jee.spi.MethodInvocationVisitorImpl.visit(MethodInvocationVisitorImpl.java:37)
           at weblogic.ejb.container.injection.EnvironmentInterceptorCallbackImpl.callback(EnvironmentInterceptorCallbackImpl.java:54)
           at com.bea.core.repackaged.springframework.jee.spi.EnvironmentInterceptor.invoke(EnvironmentInterceptor.java:50)
           at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
           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:171)
           at com.bea.core.repackaged.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:131)
           at com.bea.core.repackaged.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:119)
           at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
           at com.bea.core.repackaged.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
           at $Proxy155.ejbTimeout(Unknown Source)
           at weblogic.ejb.container.timer.TimerImpl.timerExpired(TimerImpl.java:301)
           at weblogic.timers.internal.TimerImpl.run(TimerImpl.java:273)
           at weblogic.work.SelfTuningWorkManagerImpl$WorkAdapterImpl.run(SelfTuningWorkManagerImpl.java:528)
           at weblogic.work.ExecuteThread.execute(ExecuteThread.java:201)
           at weblogic.work.ExecuteThread.run(ExecuteThread.java:173)

      Kindly review and let me know is there any configuration changes required to resolve the error reported in the log file.

      Thanks in advance,
      Savitha