Thanks Gabriel, I finally got it.
Had to replace several apache-related jars and added a jar for HTrace as well as one for 'netty'. -----Original Message----- From: Gabriel Reid [mailto:gabriel.r...@gmail.com] Sent: Wednesday, September 30, 2015 8:23 AM To: user@phoenix.apache.org Subject: Re: Connecting to Phoenix from AquaDataStudio? That's correct, the missing HTrace libs looks to be the problem now. It will probably take a bit of trial and error to get things working, but with the correct combination of dependencies it should all work. - Gabriel On Wed, Sep 30, 2015 at 2:10 PM, Riesland, Zack <zack.riesl...@sensus.com> wrote: > Thanks Gabriel, > > I replaced all the Hadoop and hbase related jars under Aqua Data > Studio/lib/apache with the appropriate ones from our cluster and I *think* I > made some progress. > > Seems like I'm now missing the jar with org.cloudera.htrace.Trace ? > > java.sql.SQLException: ERROR 103 (08004): Unable to establish connection. > at > org.apache.phoenix.exception.SQLExceptionCode$Factory$1.newException(SQLExceptionCode.java:336) > at > org.apache.phoenix.exception.SQLExceptionInfo.buildException(SQLExceptionInfo.java:133) > at > org.apache.phoenix.query.ConnectionQueryServicesImpl.openConnection(ConnectionQueryServicesImpl.java:260) > at > org.apache.phoenix.query.ConnectionQueryServicesImpl.access$300(ConnectionQueryServicesImpl.java:157) > at > org.apache.phoenix.query.ConnectionQueryServicesImpl$9.call(ConnectionQueryServicesImpl.java:1519) > at > org.apache.phoenix.query.ConnectionQueryServicesImpl$9.call(ConnectionQueryServicesImpl.java:1498) > at > org.apache.phoenix.util.PhoenixContextExecutor.call(PhoenixContextExecutor.java:77) > at > org.apache.phoenix.query.ConnectionQueryServicesImpl.init(ConnectionQueryServicesImpl.java:1498) > at > org.apache.phoenix.jdbc.PhoenixDriver.getConnectionQueryServices(PhoenixDriver.java:162) > at > org.apache.phoenix.jdbc.PhoenixEmbeddedDriver.connect(PhoenixEmbeddedDriver.java:126) > at > org.apache.phoenix.jdbc.PhoenixDriver.connect(PhoenixDriver.java:133) > at \\...\\ .\\हिñçêČάй語简 ?한\\.Jᠻꐎꎂᢋ 9.KX(Unknown Source) > at \\...\\ .\\हिñçêČάй語简 ?한\\.Jᠻꐎꎂᢋ 9.au(Unknown Source) > at \\...\\ .\\हिñçêČάй語简 ?한\\.Jᠻꐎꎂᢋ 9.getConnection(Unknown Source) > at \\...\\ .\\हिñçêČάй語简 ?한\\.Jᠻꐎꎂᢋ 9.getConnection(Unknown Source) > at > com.aquafold.datastudio.mainframe.dialog.connection.diagnostics.yꑅꀱꏓᜪ > import.dv(Unknown Source) > at > com.aquafold.datastudio.mainframe.dialog.connection.diagnostics.yꑅꀱꏓᜪ > import.b(Unknown Source) > at \\...\\ .\\हिñçêČάй語简 ?한\\.bᡲꐢꐟꄦ 5 5.d(Unknown Source) > at \\...\\ .\\हिñçêČάй語简 ?한\\.bᡲꐢꐟꄦ 5 5.b(Unknown Source) > at > com.aquafold.datastudio.mainframe.dialog.connection.diagnostics.PingDialog$3.runTest(Unknown > Source) > at > com.aquafold.datastudio.mainframe.dialog.connection.diagnostics.PingDialog$2.run(Unknown > Source) Caused by: java.io.IOException: > java.lang.reflect.InvocationTargetException > at > org.apache.hadoop.hbase.client.ConnectionManager.createConnection(ConnectionManager.java:426) > at > org.apache.hadoop.hbase.client.ConnectionManager.createConnectionInternal(ConnectionManager.java:319) > at > org.apache.hadoop.hbase.client.HConnectionManager.createConnection(HConnectionManager.java:292) > at > org.apache.phoenix.query.HConnectionFactory$HConnectionFactoryImpl.createConnection(HConnectionFactory.java:47) > at > org.apache.phoenix.query.ConnectionQueryServicesImpl.openConnection(ConnectionQueryServicesImpl.java:258) > ... 18 more > Caused by: java.lang.reflect.InvocationTargetException > at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native > Method) > at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown > Source) > at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown > Source) > at java.lang.reflect.Constructor.newInstance(Unknown Source) > at > org.apache.hadoop.hbase.client.ConnectionManager.createConnection(ConnectionManager.java:424) > ... 22 more > Caused by: java.lang.NoClassDefFoundError: org/cloudera/htrace/Trace > at > org.apache.hadoop.hbase.zookeeper.RecoverableZooKeeper.exists(RecoverableZooKeeper.java:195) > at > org.apache.hadoop.hbase.zookeeper.ZKUtil.checkExists(ZKUtil.java:481) > at > org.apache.hadoop.hbase.zookeeper.ZKClusterId.readClusterIdZNode(ZKClusterId.java:65) > at > org.apache.hadoop.hbase.client.ZooKeeperRegistry.getClusterId(ZooKeeperRegistry.java:106) > at > org.apache.hadoop.hbase.client.ConnectionManager$HConnectionImplementation.retrieveClusterId(ConnectionManager.java:858) > at > org.apache.hadoop.hbase.client.ConnectionManager$HConnectionImplementation.<init>(ConnectionManager.java:662) > ... 27 more > > > -----Original Message----- > From: Gabriel Reid [mailto:gabriel.r...@gmail.com] > Sent: Wednesday, September 30, 2015 7:48 AM > To: user@phoenix.apache.org > Subject: Re: Connecting to Phoenix from AquaDataStudio? > > Hi Zack, > > It looks like there is probably an older version of HBase somewhere > (earlier) in the classpath. > > I don't know anything about Aqua Data Studio, but could it be that it > somehow bundles support for HBase 0.94 somewhere (or perhaps there is > another JDBC driver on the class path that workds with HBase 0.94?) > > - Gabriel > > > On Wed, Sep 30, 2015 at 1:37 PM, Riesland, Zack <zack.riesl...@sensus.com> > wrote: >> Has anyone been able to use Aqua Data Studio w/ Phoenix? >> >> >> >> I had success w/ DBVisualizer, but am not able to connect from ADS. >> >> >> >> I tried to create a “generic JDBC connection” using the connection >> wizard. I pointed at the appropriate driver jar: >> 4.2.0.2.2.0.0-2041-client.jar in our case. >> >> >> >> But when I attempt to test the connection, I get the error below. >> >> >> >> Any ideas? >> >> >> >> >> >> java.lang.NoSuchMethodError: >> org.apache.hadoop.hbase.client.Mutation.getFamilyCellMap()Ljava/util/ >> N >> avigableMap; >> >> at >> org.apache.phoenix.schema.PTableImpl$PRowImpl.removeIfPresent(PTableI >> m >> pl.java:624) >> >> at >> org.apache.phoenix.schema.PTableImpl$PRowImpl.setValue(PTableImpl.jav >> a >> :655) >> >> at >> org.apache.phoenix.execute.MutationState.addRowMutations(MutationStat >> e >> .java:201) >> >> at >> org.apache.phoenix.execute.MutationState.access$200(MutationState.jav >> a >> :75) >> >> at >> org.apache.phoenix.execute.MutationState$2.init(MutationState.java:26 >> 3 >> ) >> >> at >> org.apache.phoenix.execute.MutationState$2.<init>(MutationState.java: >> 2 >> 60) >> >> at >> org.apache.phoenix.execute.MutationState.toMutations(MutationState.ja >> v >> a:258) >> >> at >> org.apache.phoenix.execute.MutationState.toMutations(MutationState.ja >> v >> a:248) >> >> at >> org.apache.phoenix.schema.MetaDataClient.createTableInternal(MetaData >> C >> lient.java:1466) >> >> at >> org.apache.phoenix.schema.MetaDataClient.createTable(MetaDataClient.j >> a >> va:535) >> >> at >> org.apache.phoenix.compile.CreateTableCompiler$2.execute(CreateTableC >> o >> mpiler.java:184) >> >> at >> org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java: >> 260) >> >> at >> org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java: >> 252) >> >> at >> org.apache.phoenix.call.CallRunner.run(CallRunner.java:53) >> >> at >> org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixState >> m >> ent.java:250) >> >> at >> org.apache.phoenix.jdbc.PhoenixStatement.executeUpdate(PhoenixStateme >> n >> t.java:1026) >> >> at >> org.apache.phoenix.query.ConnectionQueryServicesImpl$9.call(Connectio >> n >> QueryServicesImpl.java:1529) >> >> at >> org.apache.phoenix.query.ConnectionQueryServicesImpl$9.call(Connectio >> n >> QueryServicesImpl.java:1498) >> >> at >> org.apache.phoenix.util.PhoenixContextExecutor.call(PhoenixContextExe >> c >> utor.java:77) >> >> at >> org.apache.phoenix.query.ConnectionQueryServicesImpl.init(ConnectionQ >> u >> eryServicesImpl.java:1498) >> >> at >> org.apache.phoenix.jdbc.PhoenixDriver.getConnectionQueryServices(Phoe >> n >> ixDriver.java:162) >> >> at >> org.apache.phoenix.jdbc.PhoenixEmbeddedDriver.connect(PhoenixEmbedded >> D >> river.java:126) >> >> at >> org.apache.phoenix.jdbc.PhoenixDriver.connect(PhoenixDriver.java:133) >> >> at \\...\\ .\\हिñçêČάй語简 ?한\\.Jᠻꐎꎂᢋ 9.KX(Unknown >> Source) >> >> at \\...\\ .\\हिñçêČάй語简 ?한\\.Jᠻꐎꎂᢋ 9.au(Unknown >> Source) >> >> at \\...\\ .\\हिñçêČάй語简 ?한\\.Jᠻꐎꎂᢋ >> 9.getConnection(Unknown >> Source) >> >> at \\...\\ .\\हिñçêČάй語简 ?한\\.Jᠻꐎꎂᢋ >> 9.getConnection(Unknown >> Source) >> >> at >> com.aquafold.datastudio.mainframe.dialog.connection.diagnostics.yꑅꀱꏓᜪ >> import.dv(Unknown Source) >> >> at >> com.aquafold.datastudio.mainframe.dialog.connection.diagnostics.yꑅꀱꏓᜪ >> import.b(Unknown Source) >> >> at \\...\\ .\\हिñçêČάй語简 ?한\\.bᡲꐢꐟꄦ 5 5.d(Unknown >> Source) >> >> at \\...\\ .\\हिñçêČάй語简 ?한\\.bᡲꐢꐟꄦ 5 5.b(Unknown >> Source) >> >> at >> com.aquafold.datastudio.mainframe.dialog.connection.diagnostics.PingD >> i >> alog$3.runTest(Unknown >> Source) >> >> at >> com.aquafold.datastudio.mainframe.dialog.connection.diagnostics.PingD >> i >> alog$2.run(Unknown >> Source) >> >> >> >> >> >>
