8 Replies Latest reply on May 22, 2003 10:01 PM by xiaoyi

    do me a favour about JCA in system connection !

    taobigz Newbie

      i want to get some help from you.
      Now my J2EE platforms are websphere application developer and jboss.EISs are oracle9i and db2.
      And there are two applications on WSAD and Jboss seperately,the association between the two applications is one app on WSAD would take out some money from a table in oracle9i and transfer it to db2,just like finance transfer.
      I want to know how can i connect the two applications by JCA and accomplish the function of finance transfer use DTP specifications.The global transaction process is based on the XA.
      How can i do now ?
      Would you tell me the steps and way to complete the work of connecting two
      Apps?How to deploy the environment,and examples about this kind of problem?
      I learned JCA just now.So i am very poor in JCA and EAI.please help me!!It is really helpful if you could response me as soon as possilbe.
      I am looking forward to hearing from you soon!Thank you very much for your help!

      thanks!

        • 1. Re: do me a favour about JCA in system connection !
          Timothy Potter Newbie

          Dear li.xiaotang,

          This is a pretty common JDBC scenario. I'm not sure why you would need to use the J2EE Connector Architecture here, though. I'm not a DB2 person, but I know that Oracle is XA compliant and implements the XA features in their JDBC adapters. Assuming DB2 also provides an XA compliant JDBC driver, then you can simply open two different JDBC connections (using JDBC DataSources) and perform straight JDBC calls to implement your scenario.

          The Connector Architecture doesn't offer much value in your scenario (except maybe in the deployment of a JDBC DataSource -- see Sun's JDBC Connector for details on this). A JDBC Connector typically wraps a JDBC driver anyway. Moreover, if a database is XA compliant, then it will implement the javax.sql.XA* stuff in its JDBC driver. Oracle's JDBC examples demonstrate this: see http://otn.oracle.com/sample_code/tech/java/sqlj_jdbc/files/jdbc20/DistributedTransaction/DistributedTransaction.jar (you will need to be a member of Oracle's OTN to access this file)

          Lastly, you'll need some way to indicate that you want to execute your transaction scenario in the context of a JTA transaction, such as using the JTA calls directly (component managed transactions) or by using container managed transactions in an EJB method with transaction attribute "Required" or "RequiresNew" depending on your application's needs.

          Regards,

          Timothy Potter
          connectorWorks.org

          • 2. Re: do me a favour about JCA in system connection !
            xiaoyi Newbie

            I know about that my question may be done by other ways ,but my teacher want to let me learn to use JCA to complish the enterprise integration.
            So i want to know how to create an adapter to connect the other J2ee server.
            some one tell me so"1. Write only a jca 1.0 outbound adapter to deploy on websphere. This
            will use the new jboss Remoting framework for the ejb invocations. You
            will have to replace the client side DTXAResource remoting interceptor
            with something that supplies an XAResource for the ManagedConnections."
            How do you think?
            And i know how to design a distributed transaction ,in outbound the adapter or in the adapter?Do you know the ways to create the similar adapter?or have you the example adapter?
            if i can't complish this ,my manager said i will be fired one month later!!i am very sorry .please help me!!

            • 3. Re: do me a favour about JCA in system connection !
              xiaoyi Newbie

              Hi!tjp,thanks!
              I know about that my question may be done by other ways,but my manager want to let me learn to use JCA ,and exploit adapter to complish the enterprise integration.So i want to know how to create an adapter to conncet the other J2ee server.some one tell me "1. Write only a jca 1.0 outbound adapter to deploy on websphere. This
              will use the new jboss Remoting framework for the ejb invocations. You
              will have to replace the client side DTXAResource remoting interceptor
              with something that supplies an XAResource for the ManagedConnections.",How do you think?
              And i want to know how to design a distributed transaction ,outbound the adapter or in the adapter?Do you know the ways to create the similar adapter?ora have you the example adapter?if i can't complish this work,my manager said i will be fired twenty days later.i am very sorry ,please help me!!!

              • 4. Re: do me a favour about JCA in system connection !
                xiaoyi Newbie

                I know that my question may be done by other ways.but my manager want to let me learn how to use jca to integrate .i want to know the distributed transaction is outbound the adapter or in the adapter.
                some one tell me"1. Write only a jca 1.0 outbound adapter to deploy on websphere. This
                will use the new jboss Remoting framework for the ejb invocations. You
                will have to replace the client side DTXAResource remoting interceptor
                with something that supplies an XAResource for the ManagedConnections."How do you think?
                My manager said that if i can't complete the work i will be fired twenty days later.i am very sorry ,please help me!
                or deliver some similar example adapter to me ,so that i can get some spirit.

                • 5. Re: do me a favour about JCA in system connection !
                  xiaoyi Newbie

                  I know that my question may be done by other ways.but my manager want to let me learn how to use jca to integrate .i want to know the distributed transaction is outbound the adapter or in the adapter.
                  some one tell me"1. Write only a jca 1.0 outbound adapter to deploy on websphere. This
                  will use the new jboss Remoting framework for the ejb invocations. You
                  will have to replace the client side DTXAResource remoting interceptor
                  with something that supplies an XAResource for the ManagedConnections."How do you think?
                  My manager said that if i can't complete the work i will be fired twenty days later.i am very sorry ,please help me!
                  or deliver some similar example adapter to me ,so that i can get some spirit.

                  • 6. Re: do me a favour about JCA in system connection !
                    xiaoyi Newbie

                    I know that my question may be done by other ways.but my manager want to let me learn how to use jca to integrate .i want to know the distributed transaction is outbound the adapter or in the adapter.
                    some one tell me"1. Write only a jca 1.0 outbound adapter to deploy on websphere. This
                    will use the new jboss Remoting framework for the ejb invocations. You
                    will have to replace the client side DTXAResource remoting interceptor
                    with something that supplies an XAResource for the ManagedConnections."How do you think?
                    My manager said that if i can't complete the work i will be fired twenty days later.i am very sorry ,please help me!
                    or deliver some similar example adapter to me ,so that i can get some spirit.

                    • 7. Re: do me a favour about JCA in system connection !
                      xiaoyi Newbie

                      I know that my question may be done by other ways.but my manager want to let me learn how to use CA to integrate .i want to know the distributed transaction is outbound the adapter or in the adapter.
                      some one tell me"1. Write only a jca 1.0 outbound adapter to deploy on websphere. This
                      will use the new jboss Remoting framework for the ejb invocations. You
                      will have to replace the client side DTXAResource remoting interceptor
                      with something that supplies an XAResource for the ManagedConnections."How do you think?
                      My manager said that if i can't complete the work i will be fired twenty days later.i am very sorry ,please help me!
                      or deliver some similar example adapter to me ,so that i can get some spirit.

                      • 8. Re: do me a favour about JCA in system connection !
                        xiaoyi Newbie

                        I know that my question may be done by other ways.but my manager want to let me learn how to use jca to integrate .i want to know the distributed transaction is outbound the adapter or in the adapter.
                        some one tell me"1. Write only a jca 1.0 outbound adapter to deploy on websphere. This
                        will use the new jboss Remoting framework for the ejb invocations. You
                        will have to replace the client side DTXAResource remoting interceptor
                        with something that supplies an XAResource for the ManagedConnections."How do you think?
                        My manager said that if i can't complete the work i will be fired twenty days later.i am very sorry ,please help me!
                        or deliver some similar example adapter to me ,so that i can get some spirit.