JCA adapter and JTA .help!
1 posts in topic
Flat View  Flat View
TOPIC ACTIONS:
 

Posted By:   li_xiaotang
Posted On:   Friday, May 16, 2003 01:00 AM

i leaned JCA just now.i want to use JCA to complish a function in DTP system. My system is differrent from other in that i want to integrate EJB and EJB using the JCA. Now my J2EE platforms are websphere and jboss.Databases are oracle9i and db2. I want to use a EJB1 in websphere and EJB2 in jboss to transfer 100$ from oracle9i to db2,just like finance transfer. 1.Might you tell me the steps or codes of completing the function, Or provide a similar example for me? 2.How to write the adapter based on JCA to connect with the other j2ee server? I learned JCA just now.So i am poor in JCA and EAI.please help me!!It is really helpful if you could response me as soon as possilbe. I know that i needn't use JCA to realize the work might.there are other ways can do it. But my pur   More>>

i leaned JCA just now.i want to use JCA to complish a function in DTP system. My system is differrent from other in that i want to integrate EJB and EJB using the JCA. Now my J2EE platforms are websphere and jboss.Databases are oracle9i and db2. I want to use a EJB1 in websphere and EJB2 in jboss to transfer 100$ from oracle9i to db2,just like finance transfer. 1.Might you tell me the steps or codes of completing the function, Or provide a similar example for me? 2.How to write the adapter based on JCA to connect with the other j2ee server? I learned JCA just now.So i am poor in JCA and EAI.please help me!!It is really helpful if you could response me as soon as possilbe. I know that i needn't use JCA to realize the work might.there are other ways can do it. But my purpose to complete the function is i want to learn to how to write adapter and use JTA. I am looking forward to hearing from you soon!Thank you very much for your help!.

   <<Less

Re: JCA adapter and JTA .help!

Posted By:   Nick_Maiorano  
Posted On:   Saturday, May 17, 2003 06:50 AM

Hello,



I'm not convinced that you need to use EAI when this can be easily accomplished with XA-enabled JDBC connections pools in both websphere and jboss. XA is a protocol that allows multiple transactional resources (such a oracle and db2 databases) to participate in the same transaction and commit or rollback atomically.



First, create a jdbc connection pool with the XA option enabled in both websphere and jboss. You will need a jdbc driver that supports XA (these can be found in your oracle and db2 client installations). Ensure both EJB1 and EJB2 use the XA-enabled JDBC connection. Once you have configured your app servers, you can call EJB1 (in websphere) which may call EJB2 (in jboss). When the transaction completes, everything is committed (or rolledback) atomically.



The advantage of this solution is that it requires no extra programming. It's all done through your app server configuration.

About | Sitemap | Contact