Copy link to clipboard
Copied
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
Copy link to clipboard
Copied
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
Copy link to clipboard
Copied
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.
Copy link to clipboard
Copied
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.
Copy link to clipboard
Copied
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.
Copy link to clipboard
Copied
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
Copy link to clipboard
Copied
Yeah - understand Adam. Once again, thank you for the assistance.
Regards,
Stevie.
Copy link to clipboard
Copied
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)!
Get ready! An upgraded Adobe Community experience is coming in January.
Learn more