Set up Oracle Datasource in CF9 Standard Edition

[Stevie_72]

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

[Adam Cameron.]

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

[Stevie_72]

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]

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.

[Stevie_72]

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.

[Adam Cameron.]

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

[Stevie_72]

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

Regards,

Stevie.

[BKBK]

Adam Cameron. wrote:

I've not needed to do this for a while, but I am hesitant of a driver that has ODBC in the file name.

Rightly so. But there is JDBC too in the file name(ojdbc6c)!