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.

BKBK
Community Expert
BKBKCommunity Expert
Community Expert
December 27, 2012

Stevie 72 wrote:

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.

It may work in that location, however the natural home for database drivers is {CF_INSTALLATION}\lib\. Think of modifying classpath settings after you make the change. That may solve the network connection problem, who knows.

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