4 Replies Latest reply on Jul 29, 2016 6:28 AM by Satheesh Duvvuru

    [ERROR Connection] ava.sql.SQLException: Connection is not associated with a managed connection.org.jboss.jca.adapters.jdbc.jdk6.WrappedConnectionJDK6

    Jonas Cavalcanti Newbie

      Hi people,

       

      I have this problem when get my pool connection of the JBoss EAP 6. My Pool already configure with parameters Min: 5 and Max:20  but error continue. Has anyone experienced this problem?

       

       

      17:00:15,201 ERROR [stderr] (http-/0.0.0.0:8080-2) Connection is not associated with a managed connection.org.jboss.jca.adapters.jdbc.jdk6.WrappedConnectionJDK6@1ab52d8

       

      17:00:15,201 ERROR [stderr] (http-/0.0.0.0:8080-2) java.sql.SQLException: Connection is not associated with a managed connection.org.jboss.jca.adapters.jdbc.jdk6.WrappedConnectionJDK6@1ab52d8

       

      17:00:15,202 ERROR [stderr] (http-/0.0.0.0:8080-2) at org.jboss.jca.adapters.jdbc.WrappedConnection.lock(WrappedConnection.java:155)

       

      17:00:15,207 ERROR [stderr] (http-/0.0.0.0:8080-2) at org.jboss.jca.adapters.jdbc.WrappedStatement.lock(WrappedStatement.java:114)

       

      17:00:15,209 ERROR [stderr] (http-/0.0.0.0:8080-2) at org.jboss.jca.adapters.jdbc.WrappedPreparedStatement.setString(WrappedPreparedStatement.java:626)

       

      17:00:15,209 ERROR [stderr] (http-/0.0.0.0:8080-2) at br.gov.jfce.cpad.DocumentosProcessos.salvarCaminhoRaiz(DocumentosProcessos.java:2067)

       

      17:00:15,210 ERROR [stderr] (http-/0.0.0.0:8080-2) at br.gov.jfce.cpad.DocumentosProcessos.unificarDocumentosProcessoPDF(DocumentosProcessos.java:545)

       

      17:00:15,211 ERROR [stderr] (http-/0.0.0.0:8080-2) at org.apache.jsp.ajax.ajaxProtocoloDocumentosVirtuais_jsp._jspService(ajaxProtocoloDocumentosVirtuais_jsp.java:4932)

       

      17:00:15,212 ERROR [stderr] (http-/0.0.0.0:8080-2) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:69)

       

      17:00:15,212 ERROR [stderr] (http-/0.0.0.0:8080-2) at javax.servlet.http.HttpServlet.service(HttpServlet.java:847)

       

      17:00:15,213 ERROR [stderr] (http-/0.0.0.0:8080-2) at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:365)

       

      17:00:15,213 ERROR [stderr] (http-/0.0.0.0:8080-2) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:309)

       

      17:00:15,213 ERROR [stderr] (http-/0.0.0.0:8080-2) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:242)

       

      17:00:15,214 ERROR [stderr] (http-/0.0.0.0:8080-2) at javax.servlet.http.HttpServlet.service(HttpServlet.java:847)

       

      17:00:15,214 ERROR [stderr] (http-/0.0.0.0:8080-2) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:295)

       

      17:00:15,214 ERROR [stderr] (http-/0.0.0.0:8080-2) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:214)

       

      17:00:15,215 ERROR [stderr] (http-/0.0.0.0:8080-2) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:230)

       

      17:00:15,215 ERROR [stderr] (http-/0.0.0.0:8080-2) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:149)

       

      17:00:15,215 ERROR [stderr] (http-/0.0.0.0:8080-2) at org.jboss.as.web.security.SecurityContextAssociationValve.invoke(SecurityContextAssociationValve.java:169)

       

      17:00:15,216 ERROR [stderr] (http-/0.0.0.0:8080-2) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:145)

       

      17:00:15,216 ERROR [stderr] (http-/0.0.0.0:8080-2) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:97)

       

      17:00:15,216 ERROR [stderr] (http-/0.0.0.0:8080-2) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:102)

       

      17:00:15,217 ERROR [stderr] (http-/0.0.0.0:8080-2) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:336)

       

      17:00:15,217 ERROR [stderr] (http-/0.0.0.0:8080-2) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:856)

       

      17:00:15,218 ERROR [stderr] (http-/0.0.0.0:8080-2) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:653)

       

      17:00:15,218 ERROR [stderr] (http-/0.0.0.0:8080-2) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:920)

       

      17:00:15,218 ERROR [stderr] (http-/0.0.0.0:8080-2) at java.lang.Thread.run(Thread.java:662)

        • 1. Re: [ERROR Connection] ava.sql.SQLException: Connection is not associated with a managed connection.org.jboss.jca.adapters.jdbc.jdk6.WrappedConnectionJDK6
          Panagiotis Chavariotis Novice

          Please be sure that you are not caching any Connection, Statement or ResultSet objects.

          The application must get these resources as needed and rely on the JBoss connection pool to optimize re-use.

          • 2. Re: [ERROR Connection] ava.sql.SQLException: Connection is not associated with a managed connection.org.jboss.jca.adapters.jdbc.jdk6.WrappedConnectionJDK6
            Satheesh Duvvuru Newbie

            I am also facing the same issue. Please help me. What is exact root cause of this issue ?:

             

            Environment :-

            JBoss EAP: 6.2

             

            Exception message: java.sql.SQLException: Connection is not associated with a managed connection.org.jboss.jca.adapters.jdbc.jdk6.WrappedConnectionJDK6@1fb82260

            Exception stack trace:

              org.jboss.jca.adapters.jdbc.WrappedConnection.lock(WrappedConnection.java:155)

              org.jboss.jca.adapters.jdbc.WrappedStatement.lock(WrappedStatement.java:114)

              org.jboss.jca.adapters.jdbc.WrappedStatement.execute(WrappedStatement.java:146)

              com.unisys.trans.aircore.bkg.persist.directjdbc.PermTripExtensionFactory.insertExpiredTripExtension(PermTripExtensionFactory.java:655)

              com.unisys.trans.aircore.bkg.bookingservice.persist.PermTripExtensionBroker.insertExpiredTripExtension(PermTripExtensionBroker.java:105)

              com.unisys.trans.aircore.bkg.bookingservice.PermBooking.persistTripDetails(PermBooking.java:7365)

              com.unisys.trans.aircore.bkg.bookingservice.PermBooking.insertNewExpiredTrip(PermBooking.java:1028)

              com.unisys.trans.aircore.bkg.bookingservice.BookingService.releaseExpiredBooking(BookingService.java:2365)

              com.unisys.trans.aircore.bkg.bkgscan.service.BKGScanService.processReleaseBooking(BKGScanService.java:1848)

              com.unisys.trans.aircore.bkg.bkgscan.service.BKGScanService.processBookingForScan(BKGScanService.java:327)

              com.unisys.trans.aircore.bkg.bkgscan.bkgscanserviceejb.ScanServiceEJB.processBookingForScan(ScanServiceEJB.java:159)

              sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

              sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)

              sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

              java.lang.reflect.Method.invoke(Method.java:606)

              org.jboss.as.ee.component.ManagedReferenceMethodInterceptorFactory$ManagedReferenceMethodInterceptor.processInvocation(ManagedReferenceMethodInterceptorFactory.java:72)

              org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)

              org.jboss.invocation.WeavedInterceptor.processInvocation(WeavedInterceptor.java:53)

              org.jboss.as.ee.component.interceptors.UserInterceptorFactory$1.processInvocation(UserInterceptorFactory.java:58)

              org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)

              org.jboss.invocation.WeavedInterceptor.processInvocation(WeavedInterceptor.java:53)

              org.jboss.as.ee.component.interceptors.UserInterceptorFactory$1.processInvocation(UserInterceptorFactory.java:58)

              org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)

              org.jboss.as.ejb3.component.invocationmetrics.ExecutionTimeInterceptor.processInvocation(ExecutionTimeInterceptor.java:43)

              org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)

              org.jboss.as.jpa.interceptor.SBInvocationInterceptor.processInvocation(SBInvocationInterceptor.java:47)

              org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)

              org.jboss.invocation.InitialInterceptor.processInvocation(InitialInterceptor.java:21)

              org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)

              org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61)

              org.jboss.as.ee.component.interceptors.ComponentDispatcherInterceptor.processInvocation(ComponentDispatcherInterceptor.java:53)

              org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)

              org.jboss.as.ejb3.component.pool.PooledInstanceInterceptor.processInvocation(PooledInstanceInterceptor.java:51)

              org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)

              org.jboss.as.ejb3.tx.CMTTxInterceptor.invokeInOurTx(CMTTxInterceptor.java:272)

              org.jboss.as.ejb3.tx.CMTTxInterceptor.required(CMTTxInterceptor.java:339)

              org.jboss.as.ejb3.tx.CMTTxInterceptor.processInvocation(CMTTxInterceptor.java:238)

              org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)

              org.jboss.as.ejb3.remote.EJBRemoteTransactionPropagatingInterceptor.processInvocation(EJBRemoteTransactionPropagatingInterceptor.java:79)

              org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)

              org.jboss.as.ejb3.component.interceptors.CurrentInvocationContextInterceptor.processInvocation(CurrentInvocationContextInterceptor.java:41)

              org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)

              org.jboss.as.ejb3.security.AuthorizationInterceptor.processInvocation(AuthorizationInterceptor.java:122)

              org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)

              org.jboss.as.ejb3.security.SecurityContextInterceptor.processInvocation(SecurityContextInterceptor.java:81)

              org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)

              org.jboss.as.ejb3.component.interceptors.ShutDownInterceptorFactory$1.processInvocation(ShutDownInterceptorFactory.java:64)

              org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)

              org.jboss.as.ejb3.component.interceptors.LoggingInterceptor.processInvocation(LoggingInterceptor.java:59)

              org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)

              org.jboss.as.ee.component.NamespaceContextInterceptor.processInvocation(NamespaceContextInterceptor.java:50)

              org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)

              org.jboss.as.ee.component.TCCLInterceptor.processInvocation(TCCLInterceptor.java:45)

              org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)

              org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61)

              org.jboss.as.ee.component.ViewService$View.invoke(ViewService.java:165)

              org.jboss.as.ejb3.remote.LocalEjbReceiver.processInvocation(LocalEjbReceiver.java:249)

              org.jboss.ejb.client.EJBClientInvocationContext.sendRequest(EJBClientInvocationContext.java:181)

              org.jboss.ejb.client.EJBObjectInterceptor.handleInvocation(EJBObjectInterceptor.java:58)

              org.jboss.ejb.client.EJBClientInvocationContext.sendRequest(EJBClientInvocationContext.java:183)

              org.jboss.ejb.client.EJBHomeInterceptor.handleInvocation(EJBHomeInterceptor.java:83)

              org.jboss.ejb.client.EJBClientInvocationContext.sendRequest(EJBClientInvocationContext.java:183)

              org.jboss.ejb.client.TransactionInterceptor.handleInvocation(TransactionInterceptor.java:42)

              org.jboss.ejb.client.EJBClientInvocationContext.sendRequest(EJBClientInvocationContext.java:183)

              org.jboss.ejb.client.ReceiverInterceptor.handleInvocation(ReceiverInterceptor.java:125)

              org.jboss.ejb.client.EJBClientInvocationContext.sendRequest(EJBClientInvocationContext.java:183)

              org.jboss.ejb.client.EJBInvocationHandler.sendRequestWithPossibleRetries(EJBInvocationHandler.java:253)

              org.jboss.ejb.client.EJBInvocationHandler.doInvoke(EJBInvocationHandler.java:198)

              org.jboss.ejb.client.EJBInvocationHandler.doInvoke(EJBInvocationHandler.java:181)

              org.jboss.ejb.client.EJBInvocationHandler.invoke(EJBInvocationHandler.java:144)

              com.sun.proxy.$Proxy102.processBookingForScan(Unknown Source)

              com.unisys.trans.aircore.bkg.bkgscan.service.BkgJobProcessor.processWorkUnit(BkgJobProcessor.java:128)

              com.unisys.trans.shared.batchframework.batchjobprocessor.BatchJobProcessor.processWorkPacket(BatchJobProcessor.java:142)

              com.unisys.trans.aircore.bkg.bkgscan.service.BkgJobProcessor.processWorkPacket(BkgJobProcessor.java:69)

              com.unisys.trans.aircore.bkg.bkgscan.batchframeworkservice.bkgscanbatchjobprocessormdb.BkgWorkMDB.processMessage(BkgWorkMDB.java:81)

              com.unisys.trans.shared.util.ejb3.AbstractJMSBean.onMessage(AbstractJMSBean.java:116)

              sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

              sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)

              sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

              java.lang.reflect.Method.invoke(Method.java:606)

              org.jboss.as.ee.component.ManagedReferenceMethodInterceptorFactory$ManagedReferenceMethodInterceptor.processInvocation(ManagedReferenceMethodInterceptorFactory.java:72)

              org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)

              org.jboss.invocation.WeavedInterceptor.processInvocation(WeavedInterceptor.java:53)

              org.jboss.as.ee.component.interceptors.UserInterceptorFactory$1.processInvocation(UserInterceptorFactory.java:58)

              org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)

              org.jboss.invocation.WeavedInterceptor.processInvocation(WeavedInterceptor.java:53)

              org.jboss.as.ee.component.interceptors.UserInterceptorFactory$1.processInvocation(UserInterceptorFactory.java:58)

              org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)

              org.jboss.as.ejb3.component.invocationmetrics.ExecutionTimeInterceptor.processInvocation(ExecutionTimeInterceptor.java:43)

              org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)

              org.jboss.invocation.InitialInterceptor.processInvocation(InitialInterceptor.java:21)

              org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)

              org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61)

              org.jboss.as.ee.component.interceptors.ComponentDispatcherInterceptor.processInvocation(ComponentDispatcherInterceptor.java:53)

              org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)

              org.jboss.as.ejb3.component.pool.PooledInstanceInterceptor.processInvocation(PooledInstanceInterceptor.java:51)

              org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)

              org.jboss.as.ejb3.tx.CMTTxInterceptor.invokeInNoTx(CMTTxInterceptor.java:259)

              org.jboss.as.ejb3.tx.CMTTxInterceptor.notSupported(CMTTxInterceptor.java:323)

              org.jboss.as.ejb3.tx.CMTTxInterceptor.processInvocation(CMTTxInterceptor.java:236)

              org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)

              org.jboss.as.ejb3.component.interceptors.CurrentInvocationContextInterceptor.processInvocation(CurrentInvocationContextInterceptor.java:41)

              org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)

              org.jboss.as.ejb3.security.SecurityContextInterceptor.processInvocation(SecurityContextInterceptor.java:81)

              org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)

              org.jboss.as.ejb3.component.interceptors.ShutDownInterceptorFactory$1.processInvocation(ShutDownInterceptorFactory.java:64)

              org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)

              org.jboss.as.ejb3.component.interceptors.LoggingInterceptor.processInvocation(LoggingInterceptor.java:59)

              org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)

              org.jboss.as.ee.component.NamespaceContextInterceptor.processInvocation(NamespaceContextInterceptor.java:50)

              org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)

              org.jboss.as.ejb3.component.messagedriven.MessageDrivenComponentDescription$5$1.processInvocation(MessageDrivenComponentDescription.java:203)

              org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)

              org.jboss.as.ee.component.TCCLInterceptor.processInvocation(TCCLInterceptor.java:45)

              org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)

              org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61)

              org.jboss.as.ee.component.ViewService$View.invoke(ViewService.java:165)

              org.jboss.as.ee.component.ViewDescription$1.processInvocation(ViewDescription.java:182)

              org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)

              org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61)

              org.jboss.as.ee.component.ProxyInvocationHandler.invoke(ProxyInvocationHandler.java:72)

              javax.jms.MessageListener$$$view307.onMessage(Unknown Source)

              sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

              sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)

              sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

              java.lang.reflect.Method.invoke(Method.java:606)

              org.jboss.as.ejb3.inflow.MessageEndpointInvocationHandler.doInvoke(MessageEndpointInvocationHandler.java:140)

              org.jboss.as.ejb3.inflow.AbstractInvocationHandler.invoke(AbstractInvocationHandler.java:73)

              com.sun.proxy.$Proxy104.onMessage(Unknown Source)

              com.ibm.mq.connector.inbound.MessageEndpointWrapper.onMessage(MessageEndpointWrapper.java:136)

              com.ibm.mq.jms.MQSession$FacadeMessageListener.onMessage(MQSession.java:138)

              com.ibm.msg.client.jms.internal.JmsSessionImpl.run(JmsSessionImpl.java:2677)

              com.ibm.mq.jms.MQSession.run(MQSession.java:963)

              com.ibm.mq.connector.inbound.ASFWorkImpl.doDelivery(ASFWorkImpl.java:102)

              com.ibm.mq.connector.inbound.AbstractWorkImpl.run(AbstractWorkImpl.java:236)

              org.jboss.jca.core.workmanager.WorkWrapper.run(WorkWrapper.java:218)

              org.jboss.threads.SimpleDirectExecutor.execute(SimpleDirectExecutor.java:33)

              org.jboss.threads.QueueExecutor.runTask(QueueExecutor.java:808)

              org.jboss.threads.QueueExecutor.access$100(QueueExecutor.java:45)

              org.jboss.threads.QueueExecutor$Worker.run(QueueExecutor.java:828)

              java.lang.Thread.run(Thread.java:745)

              org.jboss.threads.JBossThread.run(JBossThread.java:122)

            <<

            >>

            Event: ERROR anonymous 2016-07-21 15:47:47.083 (IN-DUVVURUS-1/129.221.229.112#2727)

            Thread: default-threads - 8

            Text: LOG_ID_3290 from com.unisys.trans.aircore.bkg.bkgscan.service.BKGScanService.processBookingForScan(BKGScanService.java:444)

            Status: Fatal Write

            Reason code: 10018

            Reason code application: 10

            Reason code message: BKG10018: The SQL statement failed: (A0C8VG) SQL error: {1}

            Debug message: BKGScanService.processBookingForScan(): processBookingForScan failed

            Reason code subtext: A0C8VG

            Exception message: com.unisys.trans.shared.util.response.SharedException: ReasonCode[67118882] ApplicationID[10] Message:BKG10018: The SQL statement failed: (TRIPEXTENSION) SQL error: INSERT INTO TRIPEXTENSION (TRIPEXTENSIONID,TRIPID,BOOKINGOWNER,STATUS,GROUPNAME,NUMBEROFSEATS,OWNERTRIPID,NOMATCHTRIPID,DIVIDEFROMTRIPID,DIVIDETOTRIPID,UPDATEOFFICE,UPDATENAME,AIRLINEOWNER,RESPONSIBILITYOFFICE,RESPONSIBILITYCITY,RESPONSIBILITYDETAILS,POINTOFSALE,UPDATESOURCE,CREATEPERIOD,UPDATEPERIOD,EOTTIME,FIRMBOOKING,FIRMDATE,BKGTRIPTYPE,LINKEDTRIPS,GROUPID,BOOKINGELEMENTS,CORPORATENAME,CORPORATENUMBER,ISNTBASENT,REVERSETIMELIMIT,AWARDBOOKINGINDICATOR,TRAVELBOOKINGINDICATOR,SHAREDRESPONSIBILITYOFFICE,SHAREDRESPONSIBILITYDETAILS) VALUES ( 440869, A0C8VG , SystemAgent ,3,  ,6,  ,  ,  ,  ,  , SystemAgent , NW , MSPNW0100 ,  ,  ,  , 4,2,999,1459411547577,0,    ,0,   ,   ,  00111000000010000 ,   ,   , 0,0,0,0,   ,   )

            Exception stack trace:

              com.unisys.trans.aircore.bkg.bkgscan.service.BKGScanService.processReleaseBooking(BKGScanService.java:1853)

              com.unisys.trans.aircore.bkg.bkgscan.service.BKGScanService.processBookingForScan(BKGScanService.java:327)

              com.unisys.trans.aircore.bkg.bkgscan.bkgscanserviceejb.ScanServiceEJB.processBookingForScan(ScanServiceEJB.java:159)

              sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

              sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)

              sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

              java.lang.reflect.Method.invoke(Method.java:606)

              org.jboss.as.ee.component.ManagedReferenceMethodInterceptorFactory$ManagedReferenceMethodInterceptor.processInvocation(ManagedReferenceMethodInterceptorFactory.java:72)

              org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)

              org.jboss.invocation.WeavedInterceptor.processInvocation(WeavedInterceptor.java:53)

              org.jboss.as.ee.component.interceptors.UserInterceptorFactory$1.processInvocation(UserInterceptorFactory.java:58)

              org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)

              org.jboss.invocation.WeavedInterceptor.processInvocation(WeavedInterceptor.java:53)

              org.jboss.as.ee.component.interceptors.UserInterceptorFactory$1.processInvocation(UserInterceptorFactory.java:58)

              org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)

              org.jboss.as.ejb3.component.invocationmetrics.ExecutionTimeInterceptor.processInvocation(ExecutionTimeInterceptor.java:43)

              org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)

              org.jboss.as.jpa.interceptor.SBInvocationInterceptor.processInvocation(SBInvocationInterceptor.java:47)

              org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)

              org.jboss.invocation.InitialInterceptor.processInvocation(InitialInterceptor.java:21)

              org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)

              org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61)

              org.jboss.as.ee.component.interceptors.ComponentDispatcherInterceptor.processInvocation(ComponentDispatcherInterceptor.java:53)

              org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)

              org.jboss.as.ejb3.component.pool.PooledInstanceInterceptor.processInvocation(PooledInstanceInterceptor.java:51)

              org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)

              org.jboss.as.ejb3.tx.CMTTxInterceptor.invokeInOurTx(CMTTxInterceptor.java:272)

              org.jboss.as.ejb3.tx.CMTTxInterceptor.required(CMTTxInterceptor.java:339)

              org.jboss.as.ejb3.tx.CMTTxInterceptor.processInvocation(CMTTxInterceptor.java:238)

              org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)

              org.jboss.as.ejb3.remote.EJBRemoteTransactionPropagatingInterceptor.processInvocation(EJBRemoteTransactionPropagatingInterceptor.java:79)

              org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)

              org.jboss.as.ejb3.component.interceptors.CurrentInvocationContextInterceptor.processInvocation(CurrentInvocationContextInterceptor.java:41)

              org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)

              org.jboss.as.ejb3.security.AuthorizationInterceptor.processInvocation(AuthorizationInterceptor.java:122)

              org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)

              org.jboss.as.ejb3.security.SecurityContextInterceptor.processInvocation(SecurityContextInterceptor.java:81)

              org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)

              org.jboss.as.ejb3.component.interceptors.ShutDownInterceptorFactory$1.processInvocation(ShutDownInterceptorFactory.java:64)

              org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)

              org.jboss.as.ejb3.component.interceptors.LoggingInterceptor.processInvocation(LoggingInterceptor.java:59)

              org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)

              org.jboss.as.ee.component.NamespaceContextInterceptor.processInvocation(NamespaceContextInterceptor.java:50)

              org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)

              org.jboss.as.ee.component.TCCLInterceptor.processInvocation(TCCLInterceptor.java:45)

              org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)

              org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61)

              org.jboss.as.ee.component.ViewService$View.invoke(ViewService.java:165)

              org.jboss.as.ejb3.remote.LocalEjbReceiver.processInvocation(LocalEjbReceiver.java:249)

              org.jboss.ejb.client.EJBClientInvocationContext.sendRequest(EJBClientInvocationContext.java:181)

              org.jboss.ejb.client.EJBObjectInterceptor.handleInvocation(EJBObjectInterceptor.java:58)

              org.jboss.ejb.client.EJBClientInvocationContext.sendRequest(EJBClientInvocationContext.java:183)

              org.jboss.ejb.client.EJBHomeInterceptor.handleInvocation(EJBHomeInterceptor.java:83)

              org.jboss.ejb.client.EJBClientInvocationContext.sendRequest(EJBClientInvocationContext.java:183)

              org.jboss.ejb.client.TransactionInterceptor.handleInvocation(TransactionInterceptor.java:42)

              org.jboss.ejb.client.EJBClientInvocationContext.sendRequest(EJBClientInvocationContext.java:183)

              org.jboss.ejb.client.ReceiverInterceptor.handleInvocation(ReceiverInterceptor.java:125)

              org.jboss.ejb.client.EJBClientInvocationContext.sendRequest(EJBClientInvocationContext.java:183)

              org.jboss.ejb.client.EJBInvocationHandler.sendRequestWithPossibleRetries(EJBInvocationHandler.java:253)

              org.jboss.ejb.client.EJBInvocationHandler.doInvoke(EJBInvocationHandler.java:198)

              org.jboss.ejb.client.EJBInvocationHandler.doInvoke(EJBInvocationHandler.java:181)

              org.jboss.ejb.client.EJBInvocationHandler.invoke(EJBInvocationHandler.java:144)

              com.sun.proxy.$Proxy102.processBookingForScan(Unknown Source)

              com.unisys.trans.aircore.bkg.bkgscan.service.BkgJobProcessor.processWorkUnit(BkgJobProcessor.java:128)

              com.unisys.trans.shared.batchframework.batchjobprocessor.BatchJobProcessor.processWorkPacket(BatchJobProcessor.java:142)

              com.unisys.trans.aircore.bkg.bkgscan.service.BkgJobProcessor.processWorkPacket(BkgJobProcessor.java:69)

              com.unisys.trans.aircore.bkg.bkgscan.batchframeworkservice.bkgscanbatchjobprocessormdb.BkgWorkMDB.processMessage(BkgWorkMDB.java:81)

              com.unisys.trans.shared.util.ejb3.AbstractJMSBean.onMessage(AbstractJMSBean.java:116)

              sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

              sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)

              sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

              java.lang.reflect.Method.invoke(Method.java:606)

              org.jboss.as.ee.component.ManagedReferenceMethodInterceptorFactory$ManagedReferenceMethodInterceptor.processInvocation(ManagedReferenceMethodInterceptorFactory.java:72)

              org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)

              org.jboss.invocation.WeavedInterceptor.processInvocation(WeavedInterceptor.java:53)

              org.jboss.as.ee.component.interceptors.UserInterceptorFactory$1.processInvocation(UserInterceptorFactory.java:58)

              org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)

              org.jboss.invocation.WeavedInterceptor.processInvocation(WeavedInterceptor.java:53)

              org.jboss.as.ee.component.interceptors.UserInterceptorFactory$1.processInvocation(UserInterceptorFactory.java:58)

              org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)

              org.jboss.as.ejb3.component.invocationmetrics.ExecutionTimeInterceptor.processInvocation(ExecutionTimeInterceptor.java:43)

              org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)

              org.jboss.invocation.InitialInterceptor.processInvocation(InitialInterceptor.java:21)

              org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)

              org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61)

              org.jboss.as.ee.component.interceptors.ComponentDispatcherInterceptor.processInvocation(ComponentDispatcherInterceptor.java:53)

              org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)

              org.jboss.as.ejb3.component.pool.PooledInstanceInterceptor.processInvocation(PooledInstanceInterceptor.java:51)

              org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)

              org.jboss.as.ejb3.tx.CMTTxInterceptor.invokeInNoTx(CMTTxInterceptor.java:259)

              org.jboss.as.ejb3.tx.CMTTxInterceptor.notSupported(CMTTxInterceptor.java:323)

              org.jboss.as.ejb3.tx.CMTTxInterceptor.processInvocation(CMTTxInterceptor.java:236)

              org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)

              org.jboss.as.ejb3.component.interceptors.CurrentInvocationContextInterceptor.processInvocation(CurrentInvocationContextInterceptor.java:41)

              org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)

              org.jboss.as.ejb3.security.SecurityContextInterceptor.processInvocation(SecurityContextInterceptor.java:81)

              org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)

              org.jboss.as.ejb3.component.interceptors.ShutDownInterceptorFactory$1.processInvocation(ShutDownInterceptorFactory.java:64)

              org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)

              org.jboss.as.ejb3.component.interceptors.LoggingInterceptor.processInvocation(LoggingInterceptor.java:59)

              org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)

              org.jboss.as.ee.component.NamespaceContextInterceptor.processInvocation(NamespaceContextInterceptor.java:50)

              org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)

              org.jboss.as.ejb3.component.messagedriven.MessageDrivenComponentDescription$5$1.processInvocation(MessageDrivenComponentDescription.java:203)

              org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)

              org.jboss.as.ee.component.TCCLInterceptor.processInvocation(TCCLInterceptor.java:45)

              org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)

              org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61)

              org.jboss.as.ee.component.ViewService$View.invoke(ViewService.java:165)

              org.jboss.as.ee.component.ViewDescription$1.processInvocation(ViewDescription.java:182)

              org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)

              org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61)

              org.jboss.as.ee.component.ProxyInvocationHandler.invoke(ProxyInvocationHandler.java:72)

              javax.jms.MessageListener$$$view307.onMessage(Unknown Source)

              sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

              sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)

              sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

              java.lang.reflect.Method.invoke(Method.java:606)

              org.jboss.as.ejb3.inflow.MessageEndpointInvocationHandler.doInvoke(MessageEndpointInvocationHandler.java:140)

              org.jboss.as.ejb3.inflow.AbstractInvocationHandler.invoke(AbstractInvocationHandler.java:73)

              com.sun.proxy.$Proxy104.onMessage(Unknown Source)

              com.ibm.mq.connector.inbound.MessageEndpointWrapper.onMessage(MessageEndpointWrapper.java:136)

              com.ibm.mq.jms.MQSession$FacadeMessageListener.onMessage(MQSession.java:138)

              com.ibm.msg.client.jms.internal.JmsSessionImpl.run(JmsSessionImpl.java:2677)

              com.ibm.mq.jms.MQSession.run(MQSession.java:963)

              com.ibm.mq.connector.inbound.ASFWorkImpl.doDelivery(ASFWorkImpl.java:102)

              com.ibm.mq.connector.inbound.AbstractWorkImpl.run(AbstractWorkImpl.java:236)

              org.jboss.jca.core.workmanager.WorkWrapper.run(WorkWrapper.java:218)

              org.jboss.threads.SimpleDirectExecutor.execute(SimpleDirectExecutor.java:33)

              org.jboss.threads.QueueExecutor.runTask(QueueExecutor.java:808)

              org.jboss.threads.QueueExecutor.access$100(QueueExecutor.java:45)

              org.jboss.threads.QueueExecutor$Worker.run(QueueExecutor.java:828)

              java.lang.Thread.run(Thread.java:745)

              org.jboss.threads.JBossThread.run(JBossThread.java:122)

            • 3. Re: [ERROR Connection] ava.sql.SQLException: Connection is not associated with a managed connection.org.jboss.jca.adapters.jdbc.jdk6.WrappedConnectionJDK6
              Abhijit Humbe Master

              The connection pool will keep a bunch of database connections to the database engine (MySQL, Oracle, SQL Server... depends how to configure it) in SLEEPING state.When application ask for the connection pool to retrieve one of these connections available.The connection pool will give a database connection (if available) and it is ready to use.Then it should be used as per needed and need to closed. Make sure you are closing connection in your application code like as:

              ~~~

              try {

                       ......

                       ......

                  } finally {

                       try { resultSet.close(); } catch(Exception e) {}

                       try { statement.close(); } catch(Exception e) {}

                       try { connection.close(); } catch(Exception e) {}

                  }

              ~~~

              Also its suggested to configure connection validation in datasource configuration like as:

              ~~~

              <valid-connection-checker-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleValidConnectionChecker</valid-connection-checker-class-name>

              <background-validation>true</background-validation>

              <validate-on-match>false</validate-on-match>

              <background-validation-millis>30000</background-validation-millis>

              ~~~

               

              hope it helps..

              • 4. Re: [ERROR Connection] ava.sql.SQLException: Connection is not associated with a managed connection.org.jboss.jca.adapters.jdbc.jdk6.WrappedConnectionJDK6
                Satheesh Duvvuru Newbie

                Hi Abjith, Thank you very much for your response.

                 

                I have added the datasouce configuration i which you have suggested, but I am getting the below exception while starting the server.

                 

                 

                 

                  JAVA_OPTS: "-XX:+UseCompressedOops -Dprogram.name=standalone.bat -Xms2048m -Xmx2048m -XX:MaxPermSize=512M -Djava.net.preferIPv4Stack=true -Djboss.modules.system.pkgs=org.j

                 

                =transport=dt_socket,address=8787,server=y,suspend=n -DMQHost=localhost -DMQPort=1414 -DMQName=WL -Djava.util.logging.manager=java.util.logging.LogManager -Dlogging.configur

                dalone/aircore/properties/logging.properties -Dorg.jboss.logging.Logger.pluginClass=org.jboss.logging.jdk.JDK14LoggerPlugin -Djava.util.logging.config.file=D:/jboss-eap-6.2/

                es/logging.properties -DcontrolFileDirectory=FILE:D:/jboss-eap-6.2/standalone/aircore/properties -DpropertyFileDirectory=FILE:D:/jboss-eap-6.2/standalone/aircore/properties"

                ===============================================================================

                Listening for transport dt_socket at address: 8787

                17:01:15,971 INFO  [org.jboss.modules] (main) JBoss Modules version 1.3.0.Final-redhat-2

                17:01:16,250 INFO  [org.jboss.msc] (main) JBoss MSC version 1.0.4.GA-redhat-1

                17:01:16,373 INFO  [org.jboss.as] (MSC service thread 1-8) JBAS015899: JBoss EAP 6.2.0.GA (AS 7.3.0.Final-redhat-14) starting

                17:01:17,096 ERROR [org.jboss.as.server] (Controller Boot Thread) JBAS015956: Caught exception during boot: org.jboss.as.controller.persistence.ConfigurationPersistenceExcep

                parse configuration

                        at org.jboss.as.controller.persistence.XmlConfigurationPersister.load(XmlConfigurationPersister.java:141) [jboss-as-controller-7.3.0.Final-redhat-14.jar:7.3.0.Final-

                        at org.jboss.as.server.ServerService.boot(ServerService.java:324) [jboss-as-server-7.3.0.Final-redhat-14.jar:7.3.0.Final-redhat-14]

                        at org.jboss.as.controller.AbstractControllerService$1.run(AbstractControllerService.java:253) [jboss-as-controller-7.3.0.Final-redhat-14.jar:7.3.0.Final-redhat-14]

                        at java.lang.Thread.run(Thread.java:745) [rt.jar:1.7.0_79]

                Caused by: javax.xml.stream.XMLStreamException: org.jboss.as.connector.util.ParserException: IJ010061: Unexpected element: valid-connection-checker-class-name

                        at org.jboss.as.connector.subsystems.datasources.DataSourcesExtension$DataSourceSubsystemParser.readElement(DataSourcesExtension.java:582)

                        at org.jboss.as.connector.subsystems.datasources.DataSourcesExtension$DataSourceSubsystemParser.readElement(DataSourcesExtension.java:182)

                        at org.jboss.staxmapper.XMLMapperImpl.processNested(XMLMapperImpl.java:110) [staxmapper-1.1.0.Final-redhat-2.jar:1.1.0.Final-redhat-2]

                        at org.jboss.staxmapper.XMLExtendedStreamReaderImpl.handleAny(XMLExtendedStreamReaderImpl.java:69) [staxmapper-1.1.0.Final-redhat-2.jar:1.1.0.Final-redhat-2]

                        at org.jboss.as.server.parsing.StandaloneXml.parseServerProfile(StandaloneXml.java:1024) [jboss-as-server-7.3.0.Final-redhat-14.jar:7.3.0.Final-redhat-14]

                        at org.jboss.as.server.parsing.StandaloneXml.readServerElement_1_4(StandaloneXml.java:458) [jboss-as-server-7.3.0.Final-redhat-14.jar:7.3.0.Final-redhat-14]

                        at org.jboss.as.server.parsing.StandaloneXml.readElement(StandaloneXml.java:145) [jboss-as-server-7.3.0.Final-redhat-14.jar:7.3.0.Final-redhat-14]

                        at org.jboss.as.server.parsing.StandaloneXml.readElement(StandaloneXml.java:107) [jboss-as-server-7.3.0.Final-redhat-14.jar:7.3.0.Final-redhat-14]

                        at org.jboss.staxmapper.XMLMapperImpl.processNested(XMLMapperImpl.java:110) [staxmapper-1.1.0.Final-redhat-2.jar:1.1.0.Final-redhat-2]

                        at org.jboss.staxmapper.XMLMapperImpl.parseDocument(XMLMapperImpl.java:69) [staxmapper-1.1.0.Final-redhat-2.jar:1.1.0.Final-redhat-2]

                        at org.jboss.as.controller.persistence.XmlConfigurationPersister.load(XmlConfigurationPersister.java:133) [jboss-as-controller-7.3.0.Final-redhat-14.jar:7.3.0.Final-

                        ... 3 more

                Caused by: org.jboss.as.connector.util.ParserException: IJ010061: Unexpected element: valid-connection-checker-class-name

                        at org.jboss.as.connector.subsystems.datasources.DsParser.parseValidationSetting(DsParser.java:1028)

                        at org.jboss.as.connector.subsystems.datasources.DsParser.parseXADataSource(DsParser.java:473)

                        at org.jboss.as.connector.subsystems.datasources.DsParser.parseDataSources(DsParser.java:200)

                        at org.jboss.as.connector.subsystems.datasources.DsParser.parse(DsParser.java:167)

                        at org.jboss.as.connector.subsystems.datasources.DataSourcesExtension$DataSourceSubsystemParser.readElement(DataSourcesExtension.java:573)

                        ... 13 more