Skip to main content
EugenePipko
Inspiring
Aug 29, 2018 6:00 PM UTC
Answered

Connect CF9 to Oracle 12c

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 is closed to new replies. Start a new post to keep the conversation going.
Charlie Arehart
Charlie ArehartCorrect answer
Community Expert
Aug 29, 2018 10:24 PM UTC

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

/Charlie (troubleshooter, carehart. org)
View reply

8 replies

WolfShade
WolfShade
Legend
Aug 29, 2018 7:00 PM UTC

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

HTH,

^ _ ^

Translate
EugenePipkoAuthor
Inspiring
Aug 29, 2018 7:23 PM UTC

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

Translate
BKBK
Community Expert
BKBKCommunity Expert
Community Expert
Aug 29, 2018 8:10 PM UTC

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.

Translate
BKBK
Community Expert
BKBKCommunity Expert
Community Expert
Aug 29, 2018 6:48 PM UTC

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.

Translate
WolfShade
WolfShade
Legend
Aug 29, 2018 6:27 PM UTC

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???

Translate
Bardnet
Inspiring
Aug 30, 2018 4:41 PM UTC

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

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