Connect from Java client with TLS

About this task

To connect to the OneDB Databaser server with a Java client (JDBC) with TLS you must create a keystore for the client application to use. You need the root CA certificate and will use this file rootCA.cert.pem to generate the kesytore.

Procedure

Create the keystore:

keytool –import –file rootCA.cert.pem -keystore ssl.keystore

Example OneDB JDBC URL to connect to a OneDB Database server using TLS:

jdbc:onedb://XX.XXX.XXX.XX.nip.io:10001/sysmaster;user=onedbsa;password=xxxxxxx;ENCRYPT=true;TRUSTSTORE=./ssl.keystore;TRUSTSTOREPASSWORD=xxxxxxx;
CERTIFICATEVERIFICATION=false;loginTimeout=0

For more information on connecting JDBC applications with TLS, see HCL OneDB JDBC Driver Guide.