To interact with 2 database servers within the same transaction you need an
application server capable of doing a distributed XA transaction. AFAIK WLS
does not support this.
Dave Wolf
Internet Applications Division
Sybase
> -----Original Message-----
> From: A mailing list for Enterprise JavaBeans development
> [mailto:[EMAIL PROTECTED]]On Behalf Of ejbjaggi
> Sent: Thursday, August 17, 2000 9:46 AM
> To: [EMAIL PROTECTED]
> Subject: Connection Pool Problem
>
>
> Hi All
>
> I am working on Weblogic 4.5.1.
>
> I need to connect to 2 Databases from within the same transaction.
>
> Oracle using ejbPool
> MS SQLServer using ejbBTPool
>
> Is it possible to use 2 connection pools withing the same transaction
>
> When I try to do the same the following exception occurred ..
>
> ***************
> java.sql.SQLException: Connection has already been created in
> this tx context for pool named ejbPool. Illegal attempt to
> create connection from another pool: ejbBTPool
> java.sql.SQLException: Connection has already been created in
> this tx context for pool named ejbPool. Illegal attempt to
> create connection from another pool: ejbBTPool
> at weblogic.jdbcbase.jts.Driver.connect(Driver.java,
> Compiled Code)
> at java.sql.DriverManager.getConnection(DriverManager.java:457)
> at java.sql.DriverManager.getConnection(DriverManager.java:159)
> ***************
>
> Suggesstions Please.
> Thanks
> Jagdish
>
> ------------------------------------------------------------------------
> Want to increase your website's income dramatically?
> Join Chinese-dns.com Reseller Program Now!
> Get USD22.00 per sale, go to http://www.chinese-dns.com
> �Q�j�T�����������J�ܡS
> ��ˤ~����o�C���P��22�����������O�S
> �֨� http://www.chinese-dns.com �u�W�ӽХ[�J������}���U���P�ӡC
>
> ==================================================================
> =========
> To unsubscribe, send email to [EMAIL PROTECTED] and include
> in the body
> of the message "signoff EJB-INTEREST". For general help, send email to
> [EMAIL PROTECTED] and include in the body of the message "help".
>
>
===========================================================================
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff EJB-INTEREST". For general help, send email to
[EMAIL PROTECTED] and include in the body of the message "help".
