Hi all,

Any body please tell me the step by step process to connect to RAC(oracle 11g) through hibernate.
I am also using DBCP connection pool.

Thanks in Advance.

In our JBoss-Datasource:

<connection-url>jdbc:oracle:thin:@(description=(address_list=(address=(host=xx-db1)(protocol=tcp)(port=1521))(address=(host=xx-db2)(protocol=tcp)(port=1521))(load_balance=yes)(failover=yes))(connect_data=(service_name=XX.YY.ZZ)))</connection-url>

Dear CDillinger.

Thanks for your reply.

In hibernate configuration file i modified mu url like below
<property name="connection.url">jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=host1)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=host2)(PORT=1521)))(LOAD_BALANCE=yes)(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=orcl)))</property>

So i can able to create session.
But when i am trying to begin transaction it throwing an exception like "can not open connection".

But at the same time my sample jdbc program is working fine with the above url pattern with out using hibernate.