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
