I was using Amazon EMR. Looks like there 1.4 jars. Copied over the 1.5 jars, created a new ignite-jdbc.xml and updated the jdbc url to use the new jdbc url. Did the trick!
On Sun, Jan 17, 2016 at 3:50 PM, babu prasad <babu...@gmail.com> wrote: > Hi, > > I have been trying to setup Zeppelin to talk to Apache Ignite, but no > success. > > I have my ignite servers running on remote nodes. > I keep getting this error. > > I followed this documentation to set it up - > http://apacheignite.gridgain.org/v1.1/docs/data-analysis-with-apache-zeppelin > > > ERROR [2016-01-17 23:44:24,598] ({pool-2-thread-2} > IgniteSqlInterpreter.java[open]:100) - Can't open connection: > java.sql.SQLException: Failed to establish connection. > at > org.apache.ignite.internal.jdbc.JdbcConnection.isValid(JdbcConnection.java:447) > at > org.apache.ignite.internal.jdbc.JdbcConnection.<init>(JdbcConnection.java:123) > at > org.apache.ignite.IgniteJdbcDriver.connect(IgniteJdbcDriver.java:347) > at java.sql.DriverManager.getConnection(DriverManager.java:571) > at java.sql.DriverManager.getConnection(DriverManager.java:233) > at > org.apache.zeppelin.ignite.IgniteSqlInterpreter.open(IgniteSqlInterpreter.java:95) > at > org.apache.zeppelin.interpreter.ClassloaderInterpreter.open(ClassloaderInterpreter.java:74) > at > org.apache.zeppelin.interpreter.LazyOpenInterpreter.open(LazyOpenInterpreter.java:68) > at > org.apache.zeppelin.interpreter.LazyOpenInterpreter.interpret(LazyOpenInterpreter.java:92) > at > org.apache.zeppelin.interpreter.remote.RemoteInterpreterServer$InterpretJob.jobRun(RemoteInterpreterServer.java:276) > at org.apache.zeppelin.scheduler.Job.run(Job.java:170) > at > org.apache.zeppelin.scheduler.FIFOScheduler$1.run(FIFOScheduler.java:118) > at > java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471) > at java.util.concurrent.FutureTask.run(FutureTask.java:262) > at > java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:178) > at > java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:292) > at > java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) > at > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) > at java.lang.Thread.run(Thread.java:745) > Caused by: class > org.apache.ignite.internal.client.GridClientDisconnectedException: Latest > topology update failed. > at > org.apache.ignite.internal.client.impl.connection.GridClientTopology.nodes(GridClientTopology.java:335) > at > org.apache.ignite.internal.client.impl.GridClientAbstractProjection.projectionNodes(GridClientAbstractProjection.java:312) > at > org.apache.ignite.internal.client.impl.GridClientAbstractProjection.balancedNode(GridClientAbstractProjection.java:352) > at > org.apache.ignite.internal.client.impl.GridClientAbstractProjection.withReconnectHandling(GridClientAbstractProjection.java:109) > at > org.apache.ignite.internal.client.impl.GridClientComputeImpl.executeAsync(GridClientComputeImpl.java:132) > at > org.apache.ignite.internal.jdbc.JdbcConnection.isValid(JdbcConnection.java:444) > ... 18 more > Caused by: class > org.apache.ignite.internal.client.GridServerUnreachableException: Failed to > connect to any of the servers in list: [/127.0.0.1:40075] > at > org.apache.ignite.internal.client.impl.connection.GridClientConnectionManagerAdapter.connect(GridClientConnectionManagerAdapter.java:414) > at > org.apache.ignite.internal.client.impl.connection.GridClientConnectionManagerAdapter.init(GridClientConnectionManagerAdapter.java:226) > at > org.apache.ignite.internal.client.impl.GridClientImpl.tryInitTopology(GridClientImpl.java:498) > at > org.apache.ignite.internal.client.impl.GridClientImpl.<init>(GridClientImpl.java:194) > at > org.apache.ignite.internal.client.GridClientFactory.start(GridClientFactory.java:58) > at > org.apache.ignite.internal.jdbc.JdbcConnection.<init>(JdbcConnection.java:117) > ... 17 more > Caused by: java.net.ConnectException: Connection refused > at sun.nio.ch.SocketChannelImpl.checkConnect(Native Method) > at > sun.nio.ch.SocketChannelImpl.finishConnect(SocketChannelImpl.java:744) > at sun.nio.ch.SocketAdaptor.connect(SocketAdaptor.java:117) > at > org.apache.ignite.internal.client.impl.connection.GridClientNioTcpConnection.<init>(GridClientNioTcpConnection.java:217) > at > org.apache.ignite.internal.client.impl.connection.GridClientConnectionManagerAdapter.connect(GridClientConnectionManagerAdapter.java:463) > at > org.apache.ignite.internal.client.impl.connection.GridClientConnectionManagerAdapter.connect(GridClientConnectionManagerAdapter.java:399) > > >