-
1. Re: JBOSS 7 - MS SQL SERVER - Unable to get managed connection
erasmomarciano Oct 13, 2012 3:28 AM (in response to sabaricse)Hi
Are you sure there is such a databaseName = LAPSDB?
Can you paste more info
-
2. Re: JBOSS 7 - MS SQL SERVER - Unable to get managed connection
sabaricse Oct 13, 2012 7:08 AM (in response to erasmomarciano)Thanks for your reply.
Yes. It is LAPSDB. This error is not coming while doing initial connection. System is working fine for 4 to 5 hrs.This error is coming only when system has the peak load. Is it connection pool configuration issue? Here is complete error info.
SQL Exception in UsersDAOjavax.resource.ResourceException: IJ000453: Unable to get managed connection for java:/prodDS0
14:31:54,680 ERROR [stderr] (http--0.0.0.0-443-59) java.lang.Exception: javax.resource.ResourceException: IJ000453: Unable to get managed connection for java:/prodDS0
14:31:54,680 ERROR [stderr] (http--0.0.0.0-443-59) at com.sai.laps.data.business.UsersDAO.findByPrimaryKey(Unknown Source)
14:31:54,680 ERROR [stderr] (http--0.0.0.0-443-59) at com.sai.laps.business.rules.authentication.AuthenticationBO.findUserFromId(Unknown Source)
14:31:54,680 ERROR [stderr] (http--0.0.0.0-443-59) at com.sai.laps.business.services.authenticate.AuthenticateBean.authenticategetData(AuthenticateBean.java:71)
14:31:54,680 ERROR [stderr] (http--0.0.0.0-443-59) at sun.reflect.GeneratedMethodAccessor96.invoke(Unknown Source)
14:31:54,696 ERROR [stderr] (http--0.0.0.0-443-59) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
14:31:54,696 ERROR [stderr] (http--0.0.0.0-443-59) at java.lang.reflect.Method.invoke(Method.java:597)
14:31:54,696 ERROR [stderr] (http--0.0.0.0-443-59) at org.jboss.as.ee.component.ManagedReferenceMethodInterceptorFactory$ManagedReferenceMethodInterceptor.processInvocation(ManagedReferenceMethodInterceptorFactory.java:72)
14:31:54,696 ERROR [stderr] (http--0.0.0.0-443-59) at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
14:31:54,696 ERROR [stderr] (http--0.0.0.0-443-59) at org.jboss.invocation.WeavedInterceptor.processInvocation(WeavedInterceptor.java:53)
14:31:54,696 ERROR [stderr] (http--0.0.0.0-443-59) at org.jboss.as.ee.component.interceptors.UserInterceptorFactory$1.processInvocation(UserInterceptorFactory.java:36)
14:31:54,696 ERROR [stderr] (http--0.0.0.0-443-59) at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
14:31:54,696 ERROR [stderr] (http--0.0.0.0-443-59) at org.jboss.as.jpa.interceptor.SBInvocationInterceptor.processInvocation(SBInvocationInterceptor.java:47)
14:31:54,696 ERROR [stderr] (http--0.0.0.0-443-59) at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
14:31:54,696 ERROR [stderr] (http--0.0.0.0-443-59) at org.jboss.invocation.InitialInterceptor.processInvocation(InitialInterceptor.java:21)
14:31:54,696 ERROR [stderr] (http--0.0.0.0-443-59) at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
14:31:54,696 ERROR [stderr] (http--0.0.0.0-443-59) at org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61)
14:31:54,696 ERROR [stderr] (http--0.0.0.0-443-59) at org.jboss.as.ee.component.interceptors.ComponentDispatcherInterceptor.processInvocation(ComponentDispatcherInterceptor.java:53)
14:31:54,696 ERROR [stderr] (http--0.0.0.0-443-59) at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
14:31:54,696 ERROR [stderr] (http--0.0.0.0-443-59) at org.jboss.as.ejb3.component.pool.PooledInstanceInterceptor.processInvocation(PooledInstanceInterceptor.java:51)
14:31:54,696 ERROR [stderr] (http--0.0.0.0-443-59) at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
14:31:54,696 ERROR [stderr] (http--0.0.0.0-443-59) at org.jboss.as.ejb3.tx.CMTTxInterceptor.invokeInOurTx(CMTTxInterceptor.java:228)
14:31:54,711 ERROR [stderr] (http--0.0.0.0-443-59) at org.jboss.as.ejb3.tx.CMTTxInterceptor.required(CMTTxInterceptor.java:304)
14:31:54,711 ERROR [stderr] (http--0.0.0.0-443-59) at org.jboss.as.ejb3.tx.CMTTxInterceptor.processInvocation(CMTTxInterceptor.java:190)
14:31:54,711 ERROR [stderr] (http--0.0.0.0-443-59) at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
14:31:54,711 ERROR [stderr] (http--0.0.0.0-443-59) at org.jboss.as.ejb3.remote.EJBRemoteTransactionPropagatingInterceptor.processInvocation(EJBRemoteTransactionPropagatingInterceptor.java:80)
14:31:54,711 ERROR [stderr] (http--0.0.0.0-443-59) at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
14:31:54,711 ERROR [stderr] (http--0.0.0.0-443-59) at org.jboss.as.ejb3.component.interceptors.CurrentInvocationContextInterceptor.processInvocation(CurrentInvocationContextInterceptor.java:41)
14:31:54,711 ERROR [stderr] (http--0.0.0.0-443-59) at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
14:31:54,711 ERROR [stderr] (http--0.0.0.0-443-59) at org.jboss.as.ejb3.component.interceptors.LoggingInterceptor.processInvocation(LoggingInterceptor.java:59)
14:31:54,711 ERROR [stderr] (http--0.0.0.0-443-59) at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
14:31:54,711 ERROR [stderr] (http--0.0.0.0-443-59) at org.jboss.as.ejb3.component.interceptors.EjbExceptionTransformingInterceptorFactories$1.processInvocation(EjbExceptionTransformingInterceptorFactories.java:65)
14:31:54,711 ERROR [stderr] (http--0.0.0.0-443-59) at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
14:31:54,711 ERROR [stderr] (http--0.0.0.0-443-59) at org.jboss.as.ee.component.NamespaceContextInterceptor.processInvocation(NamespaceContextInterceptor.java:50)
14:31:54,711 ERROR [stderr] (http--0.0.0.0-443-59) at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
14:31:54,711 ERROR [stderr] (http--0.0.0.0-443-59) at org.jboss.as.ejb3.component.interceptors.AdditionalSetupInterceptor.processInvocation(AdditionalSetupInterceptor.java:32)
14:31:54,711 ERROR [stderr] (http--0.0.0.0-443-59) at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
14:31:54,711 ERROR [stderr] (http--0.0.0.0-443-59) at org.jboss.as.ee.component.TCCLInterceptor.processInvocation(TCCLInterceptor.java:45)
14:31:54,727 ERROR [stderr] (http--0.0.0.0-443-59) at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
14:31:54,727 ERROR [stderr] (http--0.0.0.0-443-59) at org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61)
14:31:54,727 ERROR [stderr] (http--0.0.0.0-443-59) at org.jboss.as.ee.component.ViewService$View.invoke(ViewService.java:165)
14:31:54,727 ERROR [stderr] (http--0.0.0.0-443-59) at org.jboss.as.ejb3.remote.LocalEjbReceiver.processInvocation(LocalEjbReceiver.java:179)
14:31:54,727 ERROR [stderr] (http--0.0.0.0-443-59) at org.jboss.ejb.client.EJBClientInvocationContext.sendRequest(EJBClientInvocationContext.java:179)
14:31:54,727 ERROR [stderr] (http--0.0.0.0-443-59) at org.jboss.ejb.client.TransactionInterceptor.handleInvocation(TransactionInterceptor.java:43)
14:31:54,727 ERROR [stderr] (http--0.0.0.0-443-59) at org.jboss.ejb.client.EJBClientInvocationContext.sendRequest(EJBClientInvocationContext.java:181)
14:31:54,727 ERROR [stderr] (http--0.0.0.0-443-59) at org.jboss.ejb.client.ReceiverInterceptor.handleInvocation(ReceiverInterceptor.java:128)
14:31:54,727 ERROR [stderr] (http--0.0.0.0-443-59) at org.jboss.ejb.client.EJBClientInvocationContext.sendRequest(EJBClientInvocationContext.java:181)
14:31:54,727 ERROR [stderr] (http--0.0.0.0-443-59) at org.jboss.ejb.client.EJBInvocationHandler.doInvoke(EJBInvocationHandler.java:136)
14:31:54,727 ERROR [stderr] (http--0.0.0.0-443-59) at org.jboss.ejb.client.EJBInvocationHandler.doInvoke(EJBInvocationHandler.java:121)
14:31:54,727 ERROR [stderr] (http--0.0.0.0-443-59) at org.jboss.ejb.client.EJBInvocationHandler.invoke(EJBInvocationHandler.java:104)
14:31:54,727 ERROR [stderr] (http--0.0.0.0-443-59) at $Proxy36.authenticategetData(Unknown Source)
14:31:54,727 ERROR [stderr] (http--0.0.0.0-443-59) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
14:31:54,727 ERROR [stderr] (http--0.0.0.0-443-59) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
14:31:54,727 ERROR [stderr] (http--0.0.0.0-443-59) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
14:31:54,727 ERROR [stderr] (http--0.0.0.0-443-59) at java.lang.reflect.Method.invoke(Method.java:597)
14:31:54,743 ERROR [stderr] (http--0.0.0.0-443-59) at com.sai.fw.business.services.ServiceController.processRemote(ServiceController.java:141)
14:31:54,743 ERROR [stderr] (http--0.0.0.0-443-59) at com.sai.fw.business.services.ServiceController.processRequest(ServiceController.java:57)
14:31:54,743 ERROR [stderr] (http--0.0.0.0-443-59) at com.sai.fw.presentation.controller.FwBaseServlet.invokeBusinessService(FwBaseServlet.java:373)
14:31:54,743 ERROR [stderr] (http--0.0.0.0-443-59) at com.sai.laps.presentation.controller.ControllerServlet.serviceMain(Unknown Source)
14:31:54,743 ERROR [stderr] (http--0.0.0.0-443-59) at com.sai.laps.presentation.controller.ControllerServlet.service(Unknown Source)
14:31:54,743 ERROR [stderr] (http--0.0.0.0-443-59) at javax.servlet.http.HttpServlet.service(HttpServlet.java:847)
14:31:54,743 ERROR [stderr] (http--0.0.0.0-443-59) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:329)
14:31:54,743 ERROR [stderr] (http--0.0.0.0-443-59) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248)
14:31:54,743 ERROR [stderr] (http--0.0.0.0-443-59) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:275)
14:31:54,743 ERROR [stderr] (http--0.0.0.0-443-59) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:161)
14:31:54,743 ERROR [stderr] (http--0.0.0.0-443-59) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:397)
14:31:54,743 ERROR [stderr] (http--0.0.0.0-443-59) at org.jboss.as.web.security.SecurityContextAssociationValve.invoke(SecurityContextAssociationValve.java:153)
14:31:54,743 ERROR [stderr] (http--0.0.0.0-443-59) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:155)
14:31:54,743 ERROR [stderr] (http--0.0.0.0-443-59) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
14:31:54,743 ERROR [stderr] (http--0.0.0.0-443-59) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
14:31:54,743 ERROR [stderr] (http--0.0.0.0-443-59) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:368)
14:31:54,743 ERROR [stderr] (http--0.0.0.0-443-59) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:877)
14:31:54,743 ERROR [stderr] (http--0.0.0.0-443-59) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:671)
14:31:54,758 ERROR [stderr] (http--0.0.0.0-443-59) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:930)
14:31:54,758 ERROR [stderr] (http--0.0.0.0-443-59) at java.lang.Thread.run(Thread.java:662)
-
3. Re: JBOSS 7 - MS SQL SERVER - Unable to get managed connection
erasmomarciano Oct 13, 2012 10:16 AM (in response to sabaricse)mmm
perhaps it is a bug.
check here, similar problem with oracle
https://issues.jboss.org/browse/AS7-3141
Try with update driver for MS SQL SERVER