Beginners Questions about XA transactions

[chausberger]

Hello

I am new to XA transactions and have a question for which I couldn't find an answer via google.

I have one Oracle DB with two completey seperate schemas. I have to use a transcation over both of them and want to use JTA.
Every schema has a different user/password.
I installed the Oracel XA datasource. Where do I specify the user names and passwords for the two different schemas?


Claus

[jhalliday]

> I installed the Oracel XA datasource.

Installed it into what?

[chausberger]

"jhalliday" wrote:
> I installed the Oracel XA datasource.

Installed it into what?

sorry for my confusing words.

I ment I copied the oracle-xa-ds.xml from the JBoss 3.2.6 (I currently have to use this version - move to 4.2 planed for the future) source distribution and changed to for our settings and they deployed it to "server/default/deploy".

Currently I added the username/password for one schema.
Do I have to add another datasource for the 2nd schema?

Claus

[jhalliday]

Yes. And by the way it's nothing to do with JBoss Transactions. Try the database/JCA forums.