zl程序教程

您现在的位置是:首页 >  数据库

当前栏目

JDBC连接集群数据库的方法

2023-06-13 09:15:13 时间

在连接数据库的url地址有点不一样

复制代码代码如下:

jdbc:oracle:thin:@(DESCRIPTION=
(LOAD_BALANCE=on)
(ADDRESS_LIST=
(ADDRESS=(PROTOCOL=TCP)(HOST=IP1)(PORT=1521))
(ADDRESS=(PROTOCOL=TCP)(HOST=IP2)(PORT=1521))
)
(CONNECT_DATA=(SERVICE_NAME=服务名)))

url=jdbc:oracle:thin:@(DESCRIPTION=
(ADDRESS_LIST=
(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.0.77)(PORT=1521))
(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.0.91)(PORT=1521))
(ADDRESS=(PROTOCOL=TCP)(HOST=hostIp3)(PORT=1521))
)
(CONNECT_DATA=(SERVICE_NAME=APPDB)))
username=imei_app
password=imei_app