Re: Ignite with dBeaver

2018-03-20 Thread Wilhelm
Thanks Jose, this is working!
w



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


Re: Ignite with dBeaver

2018-03-06 Thread joseheitor
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

  

Jose



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


Re: Ignite with dBeaver

2018-03-06 Thread Neeraj Vaidya
Dbeaver works just fine. 
Or, you can even build Ignite-web-console.

Regards,
Neeraj

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

Re: Ignite with dBeaver

2018-03-06 Thread Wilhelm Thomas
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 
Reply-To: "user@ignite.apache.org" 
Date: Tuesday, March 6, 2018 at 9:51 AM
To: "user@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