I have found that re-starting the entire J2EE container (Tomcat, Jetty, etc) is an important step when making major changes to OpenBD config.
Hope this helps, AH

On 8/5/2016 6:37 AM, Riccardo Cecinati wrote:
hello Mark,
the jdbc-all driver is the one that I can have recognized, but gives me the Verify error "Could not verify datasource using driver org.apache.drill.jdbc.Driver: org.slf4j.helpers.MessageFormatter.format(Ljava/lang/String;Ljava/lang/Object;)Ljava/lang/String;"
If I drop instead in WEBINF/lib the file drill-jdbc-1.x.x.jar file , the error I get is of missing library :
"Could not register database driver org.apache.drill.jdbc.Driver. please make sure the driver is in your classpath".
If I use both, the one that's picked is drill-jdbc-1.x.x.jar

I have verified (jar -tf drill.jdbc....jar) that both jars have  the org.apache.drill.jdbc.Driver.class inside.
I have also tried to point to either jar file through my bluedragon.xml , in section
<libpath>my.path.to.the jar.i.am.pointing</libpath>
but with no luck.
I am considering to abandone openbluedragon in favor of Adobe Colodfusion.. I hope to find some deeper detail about linking libraries
Thank you everybody fo helpping

Riccardo

Il giorno venerdì 27 maggio 2016 04:13:26 UTC+2, mark ha scritto:
I think you need to use the "jdbc-all" driver for Apache Drill.

On Wednesday, May 25, 2016 at 1:56:26 PM UTC-5, Riccardo Cecinati wrote:
Hello,
I have an application written in CF running in OBD over a MySQL engine.
I want to interface it to a "big data" engine such as Apache Drill, through its JDBC driver. My goal is to extend my number crunching capabilities over a cluster of parallel machines.
I cannot get the OBD administrator register my new datasource. I have managed to load the JDBC driver (the one that Apache Drill natively provides), but the verification stage always fails :
Could not verify datasource using driver org.apache.drill.jdbc.Driver: org.slf4j.helpers.MessageFormatter.format(Ljava/lang/String;Ljava/lang/Object;)Ljava/lang/String;

What I'd actually need is some deepeer detail in logging. I have been looking around in bluedragon.log , but no clue is found.
I am aware I'm running in a no one's land between two open source realms, Open Blue Dragon and Apache Drill. The help I'm searching for here is how to pinpoint the problem to understand on which side the issue is.

I'd really appreciate any help.

Riccardo
--
--
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 [email protected].
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 [email protected].
For more options, visit https://groups.google.com/d/optout.

Reply via email to