It is important to note that Drill doesn't come prepackaged with any JDBC drivers. As such, you'll need to copy your desired JDBC driver to the jars/3rdparty path (or alternatively adding your path to the Drill startup classpath).
-- Jacques Nadeau CTO and Co-Founder, Dremio On Sun, Oct 18, 2015 at 9:37 AM, Kristine Hahn <[email protected]> wrote: > Nope, no luck. Must be my J connector setup. I'll try something like > exporting a CLASSPATH. > > My Drill 1.2 (tar downloaded from the Apache site yesterday) setup checks > out ok for creating a storage plugin config from REST API: > > Administratots-MacBook-Pro:apache-drill-1.2.0 khahn$ curl -X POST -H > "Content-Tpe: application/json" -d '{"name":"myplugin3", "config": {"type": > "file", "enabled": false, "connection": "file:///", "workspaces": { "root": > { "location": "/", "writable": false, "defaultInputFormat": null}}, > "formats": null}}' http://localhost:8047/storage/myplugin3.json > > { > > "result" : "success" > > Administratots-MacBook-Pro:apache-drill-1.2.0 khahn$ curl --request POST > --hader "Content-Type: application/json" --data '{"name": "myplugin4", > "config": { "type": "jdbc", "enabled": false, "driver": > "com.mysql.jdbc.Driver", "url": "jdbc:mysql://localhost:3306;" }}' > http://localhost:8047/storage/myplugin4.json > > { > > "result" : "error (unable to create/ update storage)" > > } > > Kristine Hahn > Sr. Technical Writer > 415-497-8107 @krishahn skype:krishahn > > > On Sun, Oct 18, 2015 at 9:12 AM, Rajkumar Singh <[email protected]> > wrote: > > > Could you please try with this curl request > > > > curl --request POST --header "Content-Type: application/json" > > --data '{"name": "myplugin", "config": { "type": "jdbc", > > "enabled": false, "driver": "com.mysql.jdbc.Driver", "url": > > "jdbc:mysql://localhost:3306;" }}' > > http://localhost:8047/storage/myplugin.json > > > > > On 18-Oct-2015, at 9:16 PM, Kristine Hahn <[email protected]> wrote: > > > > > > curl -X POST -H "Content-Tpe: application/json" -d '{"name":"myplugin", > > > "config": {"type": "jdbc", "enabled": false, > > > "driver":"com.mysql.jdbc.Driver", > "url":"jdbc:mysql://localhost:3306;"}}' > > > http://localhost:8047/storage/myplugin.json < > > http://localhost:8047/storage/myplugin.json> > > >
