Copy link to clipboard
Copied
Hello,
Has anyone tried connecting a CF 2018 application to an Oracle 19c database? It doesn't list 19c as being compatible in the support matrix, but was hoping they're still compatible.
Thank you.
Copy link to clipboard
Copied
We have the same question. We are very interested in more information about using ColdFusion2018 and Oracle 19c.
Thank you.
Copy link to clipboard
Copied
will let you know as we are upgrading from 11g to 19c next Wednesday, April 29th.
the caveat is that we are still using CF 10 😞
Copy link to clipboard
Copied
corestaples,
How did the upgrade go? Did CF work?
Copy link to clipboard
Copied
Team, I am also looking to upgrade to CF 2018 V5 in couple of months and looking to see if anyone is currently using with 19C? Per Matrix definately shows 18c.
Thank You
Jose
Copy link to clipboard
Copied
yes it did even with CF10
Copy link to clipboard
Copied
We should distinguish "does it work" from "is it supported?", which is indeed what's being asked by most above. As for "newbie" referring to CF10, to be clear it NEVER supported Oracle 19c, which came out in 2019, since CF10 was last updated in 2017. But you may referring to corestabples' comment above, as they were going to try it, but never reported how it went.
And as for CF2018, it STILL does NOT FORMALLY support 19c.
That said, when Adobe speaks of what DB version CF "supports", it's nearly always referring to the provided JDBC drivers. Those come from a 3rd party, so Adobe is beholden to them for updates (and then Adobe has to do integration testing before releasing it with CF).
But FWIW, one is allow to add their OWN JDBC drivers, and there IS an available JDBC driver from Oracle for 19c. One would download it, put its JAR into the cfusion/lib folder (for a cfusion instance), then implement an "other driver" in the CF Admin DSN page, where you would enter a JDBC URL and driver class name (both obtained from the docs on that downloaded driver).
Adobe never formally certifies if any such "other drivers" work nor are they "supported". But my point is that clearly an Oracle 19c driver would work with 19c, and so should be expected to work with CF2018.
Perhaps we will see 19c support in CF2020, or in some later update to CF2018 (that does happen).
Copy link to clipboard
Copied
In case anyone finds this thread in the future, I can report that CF2018 update 11 (Mar 2021) added support for 19c. For more, see:
https://helpx.adobe.com/coldfusion/kb/coldfusion-2018-update-11.html
And FWIW, the 19c support was added also to CF2021 in its update 1, released the same day. To be clear, CF2016 did NOT get 19c support in its update 17 that was also released that day--and it was the last update for CF2016, so bottom line: CF2016 will never have formal support for 19c.