fyjava

原文出自：http://operamasks.blogbus.com/logs/19649985.html

在Apusic上配置Oracle RAC数据源很简单，只需要2步就搞定：

1. 拷贝ojdbc14.jar到APUSIC_HOME/lib
2. 修改APUSIC_HOME/config/datasources.xml，添加形如下述片段：
<datasource name="test"
jndi-name="jdbc/test"
driver-class="oracle.jdbc.OracleDriver" url="jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=node1)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=node2)(PORT=1521))(LOAD_BALANCE=yes)(FAILOVER=on))(CONNECT_DATA=(SERVICE_NAME=RAC_DB)))"
min-spare-connections="10"
max-spare-connections="35"
max-connections="75"
>
<property name="user" value="scott"/>
<property name="password" value="tiger"/>
<property name="test-before-reused" value="false"/>
<property name="test-command" value="select 1 from dual"/>
<remote-acl>
<user>admin</user>
<user>j2ee</user>
</remote-acl>
</datasource>