Hello Dharmita,
As far as I know, you should NOT be able to use an XA
JDBC connection pool for use with a JMS JDBC store.
I'm not sure why you didn't get a failure notice. It
could be something specific in the configuration of
the new pool or it could be related to the driver.
-Dave

--- dharmitashah <dharmita.lutz@...> wrote:

>
>
> 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
>
>
>
>
>


__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com