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<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
