Skip to main content
A
Anonymous
February 17, 2012
Answered

Does Adobe provide a DataDirect JDBC upgrade path support Oracle 11g R2?

  • February 17, 2012
  • 3 replies
  • 1433 views

I've researched the forums, and apparently I'm the first one to be asking this question.  Others have asked about connecting earlier versions of ColdFusion to Oracle 11g, and I've seen that it was recommended to download JDBC drivers directly from Oracle.

We're upgrading from Oracle 9g to 11g R2, and we connect to Oracle with CF9.  The CF9 documentation states that the DataDirect drivers packaged with CF9 support Oracle 11g R1 (11.1). 

I need to find out whether that driver supports Oracle 11g R2 (Oracle 11.2) or whether I'll need to upgrade our JDBC driver?  Chances are if it supports R1, then R2 should work okay too... right?

Maybe not.  I put in a call to Data Direct, and they said we'd need to upgrade our JDBC drivers to at least v4.1 to support 11g R2.


Data Direct has released JDBC versions 4.1, 4.2 and 5.0 since the release of Adobe CF9, so I need to know whether Adobe offers an upgrade path for our JDBC drivers to a higher version or not - and I need to get this answer without having any ColdFusion support.  We shouldn't need to pay for a single incident case just to find out whether Adobe provides a JDBC upgrade path or not.


Appreciate any responses.

Thanks!

This topic has been closed for replies.
Correct answer Owainnorth

Yup, I'm sure I've done it before and it'll be fine. All it means is that it won't necessarily support new features in 11.2, but I believe most of them are administrative and syntax additions, which aren't anything to do with the driver anyway.

3 replies

A
Anonymous
February 22, 2012

Thanks for the replies.  I feel comfortable to advise our Oracle team that the light data queries from CF apps will most likely work with the existing 11g JDBC driver that comes packaged with CF9.  I will be able to confirm once they get the DEV environment finally set up.

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

Adobe doesn't provide a JDBC upgrade path. But as Owain said, the drivers will likely work. If they don't, use the drivers that Oracle provides instead.

Dave Watts, CTO, Fig Leaf Software

Dave Watts, Eidolon LLC
Owainnorth
OwainnorthCorrect answer
Inspiring
February 18, 2012

Yup, I'm sure I've done it before and it'll be fine. All it means is that it won't necessarily support new features in 11.2, but I believe most of them are administrative and syntax additions, which aren't anything to do with the driver anyway.

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