This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan on-line!
See this thread for details.
The moose likes BEA/Weblogic and the fly likes Two connections in one transaction? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Products » BEA/Weblogic
Bookmark "Two connections in one transaction?" Watch "Two connections in one transaction?" New topic
Author

Two connections in one transaction?

alex seba
Greenhorn

Joined: Jul 19, 2002
Posts: 12
Hi,
I'm using a stateless Session Bean as a facade to some Entity Beans. All transactions are managed by the container.
I want to have access to two connection pools within one transaction. I'm using a DB2 with the COM.ibm.db2.jdbc.app.DB2Driver and an InstantDB with the org.enhydra.instantdb.jdbc.idbDriver. I know that it must be possible as these drivers support XA-Transactions.
But with my setup I'm getting a java.sql.SQLException that there cannot be two connections within one transaction. Can anyone give me some hints how to setup my JTA properties for this scenario?
Thanks in advance
Alex
 
Don't get me started about those stupid light bulbs.
 
subject: Two connections in one transaction?
 
Similar Threads
Of Hibernate sessions and transactions
CMP Transactions Doubt
Two connections in one transaction?
Need Help! - MDB transactions interacting with JDBC transactions
transaction when multiple database connections are open