1 Reply Latest reply on Jul 1, 2009 5:35 AM by vickyk

    Support for CICS + local-tx-datasource

      Hello,

      We are connecting CICS from JBoss using CICS ECI Calls, but we want to use it in global transactions. CICS J2EE ECI Resource Adapter supports only LocalTransactions, and we are using an Oracle data source configured as local-tx-datasource. I know that the configuration of the Oracle data source should be modified to xa-datasource, but I want to know what will be the TransactionManager behavior if we use the current configuration as a JTA transaction? Will the CICS transaction be used in a LastResourceOptimization, or I must transform the local-tx-datasource in a xa-datasource in order to use the CICS transaction globally?

      Thank you in advance,

      Andre

        • 1. Re: Support for CICS + local-tx-datasource
          vickyk

           

          "panisson" wrote:
          Will the CICS transaction be used in a LastResourceOptimization, or I must transform the local-tx-datasource in a xa-datasource in order to use the CICS transaction globally?

          You can have multiple single phase participants in the the global transaction, the TM will complaint about it.
          You will not be able to go ahead unless you make some AS tweaks, for the LRCO yes you should make oracle ds configured as xa-datasource.
          Check this
          http://www.jboss.org/community/wiki/Multiple1PC