3 Replies Latest reply on Oct 13, 2012 10:16 AM by erasmo2 marciano2

    JBOSS 7 - MS SQL SERVER - Unable to get managed connection

    sabaricse Newbie

      I am getting this error in JBOSS 7. javax.resource.ResourceException: IJ000453: Unable to get managed connection for java:/prodDS0

       

      My Datasource configuration is

       

         <datasource jndi-name="java:/prodDS0" pool-name="prodDS0" enabled="true" use-java-context="true">

                          <connection-url>jdbc:sqlserver://localhost:1433;databaseName=LAPSDB</connection-url>

                          <driver>sqljdbc</driver>

                          <pool>

                              <min-pool-size>40</min-pool-size>

                              <max-pool-size>100</max-pool-size>

                          </pool>

                          <security>

                              <user-name>admin</user-name>

                              <password>1234</password>

                          </security>

                          <timeout>

                              <idle-timeout-minutes>20</idle-timeout-minutes>

                          </timeout>

                          <statement>

                              <track-statements>false</track-statements>

                              <prepared-statement-cache-size>250</prepared-statement-cache-size>

                          </statement>

                      </datasource>

       

       

      Kindly suggest on this issue.

        • 1. Re: JBOSS 7 - MS SQL SERVER - Unable to get managed connection
          erasmo2 marciano2 Master

          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 Newbie

            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
              erasmo2 marciano2 Master

              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