Hello friends -

For the life of me, I've been struggling to find a good example somewhere of a configuration example for setting up a situation using Hibernate to talk to multiple databases and wrap everything up in a JTA transaction. My business case is this:

1) Goto SqlServer. Get some values where exportedSw == false.
2) Based on those values, goto Oracle and look up some other values.
3) Take these values and make inserts into Mysql.
4) Update SqlServer telling it that I have successfully gotten the values handled, and I don't need to get them on the next run.
5) Repeat run.

Works great, but if I get a failure at step 4, I need step 3 not to commit.

OK, JTA is what I need. But I seriously am having big trouble finding an example of configuring a JTA solution for multiple databases. I get that my HibernateTransactionFactory definitions will need to be set appropriately, and that I can configure my datasources within Jboss to utilize an XA compliant driver. But what I don't see is how / where these tie together, and I also find myself wondering if I need to tie together within Jboss the datasources to be entangled logically; i,e., if I had two different applications, that both needed JTA support across different databases, what would this configuration look like?

Any insight is appreciated.

Thank you.

brian

I am currently also looking into how to properly use multiple DBs in Jboss (with Hibernate - though with a different focus...),

Here is what might help you:

Use XA-DataSources configuration instead of <local-tx-datasource>

Example:


and also add the other DataSources analogously, for proper TransactionHandling in JBoss search for XA and JBoss (didn't get that far, yet ;) )

Hope this helps,
Cheers, Arndt