Handling multiple database server instances - failover

[Amja]

Hi all,

I have a oracle tnsentry like this. It has multiple failover instances for the
oracle database.

TESTSID =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = srvr28a.test.com)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = srvr28b.test.com)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = srvr28c.test.com)(PORT = 1521))
(LOAD_BALANCE = yes) (FAILOVER = true)
)
(CONNECT_DATA =
(SERVICE_NAME = TESTSID)
)
)


I dont know, how to configure this datasource to access from coldfusion admin.
Please advise.

Thanks,
Amjath

[Amja]

The problem here is if I want to create a dsn in coldfusion MX, it asks for SID and the server name. But here I have multiple servers how do I handle this while creating a DSN.

[philh]

Can't you create one name that represents the "cluster" to the outside world?
We have MSSQL clusters that are accessed through a virtual name, that is, the
server known as "public" doesn't really exist; it's a pointer to the cluster
set. Yet all our apps think that "public" is a living, breathing SQL server.

[Amja]

Thanks phil.

This is in oracle.
I have resolved the issue., while creating the dsn, I gave the following
information. I didnt select the oracle native driver, instead, I went to the
'other drivers' section and gave the following information.

CF Data Source Name : mycfdatasourcename
JDBC URL : jdbc:oracle:thin:@(DESCRIPTION = (DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = srvr28a.test.com)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = srvr28b.test.com)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = srvr28c.test.com)(PORT = 1521))
(LOAD_BALANCE = yes) (FAILOVER = true)
)
(CONNECT_DATA =
(SERVICE_NAME = TESTSID)
)
)
Driver Class : oracle.jdbc.OracleDriver
Driver Name : Oracle Thin Driver
username : myuser
password : ???????
Description : ANything