Skip to main content
S
Stevie_72
Inspiring
December 19, 2012
Question

Set up Oracle Datasource in CF9 Standard Edition

  • 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.

1 reply

A
Adam Cameron.
Inspiring
December 19, 2012

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
December 19, 2012

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.

A
Adam Cameron.
Inspiring
December 28, 2012

Hi BKBK,

I have copied my ojdbc6.jar file to the correct location and modified the class path, restared the CF Server, no success. I do think the driver is working correctly, the oracle database I am trying to connect to is on another part of the network that is in a diffetent domain so the network error message is prob correct and I have firewall issues to work through. Still don't have ORACLE as an available datasource to select from though . But you can't have it all.

Thanks for the assistance.

Rgds,

Stevie.


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

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