Win a copy of Beginning Java 17 Fundamentals: Object-Oriented Programming in Java 17 this week in the Java in General forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Tim Cooke
  • Campbell Ritchie
  • Ron McLeod
  • Liutauras Vilda
  • Jeanne Boyarsky
Sheriffs:
  • Junilu Lacar
  • Rob Spoor
  • Paul Clapham
Saloon Keepers:
  • Tim Holloway
  • Tim Moores
  • Jesse Silverman
  • Stephan van Hulst
  • Carey Brown
Bartenders:
  • Al Hobbs
  • Piet Souris
  • Frits Walraven

How can we handle transactions using Java Connector Architecture?

 
Greenhorn
Posts: 14
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
I am not expecting actual code. Only concept or description will be enough.
 
Ranch Hand
Posts: 859
IBM DB2 Chrome Java
  • Likes 1
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Plenty of concepts in here ...

http://en.wikipedia.org/wiki/Java_EE_Connector_Architecture

WP
 
Ranch Hand
Posts: 88
  • Likes 1
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Normally the transactions in JCA are managed by the Application Server. App server implements the Transaction contracts between itself and the back end system. I believe application servers such as JBOSS or WAS implement JCA even for setting up connections to RDBMS like Oracle. In this case, it's usually set up as a LOCAL TRANSACTION without the need for an external transactional coordinator.

However if you use JCA to talk to multiple data sources (say, Oracle and LEGACY System), it needs to be set up as XA transaction with the need for an external transaction coordinator that can do a Two phase commit.
Developers would be providing configuration information alone (Local or XA, login credentials and other metadata) while the Application server usually implements the Transaction contracts required by the Application.
 
Sumit Bhoyar
Greenhorn
Posts: 14
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Thanks Sunderam for this info.
So this is my understanding-
Some JCA adapters doesn't support transactions.
If JCA adapter is communicating with single system and managing transaction, then it is set up as LOCAL TRANSACTION.
If JCA adapter is communicating with multiple systems and managing transaction, then it is set up as XATransaction.

Please correct me if I am wrong.
 
Sunderam Goplalan
Ranch Hand
Posts: 88
  • Likes 1
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Correct.

As for this "Some JCA adapters doesn't support transactions", I'm inclined to think that, at least in 2012, is that most JCA adapters DO support transactions. Few may not, as you say, yes.
 
Bartender
Posts: 361
  • Likes 1
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
And i believe any JCA adapter which doesn't support XA transaction-corresponding adapters from the Application server vendors are provided to fulfill this need.
 
Sumit Bhoyar
Greenhorn
Posts: 14
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Thanks Sunderam, Ashutosh for your comments
 
WHAT is your favorite color? Blue, no yellow, ahhhhhhh! Tiny ad:
Building a Better World in your Backyard by Paul Wheaton and Shawn Klassen-Koop
https://coderanch.com/wiki/718759/books/Building-World-Backyard-Paul-Wheaton
reply
    Bookmark Topic Watch Topic
  • New Topic