我想连接到此 TNS 描述的集群 Oracle 数据库:
MYDB=
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = host1)(PORT = 41521))
(ADDRESS = (PROTOCOL = TCP)(HOST = host2)(PORT = 41521))
(LOAD_BALANCE = yes)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME= PDSALPO)
)
)
我使用以下配置正常从应用程序连接到非集群 Oracle:
<group name="jdbc">
<prop name="url">jdbc:oracle:thin:@host1:41521:PDSALPO</prop>
<prop name="username">user</prop>
<prop name="password">pass</prop>
</group>
您知道如何更改它以连接到集群数据库吗?
Thanks,
Tam
显然你可以做到这一点
jdbc:oracle:thin:@(DESCRIPTION=(LOAD_BALANCE=on)
(ADDRESS=(PROTOCOL=TCP)(HOST=host1)
(PORT=1521))
(ADDRESS=(PROTOCOL=TCP)(HOST=host2)
(PORT=1521))
(CONNECT_DATA=(SERVICE_NAME=service)))
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系:hwhale#tublm.com(使用前将#替换为@)