I've followed the guide on setting up DBeaver to work with Ignite - I've set up a driver in DBeaver by selecting a class from the ignite-core jar, both version 2.6.0
My cluster is up and running now (e.g. write-through works) that I've added the MySQL JDBC driver to the (web-console generated) pom.xml's dependencies, but I still can't connect to Ignite via DBeaver. On 6 August 2018 at 11:17, Denis Mekhanikov <[email protected]> wrote: > Orel, > > JDBC driver fails on handshake for some reason. > It fails with OOM when trying to allocate a byte array for the handshake > message. > But there is not much data transferred in it. Most probably, message size > is read improperly. > > Do you use matching versions of JDBC driver and Ignite nodes? > > Denis > > > вс, 5 авг. 2018 г. в 11:01, Orel Weinstock (ExposeBox) <[email protected] > >: > >> Hi all, >> >> Trying to get an Ignite cluster up and going for testing before taking it >> to production. >> I've set up Ignite 2.6 on a cluster with a single node on a Google Cloud >> Compute instance and I have the web console working as well. >> >> I've imported a table from MySQL and re-run the cluster with the >> resulting Docker image. >> >> Querying for the table via the web console proved fruitless, so I've >> switched to SQLLine (on the cluster itself). Still no cigar: >> >> main(SqlLine.java:265)moo@ignite:/home/moo$ >> /usr/share/apache-ignite/bin/sqlline.sh >> --verbose=true -u jdbc:ignite:thin://127.0.0.1:8080issuing: !connect >> jdbc:ignite:thin://127.0.0.1:8080 '' '' org.apache.ignite. >> IgniteJdbcThinDriverConnecting to jdbc:ignite:thin://127.0.0.1:8080 >> java.lang.OutOfMemoryError: Java heap space at >> org.apache.ignite.internal.jdbc.thin.JdbcThinTcpIo.read( >> JdbcThinTcpIo.java:586) at org.apache.ignite.internal. >> jdbc.thin.JdbcThinTcpIo.read(JdbcThinTcpIo.java:575) at >> org.apache.ignite.internal.jdbc.thin.JdbcThinTcpIo. >> handshake(JdbcThinTcpIo.java:328) at org.apache.ignite.internal. >> jdbc.thin.JdbcThinTcpIo.start(JdbcThinTcpIo.java:223) at >> org.apache.ignite.internal.jdbc.thin.JdbcThinTcpIo.start( >> JdbcThinTcpIo.java:144) at org.apache.ignite.internal. >> jdbc.thin.JdbcThinConnection.ensureConnected(JdbcThinConnection.java:148) >> at org.apache.ignite.internal.jdbc.thin.JdbcThinConnection.< >> init>(JdbcThinConnection.java:137) at org.apache.ignite. >> IgniteJdbcThinDriver.connect(IgniteJdbcThinDriver.java:157) at >> sqlline.DatabaseConnection.connect(DatabaseConnection.java:156) at >> sqlline.DatabaseConnection.getConnection(DatabaseConnection.java:204) at >> sqlline.Commands.connect(Commands.java:1095) at sqlline.Commands.connect( >> Commands.java:1001) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native >> Method) at sun.reflect.NativeMethodAccessorImpl.invoke( >> NativeMethodAccessorImpl.java:62) at sun.reflect. >> DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) >> at java.lang.reflect.Method.invoke(Method.java:498) at sqlline. >> ReflectiveCommandHandler.execute(ReflectiveCommandHandler.java:38) at >> sqlline.SqlLine.dispatch(SqlLine.java:791) at sqlline.SqlLine.initArgs( >> SqlLine.java:566) at sqlline.SqlLine.begin(SqlLine.java:643) at >> sqlline.SqlLine.start(SqlLine.java:373) at sqlline.SqlLine.main(SqlLine. >> java:265) >> >> Tried DBeaver - still OOM. >> >> Is there a way to get a list of all tables in the cache? >> Does anyone have any experience with this error? I can't tell if it's >> Ignite itself or just the JDBC client, though I'm leaning towards the >> client. >> >> >> -- >> >> -- >> *Orel Weinstock* >> Software Engineer >> Email: [email protected] <[email protected]> >> Website: www.exposebox.com >> >> -- -- *Orel Weinstock* Software Engineer Email: [email protected] <[email protected]> Website: www.exposebox.com
