Skip to main content
A
Anonymous
February 22, 2012
Question

using a tns entry for a macromedia driver jdbc url

  • February 22, 2012
  • 1 reply
  • 895 views

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?

This topic has been closed for replies.

1 reply

D
Community Expert
Dave WattsCommunity Expert
Community Expert
February 22, 2012

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

Dave Watts, Eidolon LLC
A
Anonymous
February 24, 2012

Hi Dave,

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

Best,

Emmanuel

Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices