You're using the wrong jar, Cheyenne.

The client.jar is for the "thick" JDBC driver. The thin-client.jar is for the "thin" JDBC driver.

Cheyenne Forbes wrote:
I've used Squirrel SQL Client before but now I'm trying Squirrel'
snapshot-20170214_2214 with phoenix-4.9.0-HBase-1.2-client.jar it wont work.

URL field: jdbc:phoenix:thin:url=http://172.17.0.2:8765

Class name: org.apache.phoenix.queryserver.client.Driver

Error:
/java.util.concurrent.ExecutionException: java.lang.RuntimeException:
java.lang.RuntimeException: Failed to construct AvaticaHttpClient
implementation
org.apache.calcite.avatica.remote.AvaticaCommonsHttpClientImpl
     at java.util.concurrent.FutureTask.report(FutureTask.java:122)
     at java.util.concurrent.FutureTask.get(FutureTask.java:206)
     at
net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.awaitConnection(OpenConnectionCommand.java:132)
     at
net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.access$100(OpenConnectionCommand.java:45)
     at
net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand$2.run(OpenConnectionCommand.java:115)
     at
java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
     at java.util.concurrent.FutureTask.run(FutureTask.java:266)
     at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
     at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
     at java.lang.Thread.run(Thread.java:745)
Caused by: java.lang.RuntimeException: java.lang.RuntimeException:
Failed to construct AvaticaHttpClient implementation
org.apache.calcite.avatica.remote.AvaticaCommonsHttpClientImpl
     at
net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.executeConnect(OpenConnectionCommand.java:175)
     at
net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.access$000(OpenConnectionCommand.java:45)
     at
net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand$1.run(OpenConnectionCommand.java:104)
     ... 5 more
Caused by: java.lang.RuntimeException: Failed to construct
AvaticaHttpClient implementation
org.apache.calcite.avatica.remote.AvaticaCommonsHttpClientImpl
     at
org.apache.calcite.avatica.remote.AvaticaHttpClientFactoryImpl.instantiateClient(AvaticaHttpClientFactoryImpl.java:106)
     at
org.apache.calcite.avatica.remote.AvaticaHttpClientFactoryImpl.getClient(AvaticaHttpClientFactoryImpl.java:67)
     at
org.apache.calcite.avatica.remote.Driver.getHttpClient(Driver.java:159)
     at
org.apache.calcite.avatica.remote.Driver.createService(Driver.java:122)
     at org.apache.calcite.avatica.remote.Driver.createMeta(Driver.java:96)
     at
org.apache.calcite.avatica.AvaticaConnection.<init>(AvaticaConnection.java:118)
     at
org.apache.calcite.avatica.AvaticaJdbc41Factory$AvaticaJdbc41Connection.<init>(AvaticaJdbc41Factory.java:105)
     at
org.apache.calcite.avatica.AvaticaJdbc41Factory.newConnection(AvaticaJdbc41Factory.java:62)
     at
org.apache.calcite.avatica.UnregisteredDriver.connect(UnregisteredDriver.java:143)
     at org.apache.calcite.avatica.remote.Driver.connect(Driver.java:164)
     at
net.sourceforge.squirrel_sql.fw.sql.SQLDriverManager.getConnection(SQLDriverManager.java:133)
     at
net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.executeConnect(OpenConnectionCommand.java:167)
     ... 7 more
Caused by: java.lang.reflect.InvocationTargetException
     at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native
Method)
     at
sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
     at
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
     at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
     at
org.apache.calcite.avatica.remote.AvaticaHttpClientFactoryImpl.instantiateClient(AvaticaHttpClientFactoryImpl.java:103)
     ... 18 more
Caused by: java.lang.NoClassDefFoundError: Could not initialize class
org.apache.phoenix.shaded.org.apache.http.conn.ssl.SSLConnectionSocketFactory
     at
org.apache.phoenix.shaded.org.apache.http.impl.conn.PoolingHttpClientConnectionManager.getDefaultRegistry(PoolingHttpClientConnectionManager.java:109)
     at
org.apache.phoenix.shaded.org.apache.http.impl.conn.PoolingHttpClientConnectionManager.<init>(PoolingHttpClientConnectionManager.java:116)
     at
org.apache.calcite.avatica.remote.AvaticaCommonsHttpClientImpl.<init>(AvaticaCommonsHttpClientImpl.java:99)
     ... 23 more

/
Regards,

Cheyenne O. Forbes

Reply via email to