Oracle 10g RAC on CF7

[Kieron]

Hi,

Has anyone been able to get this config working? i've got 2 CF7 servers in a
cluser, each are currently pointing to 2 different Oracle RAC servers, this is
OK for pseudo load balancing but isn't for failover.

I noted the new DataDirect JDBC 3.5 drivers
([url]http://www.adobe.com/cfusion/knowledgebase/index.cfm?id=42dcb10a[/url]) appear to
work with 10g RAC but arn't supported but i'm unsure how to configure the
'Other' drivers as mentioned in the link, the instructions don't provide
enought information.

Has anyone got this working and could let me know what I have to enter in the
'Other' drivers config to make it work?

Thanks in advance,
Kieron

[qtpattuti]

JDBC URL: jdbc:macromedia:oracle://Server1:1521;serviceName=ORCL;
Driver class: macromedia.jdbc.MacromediaDriver
Driver name: DataDirect 3.5

You'll obviously need to adjust that jdbc url to match your db's connection
info. When we were using the RAC (switched to 10gR2), the dba set up a tns
configuration w/ failover utilizing both db servers so we could just point to a
single jdbc url.

[Kieron]

Excellent, that got it working.

Many thanks qtpattuti.

Kieron