search

OpenBD / openbd-administrator

The browser based administrator for the Open BlueDragon CFML engine.
http://openbd.org/
12 stars 10 forks source link

Verify Datasource(s) #27

Open MatsStromberg opened 11 years ago

MatsStromberg commented 11 years ago

The Verify of a datasource does not work any more... Nightlybuild after v2.0.2

No such function exists - cachedeleteall.

Request /bluedragon/administrator/settings/_controller.cfm

File Trace /opt/OpenBD/webapps/openbd/bluedragon/administrator/settings/_controller.cfm | +-- /opt/OpenBD/webapps/openbd/bluedragon/adminapi/Caching.cfc

MatsStromberg commented 8 years ago

This issue still exist when it comes to verifying an Oracle Database. At the moment I don't have any other DB (like MySQL) setup to test if it's only hitting Oracle... But I suppose so. Best Solution for target type Oracle would be to add a field for servicename (below the SID). If this field would be filled should be using this rather than the SID. dsinfo.servicename = ""; needs to be added to the _controller.cfm

driverManager = CreateObject("java", "java.sql.DriverManager") I don't know how the DriverManager is able of handling this in the case of using a servicename rather than the SID. Normally the ojdbc will be using host:port/servicename rather than host:port:sid I know too little about the DriverManager so maybe one simply need to use the normal OpenBD way to define the connectionwhen it comes to Oracle...

This also means that the bluedragon.xml will have an extra servicename field for an Oracle datasource, used or not..