To set up multiple connection pools in WLS:
weblogic.jdbc.connectionPool.oraclePoolOne=\
url=[your url here],\
driver=weblogic.jdbc.oci.Driver,\
loginDelaySecs=1,\
initialCapacity=4,\
maxCapacity=10,\
capacityIncrement=2,\
allowShrinking=true,\
shrinkPeriodMins=15,\
refreshMinutes=10,\
testTable=dual,\
props=user=ME;password=pw;server=SomeServer
weblogic.jdbc.connectionPool.oraclePoolTwo=\
url=[your url here],\
driver=weblogic.jdbc.oci.Driver,\
loginDelaySecs=1,\
initialCapacity=4,\
maxCapacity=10,\
capacityIncrement=2,\
allowShrinking=true,\
shrinkPeriodMins=15,\
refreshMinutes=10,\
testTable=dual,\
props=user=ME;password=pw;server=SomeServer
That being said, do your transactions span accross both databases or
is it a more simplified case where one type of bean talks to one database
and another bean to the other database?
I've never done any XA/multi-pass/accross database instance transactions
so I cannot speak to this.
cheers,
peter
At Sat, 9 Sep 2000 16:21:02 +0530 , Pittu Sreehari <[EMAIL PROTECTED]> wrote:
>Hi all,
>Is it possible to create n(min 4) no of connection pools in weblogic
>properties file with different databases (different drivers)?'coz I have
>
>to update the data in 2 different tables which are in 2 different
>Connection pools(different databases) with session beans.If so
>how can i maintain the Transactional state or TransactionInstance
>'coz those 2 tables are in 2 different databases.
>
>If anybody have solution please let me know.
>
>Thanx
>hari
>
>===========================================================================
>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".
