Granny's Programming Pearls
"inside of every large program is a small program struggling to get out"
JavaRanch.com/granny.jsp
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 Groovy Fundamentals video training course this week in the Groovy 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
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Two connections in one transaction?