JDBC connection pools point to differenct Database

[tom chen]

hi
in the wbs 8.1, we have a default connection pool (cgPool) point to a default
database that has all the system tables for wli and other components in weblogic
platform. i also created another connection pool to point to my database where
i will have my custom tables only. i create a database control which uses the
DataSource that uses this custom pool and do some queries, but a sql exception
was araised because no connection could be created for this pool, and only the
default pool - cgPool has the connection. can anyone tell me why and what is the
best way to set pools. thanks for your help.

[Joe Weinstein]

tom chen wrote:

There should be no problem doing what you want to do. Please turn on jdbc
logging, and show us the jdbc.log file when the server boots up. It should contain
the full error traces of the second pool trying to come up. Once we fix them,
you should be fine. Show me the definitions of the two pools.
Joe

[tom chen]

the problem is gone now, although i still don't know why it had the error. i could
not re-porduce the error i had before for you to see. but thanks for the reply.

[Slava Imeshev]

"tom chen" <tom....@accenture.com> wrote in message news:4051be93$1...@newsgroups.bea.com...

You can not have multiple TX datasource backed by non-XA pools participating
in a single transaction. You need to use XA drivers for both pools to allow this.

Regards,

Slava Imeshev