Dbeaver works just fine. 
Or, you can even build Ignite-web-console.

Regards,
Neeraj

> On 7 Mar 2018, at 05:53, Wilhelm Thomas <wilhelm.tho...@anaplan.com> wrote:
> 
> 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
> 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