在Apusic上配置Oracle RAC数据源

最新推荐文章于 2021-09-30 13:48:05 发布

iteye_4822

最新推荐文章于 2021-09-30 13:48:05 发布

阅读量285

点赞数

分类专栏： J2EE 文章标签： Oracle XML HTML

本文链接：https://blog.csdn.net/iteye_4822/article/details/81578417

版权

J2EE 专栏收录该内容

20 篇文章 0 订阅

订阅专栏

原文出自：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>