answersLogoWhite

0


Best Answer

An XA transaction, in the most general terms, is a "global transaction" that may span multiple resources. A non-XA transaction always involves just one resource.

An XA transaction involves a coordinating transaction manager, with one or more databases (or other resources, like JMS) all involved in a single global transaction. Non-XA transactions have no transaction coordinator, and a single resource is doing all its transaction work itself (this is sometimes called local transactions).

XA transactions come from the X/Open group specification on distributed, global transactions. JTA includes the X/Open XA spec, in modified form.

Most stuff in the world is non-XA - a Servlet or EJB or plain old JDBC in a Java application talking to a single database. XA gets involved when you want to work with multiple resources - 2 or more databases, a database and a JMS connection, all of those plus maybe a JCA resource - all in a single transaction. In this scenario, you'll have an app server like Websphere or Weblogic or JBoss acting as the Transaction Manager, and your various resources (Oracle, Sybase, IBM MQ JMS, SAP, whatever) acting as transaction resources. Your code can then update/delete/publish/whatever across the many resources. When you say "commit", the results are commited across all of the resources. When you say "rollback", _everything_ is rolled back across all resources.

The Transaction Manager coordinates all of this through a protocol called Two Phase Commit (2PC). This protocol also has to be supported by the individual resources.

In terms of datasources, an XA datasource is a data source that can participate in an XA global transaction. A non-XA datasource generally can't participate in a global transaction (sort of - some people implement what's called a "last participant" optimization that can let you do this for exactly one non-XA item).

User Avatar

Wiki User

14y ago
This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: Differences between XA and Non XA Data sources?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

What are differences between data types numeric and non numeric?

Numeric data are data that can be quantify. i.e age, e.t.c While Non-numeric data are data that cannot be quantify but can be categorise. Such as colour, name e.t.c


What are the differences between Homogeneous and non homogeneous data structures?

in homogeneous data structure all the elements of same data types known as homogeneous data structure. example:- array while there can b any type of data in non homogeneous data structure. example:- list


What are the sources of non traditional sources of demographic data?

Non-traditional sources of demographic data include social media profiles, mobile phone usage data, satellite imagery, and geolocation data from apps and devices. These sources can provide valuable insights into population behaviors, movements, and characteristics that may not be captured through traditional census surveys.


What is the difference between numerical and non-numerical data?

Numerical data is numbers. Non-numerical data is anything else.


What is the advantage for scientists of using nonscientists to collect data?

Non-scientists provide additional sources of data that scientists can use.


Non-example of bivariat data in numbers?

Non-example of bivariate data in numbers is that with numbers that have no relationship between them.


What are differences between commercial bank and non bank financial institution?

difference between non bank and commercial bank?


What are the differences between sinusoidal oscillators and non sinusoidal oscillators?

sinusoidal vs non sinusoidal


What is the differences between spartial data and attribute data?

Spartial data shows specific location of geographical phenomena in terms of coordinates whilst attribute data is non-spatial in that it does not use coordinates but only show what is on a point, line and polygon. by Wilkins Nyamangunda at Midlands State University(2:1)


Differences between living and non living on the molecular basis?

none


What are the differences between visio academic and visio non-academic?

nothing


What is the differences between a living thing and a non living thing?

wewweweewewew