37bidwb =
(DESCRIPTION =
(ADDRESS_LIST=
(ADDRESS= (PROTOCOL = TCP)(HOST = 10.87.25.37)(PORT = 1521))
(ADDRESS= (PROTOCOL = TCP)(HOST = 10.87.25.38)(PORT = 1521))
(ADDRESS= (PROTOCOL = TCP)(HOST = 10.87.25.39)(PORT = 1521))
(FAILOVER = on)
(LOAD_BALANCE = off)
)
(CONNECT_DATA= (SERVICE_NAME = bidwb))
)
37bidwb =
(DESCRIPTION =
(ADDRESS_LIST=
(ADDRESS= (PROTOCOL = TCP)(HOST = 10.87.25.38)(PORT = 1521))
(ADDRESS= (PROTOCOL = TCP)(HOST = 10.87.25.39)(PORT = 1521))
(ADDRESS= (PROTOCOL = TCP)(HOST = 10.87.25.37)(PORT = 1521))
(FAILOVER = on)
(LOAD_BALANCE =off)
)
(CONNECT_DATA= (SERVICE_NAME = bidwb))
)
37bidwb =
(DESCRIPTION =
(ADDRESS_LIST=
(ADDRESS= (PROTOCOL = TCP)(HOST = 10.87.25.39)(PORT = 1521))
(ADDRESS= (PROTOCOL = TCP)(HOST = 10.87.25.37)(PORT = 1521))
(ADDRESS= (PROTOCOL = TCP)(HOST = 10.87.25.38)(PORT = 1521))
(FAILOVER = on)
(LOAD_BALANCE = off)
)
(CONNECT_DATA= (SERVICE_NAME =bidwb))
)
jdbc连接oracle的连接串如下:
String url="jdbc:oracle:thin:@(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = host2)(PORT = 1521))(ADDRESS = (PROTOCOL = TCP)(HOST = host1)(PORT = 1521))(LOAD_BALANCE = yes)(FAILOVER = ON)(CONNECT_DATA =(SERVER = DEDICATED)(SERVICE_NAME = db.domain)(FAILOVER_MODE=(TYPE = SELECT)(METHOD = BASIC)(RETIRES = 20)(DELAY = 15))))";
java测试程序如下:
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;public class Test {
public static void main(String arg[]) {
try {
Class.forName("oracle.jdbc.driver.OracleDriver");
String url="jdbc:oracle:thin:@(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = host1)(PORT = 1521))(ADDRESS = (PROTOCOL = TCP)(HOST = host2)(PORT = 1521))(LOAD_BALANCE = yes)(FAILOVER = ON)(CONNECT_DATA =(SERVER = DEDICATED)(SERVICE_NAME = db.domain)(FAILOVER_MODE=(TYPE = SELECT)(METHOD = BASIC)(RETIRES = 20)(DELAY = 15))))";
Connection c = DriverManager.getConnection(url,"aa","aa");
Statement s = c.createStatement();
ResultSet r = s.executeQuery("select 1 from dual");
while(r.next()) {
System.out.println(r.getString(1));
}
}catch(Exception e) {
System.out.println(e.toString());
}
}}