JDBC connection using SSL gives error

Moderator: NorbertKrupa

Post Reply
Posts: 3
Joined: Fri Feb 22, 2013 11:48 pm

JDBC connection using SSL gives error

Post by van » Tue May 07, 2013 12:51 am

We're running Vertica 6.0.1 Community Edition. We went through the instructions for enabling SSL and can verify that SSL access is working when using vsql. We also went through the additional steps given for enabling SSL for JDBC. Using a regular JDBC connection we are able to successfully connect, however when we try adding "ssl=true" as a property (through a database client app), we get the following error:
An error occurred while establishing the connection:
Long Message:
[Vertica][VJDBC](100066) Authentication failed.
Type: java.sql.SQLException
Error Code: 100066
SQL State: 28000
Any pointers for how to set up an SSL JDBC connection would be greatly appreciated!


Posts: 1
Joined: Sat Mar 21, 2015 8:19 am

Re: JDBC connection using SSL gives error

Post by muthu1086 » Tue Oct 13, 2015 8:22 am

Am too facing the same issue, can anybody direct where to look at.

I had generated keys and distributed and enabled the SSL for database.

Using the keys with ODBC am able to connect through SSL but when i generate truststore and keystore and use them using JDBC getting this error.


Post Reply

Return to “JDBC”