Copy link to clipboard
Copied
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!
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.
Copy link to clipboard
Copied
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.
Copy link to clipboard
Copied
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
Copy link to clipboard
Copied
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.