Oracle RAC question

Niraj Kumar

Anyone install TeamSite with Oracle RAC settings. Need help with connection url and driver class:

I am using below connection string, can anyone please verify if its correct or not:

connection.driver_class=oracle.jdbc.driver.OracleDriver
connection.url=jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST =(ADDRESS=(PROTOCOL=TCP)(HOST=dbSouth1)(PORT=1522))(ADDRESS=(PROTOCOL=TCP)(HOST=dbSouth2)(PORT=1522))(ADDRESS=(PROTOCOL=TCP)(HOST=dbSouth3)(PORT=1522))(FAILOVER=on)(LOAD_BALANCE=ON))(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=dbnorth1)(PORT=1522))(ADDRESS=(PROTOCOL=TCP)(HOST=dbnorth2)(PORT=1522))(ADDRESS=(PROTOCOL=TCP)(HOST=dbnorth3)(PORT=1522))(FAILOVER=on)(LOAD_BALANCE=ON))(CONNECT_TIMEOUT=30)(RETRY_COUNT=3)(RETRY_DELAY=1)(TRANSPORT_CONNECT_TIMEOUT=30)(CONNECT_DATA = (SERVER=DEDICATED) (REGION=south)(SERVICE_NAME =hostname.ssi.govt.nz)))

TIA,

Niraj

David Smith

Not sure if you got this working or not, but that connection string looks fine if that's what your tnsnames entry looks like. Your driver class looks good also. Did you also enter a correct jdbc driver class in that field? That's important.