例:
tnsnames.oraの内容は以下のようです
RACServer= (DESCRIPTION= (LOAD_BALANCE=ON)(FAILOVER=ON) (ADDRESS=(PROTOCOL=TCP)(HOST=192.168.13.2)(PORT=1521)) (ADDRESS=(PROTOCOL=TCP)(HOST=192.168.13.3)(PORT=1521)) (ADDRESS=(PROTOCOL=TCP)(HOST=dbserver03)(PORT=1521)) (CONNECT_DATA=(SERVICE_NAME=ORCL)) )JDBCのURLは以下のようです
Class.forName("oracle.jdbc.OracleDriver"); String jdbcUrl = "jdbc:oracle:thin:@(DESCRIPTION = (LOAD_BALANCE=ON)(FAILOVER=ON)" + "(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.13.2)(PORT = 1521))" + "(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.13.3)(PORT = 1521))" + "(ADDRESS = (PROTOCOL = TCP)(HOST = dbserver03)(PORT = 1521))" + "(CONNECT_DATA = (SERVICE_NAME = ORCL)))"; Connection con = DriverManager.getConnection(jdbcUrl, "userXXX", "passXXX");
0 件のコメント:
コメントを投稿