Oracle® Fusion Middleware High Availability Guide 11g Release 1 (11.1.1) Part Number E10106-01 |
|
|
View PDF |
The following are examples of multi data source configuration files. Multi pool DS JDBC Multi Data Source-0 is made up of two data sources, JDBC Data Source-0, and JDBC Data Source-1. The property settings in bold text are recommended settings:
<?xml version='1.0' encoding='UTF-8'?> <jdbc-data-source xmlns="http://www.bea.com/ns/weblogic/jdbc-data-source" xmlns:sec="http://www.bea.com/ns/weblogic/90/security" xmlns:wls="http://www.bea.com/ns/weblogic/90/security/wls" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.bea.com/ns/weblogic/jdbc-data-source http://www.bea.com/ns/weblogic/jdbc-data-source/1.0/jdbc-data-source.xsd"> <name>JDBC Multi Data Source-0</name> <jdbc-connection-pool-params> <test-frequency-seconds>5</test-frequency-seconds> </jdbc-connection-pool-params> <jdbc-data-source-params> <jndi-name>jdbc/OracleDS</jndi-name> <algorithm-type>Load-Balancing</algorithm-type> <data-source-list>JDBC Data Source-0,JDBC Data Source-1</data-source-list> <failover-request-if-busy>false</failover-request-if-busy> </jdbc-data-source-params> </jdbc-data-source>
<?xml version='1.0' encoding='UTF-8'?> <jdbc-data-source xmlns="http://www.bea.com/ns/weblogic/jdbc-data-source" xmlns:sec="http://www.bea.com/ns/weblogic/90/security" xmlns:wls="http://www.bea.com/ns/weblogic/90/security/wls" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.bea.com/ns/weblogic/jdbc-data-source http://www.bea.com/ns/weblogic/jdbc-data-source/1.0/jdbc-data-source.xsd"> <name>JDBC Data Source-0</name> <jdbc-driver-params> <url>jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=host-vip) (PORT=1521))(CONNECT_DATA=(SERVICE_NAME=dbservice)(INSTANCE_NAME=inst1)))</url> <driver-name>oracle.jdbc.OracleDriver</driver-name> <properties> <property> <name>user</name> <value>username</value> </property> <property> <name>oracle.net.CONNECT_TIMEOUT</name> <value>10000</value> </property> </properties> <password-encrypted>{3DES}LMWCj6TOOuI=</password-encrypted> </jdbc-driver-params> <jdbc-connection-pool-params> <initial-capacity>0</initial-capacity> <max-capacity>20</max-capacity> <capacity-increment>1</capacity-increment> <shrink-frequency-seconds>900</shrink-frequency-seconds> <highest-num-waiters>2147483647</highest-num-waiters> <connection-creation-retry-frequency-seconds>10</connection-creation-retry-frequency-seconds> <connection-reserve-timeout-seconds>10</connection-reserve-timeout-seconds> <test-frequency-seconds>300</test-frequency-seconds> <test-connections-on-reserve>true</test-connections-on-reserve> <ignore-in-use-connections-enabled>true</ignore-in-use-connections-enabled> <inactive-connection-timeout-seconds>0</inactive-connection-timeout-seconds> <test-table-name>SQL SELECT 1 FROM DUAL</test-table-name> <login-delay-seconds>0</login-delay-seconds> <statement-cache-size>10</statement-cache-size> <statement-cache-type>LRU</statement-cache-type> <remove-infected-connections>true</remove-infected-connections> <seconds-to-trust-an-idle-pool-connection>0</seconds-to-trust-an-idle-pool-connection> <statement-timeout>-1</statement-timeout> <pinned-to-thread>false</pinned-to-thread> </jdbc-connection-pool-params> <jdbc-data-source-params> <jndi-name>jdbc/OracleDS0</jndi-name> <global-transactions-protocol>None</global-transactions-protocol> </jdbc-data-source-params> </jdbc-data-source>
<?xml version='1.0' encoding='UTF-8'?> <jdbc-data-source xmlns="http://www.bea.com/ns/weblogic/jdbc-data-source" xmlns:sec="http://www.bea.com/ns/weblogic/90/security" xmlns:wls="http://www.bea.com/ns/weblogic/90/security/wls" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.bea.com/ns/weblogic/jdbc-data-source http://www.bea.com/ns/weblogic/jdbc-data-source/1.0/jdbc-data-source.xsd"> <name>JDBC Data Source-0</name> <jdbc-driver-params> <url> jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=host-vip)(PORT=1521)) (CONNECT_DATA=(SERVICE_NAME=dbservice)(INSTANCE_NAME=inst1)))</url> <driver-name>oracle.jdbc.xa.client.OracleXADataSource</driver-name> <properties> <property> <name>user</name> <value>username</value> </property> <property> <name>oracle.net.CONNECT_TIMEOUT</name> <value>10000</value> </property> </properties> <password-encrypted>{3DES}LMWCj6TOOuI=</password-encrypted> <use-xa-data-source-interface>true</use-xa-data-source-interface> </jdbc-driver-params> <jdbc-connection-pool-params> <initial-capacity>0</initial-capacity> <connection-creation-retry-frequency-seconds>10</connection-creation-retry-frequency-seconds> <max-capacity>15</max-capacity> <capacity-increment>1</capacity-increment> <shrink-frequency-seconds>900</shrink-frequency-seconds> <highest-num-waiters>2147483647</highest-num-waiters> <connection-reserve-timeout-seconds>10</connection-reserve-timeout-seconds> <test-frequency-seconds>300</test-frequency-seconds> <test-connections-on-reserve>true</test-connections-on-reserve> <ignore-in-use-connections-enabled>true</ignore-in-use-connections-enabled> <inactive-connection-timeout-seconds>0</inactive-connection-timeout-seconds> <test-table-name>SQL SELECT 1 FROM DUAL</test-table-name> <login-delay-seconds>0</login-delay-seconds> <statement-cache-size>10</statement-cache-size> <statement-cache-type>LRU</statement-cache-type> <remove-infected-connections>true</remove-infected-connections> <seconds-to-trust-an-idle-pool-connection>0</seconds-to-trust-an-idle-pool-connection> <statement-timeout>-1</statement-timeout> <jdbc-xa-debug-level>10</jdbc-xa-debug-level> <pinned-to-thread>false</pinned-to-thread> </jdbc-connection-pool-params> <jdbc-data-source-params> <jndi-name>jdbc/OracleDS1</jndi-name> <global-transactions-protocol>TwoPhaseCommit</global-transactions-protocol> </jdbc-data-source-params> <jdbc-xa-params> <keep-xa-conn-till-tx-complete>true</keep-xa-conn-till-tx-complete> <need-tx-ctx-on-close>false</need-tx-ctx-on-close> <xa-end-only-once>false</xa-end-only-once> <keep-logical-conn-open-on-release>false</keep-logical-conn-open-on-release> <resource-health-monitoring>true</resource-health-monitoring> <recover-only-once>false</recover-only-once> <xa-set-transaction-timeout>false</xa-set-transaction-timeout> <xa-transaction-timeout>0</xa-transaction-timeout> <rollback-local-tx-upon-conn-close>false</rollback-local-tx-upon-conn-close> <xa-retry-duration-seconds>300</xa-retry-duration-seconds> <xa-retry-interval-seconds>60</xa-retry-interval-seconds> </jdbc-xa-params> </jdbc-data-source>
The only difference between JDBC Data Source-1 for XA and non-XA is they point to a different instance of Oracle RAC (host:port).