Can macromedia cold fusion version 7.0.0 support oracle RAC

Report · Feb 17, 2009

Hi
I try to connect to oracle RAC 10g using this macromedia cold fusion. Below are the details of my macromedia cold fusion :
Server Product ColdFusion MX
Version 7,0,0,91690
Edition Enterprise

Can it be done???
If cannot, can someone advice me how to connect to Oracle RAC 10g using macromedia CF

Report · Feb 17, 2009

amirullail wrote:
> Hi
> I try to connect to oracle RAC 10g using this macromedia cold fusion. Below
> are the details of my macromedia cold fusion :
> Server Product ColdFusion MX
> Version 7,0,0,91690
> Edition Enterprise
>
> Can it be done???

Yes.

> If cannot, can someone advice me how to connect to Oracle RAC 10g using
> macromedia CF

We'll need more information about the specific problem you're having:
http://www.catb.org/~esr/faqs/smart-questions.html#beprecise .

--
Mack

Report · Feb 19, 2009

TQ Mark for the advice. Let me detailing out the situation :

One of my application need to connect to Oracle 10.2.0.3 RAC

This is the entry that i enter in the CF Administrator :
DSN = kewangan
Driver=other
JDBC URL=jdbc:macromedia:oracle://dbl01-vip.dbp.gov.my:1521;ServiceName=orcl_taf.dbp.gov.my;AlternateServers=(dbl02-vip.dbp.gov.my:1521);ConnectionRetryCount=2;ConnectionRetryDelay=5
Driver Class = macromedia.jdbc.MacromediaDriver
Driver Name = none
user = xxx
login = xxx

tnsnames.ora in oracle client entry :
kewangan =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = dbl01-vip.dbp.gov.my)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = dbl02-vip.dbp.gov.my)(PORT = 1521))
(LOAD_BALANCE = yes)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl_taf.dbp.gov.my)
(FAILOVER_MODE =
(TYPE = SELECT)
(METHOD = BASIC)
(RETRIES = 180)
(DELAY = 5)
)
)
)

When i click the "Submit" button, its ok. I receive this message "datasource updated successfully."

So when i go to access my sistem, when i try to login, i receive this error from my browser :
Error Occurred While Processing Request
Error Executing Database Query.
[Macromedia][Oracle JDBC Driver][Oracle]ORA-12154: TNS:could not resolve the connect identifier specified