Reply
New Contributor
Posts: 2
Registered: ‎09-03-2018

Java connection not working JDBC + SSL + LDAP [ImpalaJDBCDriver](500310) Invalid operation: null;

[ Edited ]

Dear all

I am trying to connect to Impala using the JDBC driver from a Jetty App

 

Whatever i do i get a non informative error back

 


Caused by: java.sql.SQLException: [Simba][ImpalaJDBCDriver](500310) Invalid operation: null;
        at com.cloudera.impala.hivecommon.api.HiveServer2ClientFactory.createTransport(HiveServer2ClientFactory.java:224)

 

My latest connection string :

 

jdbc:impala://host.muc.infineon.com:21050/mydb;AuthMech=3;SSL=1;AllowSelfSignedCerts=1;CAIssuedCertsMismatch=1;UID=myuser;PWD=xxxxxxx;SSLKeyStore=/xxxxx/jetty/mondrian.jks;SSLKeyStorePwd=xxxxxx;LogLevel=6;LogPath=/xxxxxxx/jetty;SocketTimeout=0

 

 

I started with the basic: 

jdbc:impala://host.muc.infineon.com:21050/mydb;AuthMech=3;SSL=1;AllowSelfSignedCerts=1;UID=myuser;PWD=xxxxxxx;

 

which works well in other clients that also are using the same driver version

 

I kept adding parameters to see if it would help. 

 

At the moment i dont even have any clue even on how to debug further.

Any help would be apreciated.

 

New Contributor
Posts: 2
Registered: ‎09-03-2018

Re: Java connection not working JDBC + SSL + LDAP [ImpalaJDBCDriver](500310) Invalid operation: nul

Update:

I was able to fix the problem by downloading the latest JDBC drivers, removing the old . Also, seems the new version of the driver does not require additional jars to be added .

 

Announcements