How to use tns records with macromedia drivers for Oracle

Question

We are currently forced to use macromedia drivers for ColdFusion to connect to Oracle databases. The jdbc connection url is similar:

jdbc:macromedia:oracle://server:port;sid=service

The flip side of this approach is that it forces us to “hard code” the database server name, as well as the port number and service name.

Does anyone know how the jdbc url should use the TNSNames entry?

For OCI drivers, this is jdbc:oracle:oci:@tnsentry

Is it possible to do the same with macromedia drivers? What will you be the correct URL?

+5

Jaepetto Feb 22 '12 at 20:38

1 answer

Jaepetto · Accepted Answer · 2012-05-02T15:12:49+0000

We just realized that the following syntax works:

jdbc:macromedia:oracle:TNSNamesFile=C:\\Oracle\\product\\11.2.0\\client_1\\network\\admin\\tnsnames.ora; TNSServerName=tnsentry