posted 21 years ago
Hi all
I have a code that implements 2 phase commit using programmatic transaction control. The code basically accesses 2 database running at 2 physical location with 2 different datasources.
The code works fine in 1 application server but hit the following error in bea. I have also ensure that I had clicked the 2 phase commit option in bea admin console.
Any one knows how to resolve this ?
java.sql.SQLException: Connection has already been created in this tx context fo r pool named KernlPool. Illegal attempt to create connection from another pool: EmanPool
at
weblogic.jdbc.jts.Driver.getExistingConnection(Driver.java:292)
at weblogic.jdbc.jts.Driver.connect(Driver.java:123)
at weblogic.jdbc.common.internal.RmiDataSource.getConnection(RmiDataSour
ce.java:214)
at org.exolab.castor.jdo.engine.DatabaseRegistry.createConnection(Unknow
n Source)
at org.exolab.castor.jdo.engine.TransactionContextImpl.getConnection(Unk
nown Source)
at org.exolab.castor.persist.ClassMolder.create(Unknown Source)
at org.exolab.castor.persist.LockEngine.create(Unknown Source)
at org.exolab.castor.persist.TransactionContext.create(Unknown
Source)
at org.exolab.castor.jdo.engine.DatabaseImpl.create(Unknown
Source)
at com.ekernel.examples.echo.service.EchoServiceBean.test2db(EchoService
Bean.java:270)
at com.ekernel.examples.echo.service.EchoServiceBean.doProcess(EchoServi