You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ignite.apache.org by Wilhelm Thomas <wi...@anaplan.com> on 2018/03/06 17:51:25 UTC

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

Re: Ignite with dBeaver

Posted by Wilhelm <wi...@anaplan.com>.
Thanks Jose, this is working!
w



--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: Ignite with dBeaver

Posted by joseheitor <jo...@heitorprojects.com>.
Hi Wilhem,

I have also been evaluating Ignite, and also followed the steps in setting
up SQL tooling with DBeaver...

At that final step, when you choose a driver class - I had a choice (from a
pulldown list, I think) between the two classes. You can then select the
Thin version for simple local connections, as described in the docs.

If you setup a distributed, persistent cluster though - you will need to add
all the jars in the lib folder, to the classpath, and then select the
'client' driver.

Here is the post that followed my progression - you may pick up some useful
tips from the challenges I encountered along the way:

http://apache-ignite-users.70518.x6.nabble.com/How-to-configure-a-cluster-as-a-persistent-replicated-SQL-database-td20251.html
<http://apache-ignite-users.70518.x6.nabble.com/How-to-configure-a-cluster-as-a-persistent-replicated-SQL-database-td20251.html>  

Jose



--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: Ignite with dBeaver

Posted by Neeraj Vaidya <ne...@yahoo.co.in>.
Dbeaver works just fine. 
Or, you can even build Ignite-web-console.

Regards,
Neeraj

> On 7 Mar 2018, at 05:53, Wilhelm Thomas <wi...@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 <wi...@anaplan.com>
> Reply-To: "user@ignite.apache.org" <us...@ignite.apache.org>
> Date: Tuesday, March 6, 2018 at 9:51 AM
> To: "user@ignite.apache.org" <us...@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

Re: Ignite with dBeaver

Posted by Wilhelm Thomas <wi...@anaplan.com>.
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 <wi...@anaplan.com>
Reply-To: "user@ignite.apache.org" <us...@ignite.apache.org>
Date: Tuesday, March 6, 2018 at 9:51 AM
To: "user@ignite.apache.org" <us...@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