Hello,

I’m evaluating ignite and I need a free tool to see the tables and cache 
content.
What is the best free tool to query the cache via SQL? Something like dBeaver 
or anything else that works.

Thanks for your help

w

From: Wilhelm Thomas <wilhelm.tho...@anaplan.com>
Reply-To: "user@ignite.apache.org" <user@ignite.apache.org>
Date: Tuesday, March 6, 2018 at 9:51 AM
To: "user@ignite.apache.org" <user@ignite.apache.org>
Subject: Ignite with dBeaver

Hello,

I’m trying to connect to the ignite cache via dBeaver.
It seems to connect (client ui display a green signal) but I see the following 
error on the screen of the server




 [00:44:26] Unknown connection detected (is some other software connecting to 
this Ignite port? missing SSL configuration on remote node?) 
[rmtAddr=/192.168.99.1]

ignite                 | [00:46:21,014][SEVERE][rest-#715][GridTaskWorker] 
Failed to map task jobs to nodes due to undeclared user exception [cause=null, 
ses=GridTaskSessionImpl 
[taskName=o.a.i.i.processors.cache.query.jdbc.GridCacheQueryJdbcMetadataTask, 
dep=GridDeployment [ts=1520280083605, depMode=SHARED, 
clsLdr=sun.misc.Launcher$AppClassLoader@764c12b6, 
clsLdrId=538e0c7f161-70aadfdd-e9ef-48a6-81b8-454b5bec4358, userVer=0, loc=true, 
sampleClsName=o.a.i.i.processors.cache.GridCacheProcessor$RemovedItemsCleanupTask$1,
 pendingUndeploy=false, undeployed=false, usage=1], 
taskClsName=o.a.i.i.processors.cache.query.jdbc.GridCacheQueryJdbcMetadataTask, 
sesId=52931c7f161-70aadfdd-e9ef-48a6-81b8-454b5bec4358, 
startTime=1520297181004, endTime=9223372036854775807, 
taskNodeId=70aadfdd-e9ef-48a6-81b8-454b5bec4358, 
clsLdr=sun.misc.Launcher$AppClassLoader@764c12b6, closed=false, cpSpi=null, 
failSpi=null, loadSpi=null, usage=1, fullSup=false, internal=false, 
subjId=70aadfdd-e9ef-48a6-81b8-454b5bec4358, mapFut=IgniteFuture 
[orig=GridFutureAdapter [ignoreInterrupts=false, state=INIT, res=null, 
hash=252995608]], execName=null]]

ignite                 | java.lang.NullPointerException





Then when try to ask for the “tables” I see the following the server



 [00:49:19,639][SEVERE][rest-#740][GridTaskCommandHandler] Failed to execute 
task [name=o.a.i.i.processors.cache.query.jdbc.GridCacheQueryJdbcMetadataTask, 
clientId=e8e8b2ef-cbd6-4986-a889-b150e4fe297d]

ignite                 | class org.apache.ignite.IgniteCheckedException: null

ignite                 |    at 
org.apache.ignite.internal.util.IgniteUtils.cast(IgniteUtils.java:7252)

ignite                 |    at 
org.apache.ignite.internal.util.future.GridFutureAdapter.resolve(GridFutureAdapter.java:259)

ignite                 |    at 
org.apache.ignite.internal.util.future.GridFutureAdapter.get0(GridFutureAdapter.java:171)

ignite                 |    at 
org.apache.ignite.internal.util.future.GridFutureAdapter.get(GridFutureAdapter.java:140)

ignite                 |    at 
org.apache.ignite.internal.processors.rest.handlers.task.GridTaskCommandHandler$2.apply(GridTaskCommandHandler.java:263)

ignite                 |    at 
org.apache.ignite.internal.processors.rest.handlers.task.GridTaskCommandHandler$2.apply(GridTaskCommandHandler.java:257)

ignite                 |    at 
org.apache.ignite.internal.util.future.GridFutureAdapter.notifyListener(GridFutureAdapter.java:383)

ignite                 |    at 
org.apache.ignite.internal.util.future.GridFutureAdapter.listen(GridFutureAdapter.java:353)

ignite                 |    at 
org.apache.ignite.internal.processors.rest.handlers.task.GridTaskCommandHandler.handleAsyncUnsafe(GridTaskCommandHandler.java:257)

ignite                 |    at 
org.apache.ignite.internal.processors.rest.handlers.task.GridTaskCommandHandler.handleAsync(GridTaskCommandHandler.java:163)

ignite                 |    at 
org.apache.ignite.internal.processors.rest.GridRestProcessor.handleRequest(GridRestProcessor.java:266)

ignite                 |    at 
org.apache.ignite.internal.processors.rest.GridRestProcessor.access$100(GridRestProcessor.java:89)

ignite                 |    at 
org.apache.ignite.internal.processors.rest.GridRestProcessor$2.body(GridRestProcessor.java:155)

ignite                 |    at 
org.apache.ignite.internal.util.worker.GridWorker.run(GridWorker.java:110)

ignite                 |    at 
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)

ignite                 |    at 
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)

ignite                 |    at java.lang.Thread.run(Thread.java:748)

ignite                 | Caused by: java.lang.NullPointerException

ignite                 | [00:49:19,640][SEVERE][rest-#740][GridRestProcessor] 
Failed to handle request: EXE

ignite                 | class org.apache.ignite.IgniteCheckedException: null

ignite                 |    at 
org.apache.ignite.internal.util.IgniteUtils.cast(IgniteUtils.java:7252)

ignite                 |    at 
org.apache.ignite.internal.util.future.GridFutureAdapter.resolve(GridFutureAdapter.java:259)

ignite                 |    at 
org.apache.ignite.internal.util.future.GridFutureAdapter.get0(GridFutureAdapter.java:171)

ignite                 |    at 
org.apache.ignite.internal.util.future.GridFutureAdapter.get(GridFutureAdapter.java:140)

ignite                 |    at 
org.apache.ignite.internal.processors.rest.handlers.task.GridTaskCommandHandler$2.apply(GridTaskCommandHandler.java:263)

ignite                 |    at 
org.apache.ignite.internal.processors.rest.handlers.task.GridTaskCommandHandler$2.apply(GridTaskCommandHandler.java:257)

ignite                 |    at 
org.apache.ignite.internal.util.future.GridFutureAdapter.notifyListener(GridFutureAdapter.java:383)

ignite                 |    at 
org.apache.ignite.internal.util.future.GridFutureAdapter.listen(GridFutureAdapter.java:353)

ignite                 |    at 
org.apache.ignite.internal.processors.rest.handlers.task.GridTaskCommandHandler.handleAsyncUnsafe(GridTaskCommandHandler.java:257)

ignite                 |    at 
org.apache.ignite.internal.processors.rest.handlers.task.GridTaskCommandHandler.handleAsync(GridTaskCommandHandler.java:163)

ignite                 |    at 
org.apache.ignite.internal.processors.rest.GridRestProcessor.handleRequest(GridRestProcessor.java:266)

ignite                 |    at 
org.apache.ignite.internal.processors.rest.GridRestProcessor.access$100(GridRestProcessor.java:89)

ignite                 |    at 
org.apache.ignite.internal.processors.rest.GridRestProcessor$2.body(GridRestProcessor.java:155)

ignite                 |    at 
org.apache.ignite.internal.util.worker.GridWorker.run(GridWorker.java:110)

ignite                 |    at 
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)

ignite                 |    at 
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)

ignite                 |    at java.lang.Thread.run(Thread.java:748)

ignite                 | Caused by: java.lang.NullPointerException

and the client display this: SQL Error: Failed to get the metadata from ignite.


SQL Error: Failed to get meta data from Ignite.
  SQL Error: Failed to get meta data from Ignite.
    Failed to get meta data from Ignite.
      Failed to handle request: [req=EXE, 
taskName=org.apache.ignite.internal.processors.cache.query.jdbc.GridCacheQueryJdbcMetadataTask,
 params=[null], err=org.apache.ignite.IgniteCheckedException]
      Failed to handle request: [req=EXE, 
taskName=org.apache.ignite.internal.processors.cache.query.jdbc.GridCacheQueryJdbcMetadataTask,
 params=[null], err=org.apache.ignite.IgniteCheckedException]


Note: I followed the instruction from 
https://apacheignite.readme.io/docs/sql-tooling<https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fapacheignite.readme.io%2Fdocs%2Fsql-tooling&data=02%7C01%7Cwilhelm.thomas%40anaplan.com%7Cfbb6fedcbfb349dbc0da08d5838ae901%7Ce777e544630e475ca07acd4143ce5140%7C0%7C0%7C636559554989980183&sdata=OytIaIxpo01kFapJHQQsuiUtMwpXnH3%2Fd%2BVYlkyZTFg%3D&reserved=0>
I notice the jdbc drive it found was org.apache.ignite.IgniteJdbcDriver and not 
org.apache.ignite.IgniteJdbcThinDriver


Any idea on how to solve this?

Thanks for your help

w

Reply via email to