• Post Reply Bookmark Topic Watch Topic
  • New Topic

Exception in opening multiple connections in a TRANSACTION

 
Karan V Praba
Ranch Hand
Posts: 41
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hai All,
I am in the possition to update multiple databases in a transaction.I am using weblogic6.1 with sp3 and oracle thin driver.I am getting an exception in weblogic when my client invokes spacific method in EJB.eventhough Enable Two-Phase Commit set to true for both TX_DataSoruce .
The Exception is
java.sql.SQLException: Connection has already been created in this tx context for pool named CONNPOOLA. Illegal attempt to create connection from another pool:CONNPOOLB
Please help in this issue.
Thanks in advance.
 
Karan V Praba
Ranch Hand
Posts: 41
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hai all,
Please somebody put light on this issue..
 
Chris Mathews
Ranch Hand
Posts: 2712
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Are you using an XA-compatible JDBC Driver? If not then WLS can emulate a 2PC for a standard but the limitation is that it can only do this for a single connection. WLS documentation refers to this as a "local transaction" and I have a feeling this might be what is causing your problems. The solution is to switch to a fully-compliant XA driver.
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!