Hello All,
We are using Coldfusion 2018 and Oracle 12c with thirdparty JDBC drivers for our production environment. Some of our reports are failing with an error which states "Invalid column name or table name"
I don't think there is any problem with the Table or the column name, the reason I say this is, because the same code works fine from another server where there is a Developer version of coldfusion 2018 and an Oracle Driver is available from coldfusion. In our production setup we are using Standard version of ColdFusion 2018 and so the JDBC connection string has its limitations. To prove my point I copied over the same application files from Standard version of ColdFusion 2018 to the other server with the Developer version of coldfusion 2018, the same code and the same files work perfectly fine from there with the same database at the backend.
So the main culprit here is the fact that there is no Oracle Driver available in ColdFusion 2018 standard version. JDBC connectivity requires JDBC drivers, Does Oracle recommend or provide JDBC drivers to work with Coldfusion 2018 ? If yes can someone please send me the URL to download these drivers.
I appreciate each one of you and thank you all in advance for sparing your precious time to help me with this issue. Thank you all. Please get back to me on this one as this is taking a lot of time to resolve and our users are waiting impatiently.
Regards
IQ