using a tns entry for a macromedia driver jdbc url

[Guest]

We are currently forced to use macromedia drivers on ColdFusion in order to connect to Oracle databases. The jdbc connection url is like:

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

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

Does anyone know how the jdbc url should be to make use of the TNSNames entry?

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

Is it possible to do the same with macromedia drivers? what you be the correct url?

[Dave Watts]

I don't know. I would recommend looking at the DataDirect Connect for JDBC documentation, which should be available on the DataDirect Technologies site. The drivers included with CF are a bundled version of DataDirect Connect for JDBC.

Dave Watts, CTO, Fig Leaf Software

[Guest]

Hi Dave,

Thanks for your answer. I'll look into it ASAP.

Best,

Emmanuel