ColdFusion 2016 and Oracle 12c Release2

April 19, 2019
Newbie 1 posts
Followers: 0 people
6

ColdFusion 2016 and Oracle 12c Release2

Newbie 1 posts
Followers: 0 people
April 19, 2019

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

Comments (6)
2019-04-26 16:56:53
2019-04-26 16:56:53

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?

Like
(3)
>
nc777
's comment
2019-04-26 21:56:48
2019-04-26 21:56:48
>
nc777
's comment

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.

Like
>
nc777
's comment
2019-04-28 13:11:57
2019-04-28 13:11:57
>
nc777
's comment

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.

Like
>
Bernhard Döbler
's comment
2019-04-29 02:55:20
2019-04-29 02:55:20
>
Bernhard Döbler
's comment

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.

 

Like
2019-04-25 21:33:28
2019-04-25 21:33:28

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

Like
2019-04-25 18:10:37
2019-04-25 18:10:37

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.

Like
(1)
Add your comment