领导给了一串连接串给我,如下:
PERAC =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 131.197.17.137)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 131.197.17.138)(PORT = 1521))
(LOAD_BALANCE = yes)
(FAILOVER = ON)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = pe)
(FAILOVER_MODE =
(TYPE = SELECT)
(METHOD = BASIC)
(RETRIES=180)
(DELAY=5)
)
)
)
要我在程序配置好这一串连接,其实很简单。只需要把上面这一串放在以前只放置一条url连接的url标签就可以了。以前配置的时候只是一个地址。现在有两个,需要用上面那一串。
配置c3p0没问题,如下:
<property name="connection.url">jdbc:oracle:thin:@(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 131.197.17.137)(PORT = 1521))(ADDRESS = (PROTOCOL = TCP)(HOST = 131.197.17.138)(PORT = 1521
PERAC =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 131.197.17.137)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 131.197.17.138)(PORT = 1521))
(LOAD_BALANCE = yes)
(FAILOVER = ON)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = pe)
(FAILOVER_MODE =
(TYPE = SELECT)
(METHOD = BASIC)
(RETRIES=180)
(DELAY=5)
)
)
)
要我在程序配置好这一串连接,其实很简单。只需要把上面这一串放在以前只放置一条url连接的url标签就可以了。以前配置的时候只是一个地址。现在有两个,需要用上面那一串。
配置c3p0没问题,如下:
<property name="connection.url">jdbc:oracle:thin:@(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 131.197.17.137)(PORT = 1521))(ADDRESS = (PROTOCOL = TCP)(HOST = 131.197.17.138)(PORT = 1521