-
1. Re: multiple datasources in a transaction
rajaboobalan Dec 5, 2003 8:27 AM (in response to mojo78)DATASOURCE is just a logical reference to the DATABASE. The credentials are checked only when you try to get a connection.
-
2. Re: multiple datasources in a transaction
mojo78 Dec 8, 2003 12:45 PM (in response to mojo78)hmm, well in that case i'm stumped.
my application accesses an oracle database and no other datasource. i have transactions within it that access the database, some of which contain updates to more than 1 table in the DB.
i'm getting a warning that says
"2003-12-05 13:26:44,591 WARN [org.jboss.resource.connectionmanager.TxConnectionManager] Prepare called on a local tx. Use of local transactions on a jta transaction with more than one branch may result in inconsistent data in some cases of failure."
i thought hopefully that the warning was harmless but it's causing my transactions to be rolled back. i never explicitly called prepare though.
i read that xa transactions are required when more than 1 datasource was being updated but since i'm only using 1 db are they necessary?
i was wondering if a transaction that contains more than 1 update to tables within the same database warrants the use of the XA transactions. if so, any helpful pointers on how to change over?
thanks,
maurice