Qracle集群中PL/SQL和Java程序连接方式

2014-11-24 17:43:01 · 作者: · 浏览: 0

非集群中java连接的url
url=jdbc:oracle:thin:@127.0.0.1:1521:bester


Oracle集群中PL/SQL连接配置:


db_1_2 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 59.208.39.193)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 59.208.39.195)(PORT = 1521))
(LOAD_BALANCE=yes)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = bester)
)
)


oracle集群中java程序连接的url
datasource.url=jdbc:oracle:thin:@(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST =59.208.39.193)(PORT = 1521))(ADDRESS = (PROTOCOL = TCP)(HOST =59.208.39.195)(PORT = 1521))(LOAD_BALANCE=yes)(CONNECT_DATA =(SERVER = DEDICATED)(SERVICE_NAME = bester)))