Skip to main content
E
EugenePipko
Inspiring
August 29, 2018
Answered

Connect CF9 to Oracle 12c

  • August 29, 2018
  • 3 replies
  • 1244 views

Hi,

I have CF9 on Windows 2003 (32 bit) and need to connect to Oracle 12c (Windows 2016 64 bit). Could someone, please let me know if it's possible and refer me to a document on how to do it.

When I try to create data source using the following, I get an error. 

Driver: other

JDBC URL: jdbc:oracle:thin:@db01:1521:APOLLO

Driver class: oracle:jdbc.OracleDriver

Thank you,

Eugene

This topic has been closed for replies.
Correct answer Charlie Arehart

EugenePipko  wrote

If I'd to upgrade to CF 2018, will I be able to access Oracle 9i?

You can answer that yourself. See the ColdFusion 2018 Support Matrix.


What that’s indicating is that CF 2018 Standard does not include JDBC drivers for Oracle. It never has. Here’s an article (from the CF “MX” or CF 6 timeframe) showing how one on CF Standard could (and would need to) obtain the Oracle Thin driver on their own and implement that:

https://helpx.adobe.com/coldfusion/kb/coldfusion-mx-configuring-oracle-jdbc-1.html

That said, the system support matrix has never shown what version of Oracle WOULD be supported if you did that. But as long as CF says it can support a given Oracle version in Enterprise with Adobe’s PROVIDED driver (which are really progress/data direct drivers), then one can reasonably presume that CF Std can connect to the same Oracle version with the thin client.

You can also read about someone else documenting this challenge and solution in 2018:

https://coldfusion.adobe.com/2018/02/coldfusion-2016-standard-and-oracle-adventures/

Let us know if that gets you going.

/charlie

3 replies

WolfShade
WolfShade
Braniac
August 29, 2018

BKBK​ confirmed what I suspected.  I think the earliest version of CF that supports 12c is CF11, then.

HTH,

^ _ ^

E
EugenePipkoAuthor
Inspiring
August 29, 2018

If I'd to upgrade to CF 2018, will I be able to access Oracle 9i?

BKBK
BKBK
Braniac
August 29, 2018

EugenePipko  wrote

If I'd to upgrade to CF 2018, will I be able to access Oracle 9i?

You can answer that yourself. See the ColdFusion 2018 Support Matrix.

BKBK
BKBK
Braniac
August 29, 2018

ColdFusion 9 reached "End of Extended Support" on December 31, 2016. So, for all practical purposes, ColdFusion 9 has been phased out. That explains why Adobe has removed its documentation from the web.

Nevertheless, you can see in the ColdFusion 10 Support Matrix, that ColdFusion 10 supports Oracle up to version 11g. You may therefore conclude that ColdFusion 9 won't probably work well with Oracle 12c.

WolfShade
WolfShade
Braniac
August 29, 2018

Oracle 12 is not supported by CF9, AFAIK.  I doubt anyone will build drivers, for it.  There _might_ be a way to connect, but I don't know.

However, what's at stake here is that you are using an old, deprecated version of CF and for at least security reasons you should consider upgrading to (at the very least) CF10.  The oWasp ESAPI should be taken advantage of.

There are others, here, who will try to convince you that you need CF2016 or CF2018.  Well, I don't know about all that, but at the very least, you need CF10, which can be acquired by the CFREPO site.

V/r,

^ _ ^

UPDATE: I cannot access the CFREPO site.  Is it down???

B
Bardnet
Inspiring
August 30, 2018

Oracle 12 is not supported by CF9, AFAIK.  I doubt anyone will build drivers, for it

Where do you see the problem? The JDBC driver depends on the JAVA engine. Oracle provides the 12c Thin Driver even for JAVA 6: https://www.oracle.com/technetwork/database/features/jdbc/jdbc-drivers-12c-download-1958347.html

Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices