Hello,

fyi - WebLogic version 8.1 SP2

We are updating our product to use MySQL 5 (from MySQL 4) due to the
XA support. In order to use the XA driver I created a new JDBC
Connection Pool (call it MySQLXAConnPool). I then tried to switch the
existing non-XA connection pool that my JMS JDBC Store was configured
to use to the XA connection pool. Upon trying to change the
connection pool in the JMS JDBC Store I get the following error:

java.sql.SQLException: Pool connect failed : java.lang.Exception:
Weblogic Pool Driver doesn't support XA driver, Please change your
config to use a Non-XA driver

After much digging I found documentation that you cannot configure an
XA JDBC Connection Pool for use with a JMS JDBC Store:
http://edocs.bea.com/wls/docs81/ConsoleHelp/jms_config.html#1128929

The only thing is that if I configure a brand new JMS JDBC Store and
make it use the XA JDBC Connection Pool (instead of just selecting
the new MySQLXAConnPool from the list that includes the non XA pool)
it works without an error.

Does anyone know if WebLogic is supposed to complain when you try to
use an XA Pool with JMS JDBC Store or are you just expected to read
the docs and know that? Just curious if the latter part of my test
where it let me use an XA pool for a JMS JDBC Store was a fluke.

Thanks,
Dharmita