drill-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Charles Givre <cgi...@gmail.com>
Subject Re: SQLPad Support for Drill (JDBC)
Date Fri, 28 Dec 2018 18:38:38 GMT
HI Kunal, 
Did you run npm install before trying this out?  You may have to install the node module for
java and jdbc separately.  
—C 

> On Dec 28, 2018, at 13:26, Kunal Khatua <kunal@apache.org> wrote:
> 
> Hi Charles
> 
> Can you provide steps of where the JDBC driver needs to be located ? I managed to start
up the server but I hit a signin message: 
> Cannot GET /sqlpad/signin
> I see the following in the server output:
> [root@kk127 sqlpad]# npm start > sqlpad@2.8.0 start /root/drill/cgivre/sqlpad >
concurrently "npm run start-server-dev" "npm run start-client-dev" [0] [0] > sqlpad@2.8.0
start-server-dev /root/drill/cgivre/sqlpad [0] > node-dev server/server.js --dir ./db --port
3010 --debug --base-url '/sqlpad' [0] [1] [1] > sqlpad@2.8.0 start-client-dev /root/drill/cgivre/sqlpad
[1] > react-scripts start [1] [0] optional driver ../drivers/jdbc not available [0] optional
driver ../drivers/unixodbc not available [0] [0] NO FRONT END TEMPLATE DETECTED [0] If not
running in dev mode please report this issue. [0] [0] Loading users.. [0] Loading connections..
[0] Loading queries.. [0] Loading cache.. [0] Loading config.. [1] Starting the development
server... [1] [0] Schema is up to date (v3). [0] [0] Welcome to SQLPad!. Visit http://localhost:3010/sqlpad
to get started [0] GET /sqlpad/ 302 14.718 ms - 72 [0] GET /sqlpad/signin 404 4.511 ms - 152
[1] Compiled successfully! [1] [1] You can now view sqlpad in the browser. [1] [1] Local:
http://localhost:3000/ [1] On Your Network: http://10.10.100.127:3000/ [1] [1] Note that the
development build is not optimized. [1] To create a production build, use npm run build. [1]
[0] GET /sqlpad/ 302 2.275 ms - 72 [0] GET /sqlpad/signin 404 1.506 ms - 152 [0] GET /sqlpad/
302 1.155 ms - 72 [0] GET /sqlpad/signin 404 1.263 ms - 152
> 
> On 12/24/2018 9:09:11 AM, Charles Givre <cgivre@gmail.com> wrote:
> Hello all,
> After speaking with the developer of SQLPad and getting a little assistance, I managed
to get SQLPad to work using JDBC!
> 
> What works: You can establish a connection to Drill, execute queries, and visualize the
results.
> What’s not done: It doesn’t get the schema metadata, available tables etc. yet to
populate the drop downs. I’ll keep working on that.
> 
> Here is a link to my fork with the code:
> https://github.com/cgivre/sqlpad/tree/jdbc
> 
> Also, here is a link to my branch with the Drill Embedded integration: (No JDBC)
> https://github.com/cgivre/sqlpad/tree/drill
> 
> Thanks to Rick Bergfalk for his assistance with this. Please let me know what you think!
> — C
> 
> 
> 


Mime
View raw message