Hi
My DBA is going to upgrade our current Oracle from 12c Release 1 to Release 2. For the datasource of my app I have been using JDBC (oracle.jdbc.OracleDriver) to connect to Oracle and it has been working fine. Does anyone know if Release 2 will have any negative impact on CF 2016? Thanks.
Nathan
Newbie
1 posts
Thank you, Charlie and Bernhard.
After the upgrade (from R1 to R2 on Oracle) on my dev server I had the server admin installed 12.2.0 client and my CF data source worked. I did see there is a “ojdbc8.jar” file in the new client directory (\client_1\jdbc\lib\). The old client directory contains “ojdbc7.jar”. I wonder if the new jdbc makes it work?
Glad things are working.
As for your question, if that jar is not in a CF folder, or its location is not pointed to by the cf classpath (in admin), then it would not seem to be affecting cf, no.
The digit is the JAVA version required to use this JAR because support for different JDBC versions is implemented.
In CFAdmin under “JAVA and JVM” you can check if the jar file is found.
Hi Bernhard,
Thank you. Since I am not familiar with CF Admin, my next question might sound very dump. I see “C:\ColdFusion2016\jre” in Java Virtual Machine Path and the ColdFusion Class Path is blank. Does it mean I need to make a copy of the jdbc8 files and copy them from this “C:\app64\client\product\12.2.0\client_1\jdbc\lib\” location to this location “C:\ColdFusion2016\jre\bin”?
ojdbc8.jar
ojdbc8_g.jar
ojdbc8dms.jar
ojdbc8dms_g.jar
simplefan.jar
Thanks.
The driver may not support all database features optimally. However, I know of no incompatibilites. To be save, you can use Oracle’s own JDBC driver from https://www.oracle.com/technetwork/database/application-development/jdbc/downloads/index.html
The support matrix for CF2016 shows that CF supports 12c, and 11g r2, but not 12c r2: https://helpx.adobe.com/pdf/coldfusion2016-support-matrix.pdf
That said, since you are using your own Oracle JDBC driver, the question is more whether THAT driver suppors 12c r2. If it does, or if you update to a version of that driver that does and put that into CF (to take the place of the old oracle driver you or someone put there), then it should work. But again it’s not FORMALLY supported.
You may want to see if anyone chimes in to confirm if it worked for them, if they see your questions’s title.
You must be logged in to post a comment.
23 Nov
10AM Pacific
Online
