Oracle 多个连接池

String userid = "system";
String password = "ABCabc123";
String tnsnames_info = "(DESCRIPTION=(ADDRESS_LIST="
+ "(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.0.15)(PORT=1521))"
+ "(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.0.16)(PORT=1521))"
+ "(LOAD_BALANCE=yes)(FAILOVER=on))"
+ "(CONNECT_DATA=(SERVICE_NAME=orcl)))";

String url = "jdbc:oracle:thin:@" + tnsnames_info;

DriverManager.registerDriver(new oracle.jdbc.OracleDriver());
Connection dbConnection = DriverManager.getConnection(url, userid,password);
Statement stmt = dbConnection.createStatement();
ResultSet rset = stmt.executeQuery(" select instance_name from v$instance");

while (rset.next())
{
System.out.println(rset.getString(1));
}