Set up Oracle Datasource in CF9 Standard Edition

Forum|Forum|13 years ago
December 19, 2012
1 reply
1948 views

Hello all,

My 1st post so please be kind.

I am trying to set up a datasource in my CF Admin console to an Oracle Database. Oracle does not appear as a Drive type in my dropdown list. Now I did read on the forum (see I did have a look before posting) that the oracle Driver does not come with the Std edition. So I have installed the Oracle Client, and under Java and JVM put a CF Calss Path pointing to the ojdbc6c.jar file.

I have read other bits and bobs on the net that you can use the "Other" datasource to connect to oracle but I get "No Suitable Driver" error messages when I try that.

So just looking for help to make Oracle appear as a Driver I can select, or how to correctly configure "Other" to make it work.

Many thanks.

Regards,

Stevie

This topic has been closed for replies.

A

Adam Cameron.

Inspiring

I've not needed to do this for a while, but I am hesitant of a driver that has ODBC in the file name. You'd not want to use ODBC if you can avoid it. Is there no straight JDBC driver you can use?

--

Adam

S

Stevie_72Author

Inspiring

Hi Adam thanks for the reply,

To be honest I am winging it, but I have managed to get a step further. I just read a post where someone copied the oracle .jar file to wwwroot\WEB-INF\lib

I now have a network connection error, but at least the driver is working...I think. Would still like to make it appear as a selection in the dropdown list though.

S

Stevie_72Author

Inspiring

You won't get Oracle as an available data source type. Adding the jar into the classpath simply allows you to use it as a driver when creating an "Other" data source. Think about it: CFAdmin doesn't know to sniff around on the class path to identify DB drivers and then somehow work out how to present a create/edit DSN screen for some driver that all it has is a jar for.

--

Adam

Yeah - understand Adam. Once again, thank you for the assistance.

Regards,

Stevie.

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded