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.
We have the same question. We are very interested in more information about using ColdFusion2018 and Oracle 19c.
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 😞
How did the upgrade go? Did CF work?
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.
yes it did even with CF10
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).