This discussion is archived
3 Replies Latest reply: Jun 27, 2013 10:18 PM by AnveshReddy RSS

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

savitha-oracle Journeyer
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points