[jboss-user] [Persistence, JBoss/CMP, Hibernate, Database] - Oracle Cluster using THIN driver

[smmartins]

Hi all,

I'm using Jboss 4.0.3SP1 and Oracle JDBC Drivers 9i and 10g (on two different cases) and I need to implement a Database cluster failover on both cases. Using RAC to manage Oracle failover.

After many searches on web (including Oracle) I saw this type of usage on oracle-ds.xml:

anonymous wrote : 
  | <jndi-name>OracleDS</jndi-name> 
  | <connection-url>jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(FAILOVER=on)(ADDRESS=(PROTOCOL=TCP)(HOST=xx.xx.xx.xx1)(PORT=1521))
  | (ADDRESS=(PROTOCOL=TCP)(HOST=xx.xx.xx.xx2)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=SID)(FAILOVER_MODE=(TYPE=select)(DELAY=15)(RETRIES=20))))</connection-url> 

This seems to work fine.

Does anyone uses it and have experienced any kind of problem?

Many thanks,
Sérgio

View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3964936#3964936

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3964936