After I did changed the connection string as follows:
conStr="jdbc:oracle:thin:@" +
"(DESCRIPTION =(SOURCE_ROUTE=ON)(ADDRESS_LIST = " +
"(ADDRESS = (PROTOCOL = TCP)(HOST = web server ip)(PORT = 1630))" +
"(ADDRESS = (PROTOCOL = TCP)(HOST = oracle server ip)(PORT = 1521)))"+
"(CONNECT_DATA = (SERVICE_NAME = ORCL.COM)))";
Connection conn=DriverManager.getConnection(conStr, "test","password");
However, I am still having problem with the "Connection Refused" message.
exception: Connection refused
java.sql.SQLException: Connection refused
at oracle.jdbc.dbaccess.DBError.check_error(DBError.java:406)
at oracle.jdbc.driver.OracleConnection.<init>(OracleConnection.java:169)
at
oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java:231)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:208)
at java.sql.DriverManager.getConnection(Compiled Code)
at java.sql.DriverManager.getConnection(DriverManager.java:137)
...
Anybody with good ideas would be appreciated.
Thanks.