在Apusic上配置Oracle RAC数据源

原文出自：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 = (PROTOCOL = TCP)(HOST = host1)(PORT = 1521))(ADDRESS = (PROTOCOL = TCP)(HOST = host2)(PORT = 1521))(LOAD_BALANCE = yes)(FAILOVER = ON)(CONNECT_DATA =(SERVER = DEDICATED)(SERVICE_NAME = RAC_DB)(FAILOVER_MODE=(TYPE = SELECT)(METHOD = BASIC)(RETIRES = 20)(DELAY = 15))))"
     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>