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