好听新歌推荐:win2000 server 下jboss4.0连接oracle双机集群怎么配置

web server服务器为 win2000 server
中间件为jboss4.0布署在web server服务器上
oracle为10.2版本安装在小型机上(双机集群),linux系统

假设如下
=========================
小型机A IP:131.101.9.1, sid:orcla
小型机B IP:131.101.9.2, sid:orclb
对外sid为orcl
=========================
<%@page import="java.sql.*,java.util.*,java.io.*"%>
<%
String username,password,url;
Connection conn = null;
Statement stmt = null;
username="username";
password="pwd";
url ="jdbc:oracle:thin:@131.101.9.1:1521:orcl1";
Class.forName("oracle.jdbc.driver.OracleDriver");
try
{
conn=DriverManager.getConnection(url,username,password);
stmt=conn.createStatement();
}
catch(Exception ex)
{
;
}
%>
即重点在 url 要如何配置,
若写成
url = "jdbc:oracle:thin:@131.101.9.1:1521:orcl1";
或者
url = "jdbc:oracle:thin:@131.101.9.2:1521:orcl2";
都可以正确连接,但是无法找到数据库的表.
如果写成"jdbc:oracle:thin:@131.101.9.1:1521:orcl";
或者"jdbc:oracle:thin:@131.101.9.2:1521:orcl";
提示出错.