Re: [OpenBD] OpenBD Administrator failing at verifying Oracle Datasources

['Alan Holden' via Open BlueDragon]

The OpenBD Administrator was a separate project (a gift from Matt Woodward as I recall), I don't think it was built by the same AW2.0 clan. A quick search implies that it even has it's own repo and google group, both look a bit dusty. Al Holden On 1/7/2016 1:47 AM, Mats Stromberg wrote: Hi All, Also in the newest version of the Administrator the verify function fails when an Oracle datasource is defined and CFCATCH returns General Runtime Error. I simply can't figure out what's going wrong with the driverManager when it comes to Oracle DB's. Maybe this should be changed for type Oracle when one comes to the second part of the creation of the datasource. The target DB could be a RAC and you need to connect using a scan address and for all a service name instead of the SID jdbc:oracle:thin:host:port/servicename instad of jdbc:oracle:thin:host:port:sid Just as info... it fails also when it is just a host:port:sid I'm just not "smart" enough to figure out if this driverManager is intelligent enough with some extra argument to change the way it sees and uses a SID or a servicename Anyway, the 2nd screen of the creation of Datasource when it comes to Oracle would need one more field for the servicename. So question is... have anyone already fixed a workaround for this? It would be a bit ugly to solve Oracle connects with the OpenBD way to create the connection string but maybe that's the only solution?? and I suppose we're not allowed to "distribute" the "correct" oracle driver  ojdbc7.jar  as the ojdbc14.jar is not really usable since some years back :) /Mats/ -- -- online documentation: http://openbd.org/manual/ http://groups.google.com/group/openbd?hl=en --- You received this message because you are subscribed to the Google Groups "Open BlueDragon" group. To unsubscribe from this group and stop receiving emails from it, send an email to openbd+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout. -- -- online documentation: http://openbd.org/manual/ http://groups.google.com/group/openbd?hl=en --- You received this message because you are subscribed to the Google Groups "Open BlueDragon" group. To unsubscribe from this group and stop receiving emails from it, send an email to openbd+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.