I'm currently developing a Enterprise JAVA Beans application using:
-Sybase Adaptive Server Enterprise 12.0
-Weblogic 5.10 Server
-WINNT

I encounter problem, each time my Entity/Session Bean try to open double
connection to 2 separate database (the same machine).
The error message is like below:
----------------------------------------------------------------------------
----------
getConn(): Unknown exception: java.sql.SQLException: Connection has already
been
created in this tx context for pool named Sybase1Pool.
Illegal attempt to create connection from another pool: Sybase2Pool
java.sql.SQLException:
Connection has already been created in this tx context for pool named
Sybase1Pool.
Illegal attempt to create connection from another pool: Sybase2Pool
----------------------------------------------------------------------------
----------
Sybase1Pool = 1st Pool to the 1st Database
Sybase2Pool = 2nd Pool to the 2nd Database

Although the 1st Pool connection has been closed, the System still send the
same error message by the time I open the 2nd POOL connection.

Does somebody has any idea on opening double POOL connection at the same
application ?

Please send your comment to:

Herianto@fairex.com

Thanks,
Herianto