与Oracle Clustered的JDBC连接 [英] JDBC connection to Oracle Clustered

问题描述

我想连接到此TNS描述的集群Oracle数据库：

I would like to connect to a clustered Oracle database described by this TNS:

 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：

I connect normally from my application to non-clustered Oracle using the following configuration:

<group name="jdbc">
    <prop name="url">jdbc:oracle:thin:@host1:41521:PDSALPO</prop>
    <prop name="username">user</prop>
    <prop name="password">pass</prop> 
</group>

您知道如何更改连接到集群数据库吗？

Do you know how I can change that to connect to the clustered database?

谢谢，

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)))

这篇关于与Oracle Clustered的JDBC连接的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！