JDBC over SSL

MaciejPaliwodaMaciejPaliwoda Employee, Registered User
edited February 12 in Vertica Forum

Hello.
I managed to properly configure SSL Client Server connection (SSL_Type = Server Only). Can easily connect to via VSQL (from local and remote machines).
However I encountered a serious problem while connecting via JDBC.

In customer's environment Icannot change and add self-signed certificates to a truststores. System variable JAVA_OPTS="-Djavax.net.ssl.trustStore=" seems not working as well (for DBVis, Dbeaver).

hence my question is :
are U aware of "hidden jdbc parameter" that works like -m/--sslmode for vsql? Postgress dirver has this option implemented and working - but functionality is limited to postrgress-vertica compatible features...

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file