1 Reply Latest reply on Jul 9, 2004 10:56 PM by Adrian Brock

    It is very urgent  please help for JTA implementation

    Puneet Jain Newbie

      Hi
      i wanted to insert ARRAY type in oracle database for that i have to use
      Oracle jdbc package.
      i also changed the jboss-xa-jdbc.rar file
      <managedconnectionfactory-class>org.jboss.resource.adapter.jdbc.xa.XAManagedConnectionFactory</managedconnectionfactory-class>
      <connectionfactory-interface>javax.sql.DataSource</connectionfactory-interface>
      <connectionfactory-impl-class>org.jboss.resource.adapter.jdbc.WrapperDataSource</connectionfactory-impl-class>
      <connection-interface>oracle.jdbc.OracleConnection</connection-interface>
      <connection-impl-class>org.jboss.resource.adapter.jdbc.WrappedConnection</connection-impl-class>
      <transaction-support>XATransaction</transaction-support>
      <config-property>

      now i am calling three DAO from my session stateless bean
      each DAO is creating a connection and closing it
      now if first DAO sucessfully insert a record and some exception occur in second DAO
      : i have usd JTA in stateless bean Rollback is sucessfully don but in second DAO i am getting this error


      java.sql.SQLException: Logical handle no longer valid
      20:33:40,140 ERROR [STDERR] at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:168)
      20:33:40,140 ERROR [STDERR] at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:210)
      20:33:40,140 ERROR [STDERR] at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:273)
      20:33:40,140 ERROR [STDERR] at oracle.jdbc.driver.OracleConnection.checkPhyiscalStatus(OracleConnection.java:370)
      20:33:40,140 ERROR [STDERR] at oracle.jdbc.driver.OracleConnection.privatePrepareCall(OracleConnection.java:696)
      20:33:40,140 ERROR [STDERR] at oracle.jdbc.driver.OracleConnection.prepareCall(OracleConnection.java:626)
      20:33:40,140 ERROR [STDERR] at oracle.jdbc.oracore.OracleTypeADT.initMetadata(OracleTypeADT.java:399)
      20:33:40,140 ERROR [STDERR] at oracle.jdbc.oracore.OracleTypeADT.init(OracleTypeADT.java:343)
      20:33:40,140 ERROR [STDERR] at oracle.sql.ArrayDescriptor.initPickler(ArrayDescriptor.java:1002)
      20:33:40,140 ERROR [STDERR] at oracle.sql.ArrayDescriptor.(ArrayDescriptor.java:132)
      20:33:40,140 ERROR [STDERR] at oracle.sql.ArrayDescriptor.createDescriptor(ArrayDescriptor.java:97)
      20:33:40,140 ERROR [STDERR] at com.dol.siyaya.dao.claims.OraUnemploymentClaimDocsDAO.maintainUnemploymentClaimDocs(OraUnemploymentClaimDocsDAO.java:49)
      20:33:40,140 ERROR [STDERR] at com.dol.siyaya.ejb.facade.ClaimsSFBean.maintainUnemploymentClaim(ClaimsSFBean.java:610)
      20:33:40,140 ERROR [STDERR] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      20:33:40,140 ERROR [STDERR] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      20:33:40,140 ERROR [STDERR] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      20:33:40,140 ERROR [STDERR] at java.lang.reflect.Method.invoke(Method.java:324)
      20:33:40,140 ERROR [STDERR] at org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(StatelessSessionContainer.java:683)
      20:33:40,140 ERROR [STDERR] at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:185)
      20:33:40,140 ERROR [STDERR] at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:84)
      20:33:40,140 ERROR [STDERR] at org.jboss.ejb.plugins.AbstractTxInterceptorBMT.invokeNext(AbstractTxInterceptorBMT.java:144)
      20:33:40,140 ERROR [STDERR] at org.jboss.ejb.plugins.TxInterceptorBMT.invoke(TxInterceptorBMT.java:62)
      20:33:40,140 ERROR [STDERR] at org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessSessionInstanceInterceptor.java:72)
      20:33:40,140 ERROR [STDERR] at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:118)
      20:33:40,140 ERROR [STDERR] at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:191)
      20:33:40,140 ERROR [STDERR] at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor.java:122)
      20:33:40,140 ERROR [STDERR] at org.jboss.ejb.StatelessSessionContainer.internalInvoke(StatelessSessionContainer.java:331)
      20:33:40,140 ERROR [STDERR] at org.jboss.ejb.Container.invoke(Container.java:700)
      20:33:40,140 ERROR [STDERR] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      20:33:40,140 ERROR [STDERR] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      20:33:40,140 ERROR [STDERR] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      20:33:40,140 ERROR [STDERR] at java.lang.reflect.Method.invoke(Method.java:324)
      20:33:40,140 ERROR [STDERR] at org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
      20:33:40,140 ERROR [STDERR] at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:546)
      20:33:40,140 ERROR [STDERR] at org.jboss.invocation.local.LocalInvoker.invoke(LocalInvoker.java:101)
      20:33:40,140 ERROR [STDERR] at org.jboss.invocation.InvokerInterceptor.invoke(InvokerInterceptor.java:90)
      20:33:40,140 ERROR [STDERR] at org.jboss.proxy.TransactionInterceptor.invoke(TransactionInterceptor.java:46)
      20:33:40,140 ERROR [STDERR] at org.jboss.proxy.SecurityInterceptor.invoke(SecurityInterceptor.java:45)
      20:33:40,140 ERROR [STDERR] at org.jboss.proxy.ejb.StatelessSessionInterceptor.invoke(StatelessSessionInterceptor.java:100)
      20:33:40,140 ERROR [STDERR] at org.jboss.proxy.ClientContainer.invoke(ClientContainer.java:85)
      20:33:40,140 ERROR [STDERR] at $Proxy47.maintainUnemploymentClaim(Unknown Source)
      20:33:40,140 ERROR [STDERR] at com.dol.siyaya.web.bd.ClaimsBD.maintainUnemploymentClaim(ClaimsBD.java:213)
      20:33:40,140 ERROR [STDERR] at com.dol.siyaya.web.controller.ClaimsController.processDocumentSubmittedScreen(ClaimsController.java:1840)
      20:33:40,140 ERROR [STDERR] at com.dol.siyaya.web.controller.ClaimsController.doPost(ClaimsController.java:1071)
      20:33:40,140 ERROR [STDERR] at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
      20:33:40,140 ERROR [STDERR] at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
      20:33:40,140 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247)
      20:33:40,140 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
      20:33:40,140 ERROR [STDERR] at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:256)
      20:33:40,140 ERROR [STDERR] at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
      20:33:40,140 ERROR [STDERR] at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
      20:33:40,140 ERROR [STDERR] at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
      20:33:40,140 ERROR [STDERR] at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
      20:33:40,140 ERROR [STDERR] at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
      20:33:40,140 ERROR [STDERR] at org.jboss.web.tomcat.security.JBossSecurityMgrRealm.invoke(JBossSecurityMgrRealm.java:220)
      20:33:40,140 ERROR [STDERR] at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
      20:33:40,156 ERROR [STDERR] at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:494)
      20:33:40,156 ERROR [STDERR] at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
      20:33:40,156 ERROR [STDERR] at org.apache.catalina.valves.CertificatesValve.invoke(CertificatesValve.java:246)
      20:33:40,156 ERROR [STDERR] at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
      20:33:40,156 ERROR [STDERR] at org.jboss.web.tomcat.tc4.statistics.ContainerStatsValve.invoke(ContainerStatsValve.java:76)
      20:33:40,156 ERROR [STDERR] at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
      20:33:40,156 ERROR [STDERR] at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
      20:33:40,156 ERROR [STDERR] at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
      20:33:40,156 ERROR [STDERR] at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2417)
      20:33:40,156 ERROR [STDERR] at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180)
      20:33:40,156 ERROR [STDERR] at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
      20:33:40,156 ERROR [STDERR] at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:171)
      20:33:40,156 ERROR [STDERR] at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
      20:33:40,156 ERROR [STDERR] at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172)
      20:33:40,156 ERROR [STDERR] at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
      20:33:40,156 ERROR [STDERR] at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:65)
      20:33:40,156 ERROR [STDERR] at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
      20:33:40,156 ERROR [STDERR] at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:577)
      20:33:40,156 ERROR [STDERR] at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
      20:33:40,156 ERROR [STDERR] at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
      20:33:40,156 ERROR [STDERR] at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
      20:33:40,156 ERROR [STDERR] at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174)
      20:33:40,156 ERROR [STDERR] at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
      20:33:40,156 ERROR [STDERR] at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
      20:33:40,156 ERROR [STDERR] at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
      20:33:40,156 ERROR [STDERR] at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:197)
      20:33:40,156 ERROR [STDERR] at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:781)
      20:33:40,156 ERROR [STDERR] at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:549)
      20:33:40,156 ERROR [STDERR] at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:605)
      20:33:40,156 ERROR [STDERR] at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:677)
      20:33:40,156 ERROR [STDERR] at java.lang.Thread.run(Thread.java:534)
      20:33:40,156 FATAL [OraUnemploymentClaimDocsDAO] Fatal error occured in class OraUnemploymentClaimDocsDAO - maintainUnemploymentClaimDocsjava.sql.SQLException: Logical handle no longer valid
      20:33:40,156 INFO [STDOUT] RETURBED BOOLEAN VALUE FROM DOCS :::::false
      20:33:40,156 INFO [STDOUT] FailedToRegisterClaimantException se+ CLaimsBena
      20:33:40,156 INFO [STDOUT] ROLLING BACK THE TRANSACTION IN CLAIMS SF BEAN::::::::::::


      kinsly help me

      puneet