Dbeaver works just fine. Or, you can even build Ignite-web-console. Regards, Neeraj
> On 7 Mar 2018, at 05:53, Wilhelm Thomas <[email protected]> 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 <[email protected]> > Reply-To: "[email protected]" <[email protected]> > Date: Tuesday, March 6, 2018 at 9:51 AM > To: "[email protected]" <[email protected]> > 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
