Hi there,

I am having an issue with the OpenJMS v 0.7.5 RC1 used in a third technology. This issue is related to getting a JMS connection to Oracle 11g RAC through JDBC.

When I set the openJMS to connect to Oracle 11g without cluster configuration I don’t have any problems, but when I set the cluster configuration using the LOAD_BALANCE and/or FAILOVER features I couldn’t get any connection. The database cluster configuration is set in the openjms.xml configuration file:

<DatabaseConfiguration>
        <RdbmsDatabaseConfiguration
      driver="oracle.jdbc.driver.OracleDriver"   url="jdbc:oracle:thin:@(DESCRIPTION=(FAILOVER=on)(LOAD_BALANCE=yes)(ADDRESS=(PROTOCOL=TCP)(HOST=host01-vip.com)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=
host02-vip.com)(PORT=1521))(CONNECT_DATA=(service_name=JBORAP02)))"
        user="virageuser"

password="password" />

</DatabaseConfiguration>

And the error description in the open jms log, is:

INFO   | jvm 1    | 2010/05/04 16:27:41 | org.exolab.jms.server.ServerException: org.exolab.jms.persistence.PersistenceException: java.sql.SQLException: Exceção de E/S: Connection refused(DESCRIPTION=(ERR=1153)(VSNNUM=185599488)(ERROR_STACK=(ERROR=(CODE=1153)(EMFI=4)(ARGS='(ADDRESS=(PROTOCOL=TCP)(HOST=host02)(PORT=1521))'))(ERROR=(CODE=305)(EMFI=1))))

 

I googled this error without success, any suggestions is really appreciated.

Thanks

Erick J. Delgado Ramirez