CF11 connection with Oracle RAC

Hi NAF, did you find solution for this issue. Even we are facing the same with coldfusion 10 trying to connect to Oracle 11g.

where data source is connecting to database server. but failover is not working.

please help.

Datasource > Other

with JDBC URL:

jdbc:macromedia:oracle://(ORACLE SERVER):1521;SERVICENAME=(serviceName);sendStringParametersAsUnicode=false;MaxPooledStatements=1000;AlternateServers=(IP ADDRESS1),(IP address 2))

where I got (ORACLE SERVER); (serviceName);(IP ADDRESS1),(IP address 2) all of the needed actually data from the tnsnames.ora file

Driver Class: macromedia.jdbc.MacromediaDriver

other stuff like driver name and user name and password are the same as you used before.

I hope that helps