Scenario 2: JDBC Client-Side Settings - Aster Client

Teradata Aster® Client Guide

Product
Aster Client
Release Number
7.00
Published
May 2017
Language
English (United States)
Last Update
2018-04-13
dita:mapPath
hki1475000360386.ditamap
dita:ditavalPath
Generic_no_ie_no_tempfilter.ditaval
dita:id
B700-2005
lifecycle
previous
Product Category
Software
  1. Generate a truststore for the Aster Database certificate by copying the file /home/beehive/certs/server.cert from queen node to your local client machine.
  2. To import the certificate, execute a command like this at the command prompt on the client, substituting the correct paths and the alias of your choice:
    keytool -import -trustcacerts -alias "asterca" -file 
    C:\keystore\server.cert -keystore C:\truststore\truststore.jks
  3. Issue the following JDBC commands on the client, substituting the correct user, password, database, and path values for the truststore:
    Properties props = new Properties(); 
     props.setProperty("user", "beehive"); 
     props.setProperty("password", "beehive_password"); 
     props.setProperty("database", "beehive"); 
     props.setProperty("ENABLESSL", "true");
     props.setProperty("SSLALLOWSELFSIGNEDPEER", "true"); 
     props.setProperty("SSLTRUSTSTORE","C:\\truststore\\truststore.jks"); 
     props.setProperty("SSLTRUSTSTOREPASSWORD","aster_password"); 
     props.setProperty("SSLFILETYPE", ","1"); 
     Connection conn = DriverManager.getConnection(url, props);