Hologres:Encryption in transit

Verify the connection

If you set PGSSLMODE to require, the following output indicates that an SSL-encrypted connection is active:

Example code

// Set the endpoint of the Hologres instance.
String hostname = "hgxxxxxxx-cn-hangzhou-vpc.hologres.aliyuncs.com";
// Set the port of the Hologres instance.
String port = "80";
// Set the name of the database to connect to.
String dbname = "postgres";

String jdbcUrl = "jdbc:postgresql://" + hostname + ":" + port + "/" + dbname + "?binaryTransfer=true";

Properties properties = new Properties();
// Set the username for the database connection.
// Use environment variables to reduce the risk of credential leaks.
properties.setProperty("user", System.getenv("ALIBABA_CLOUD_USER"));
// Set the password for the database connection.
// Use environment variables to reduce the risk of credential leaks.
properties.setProperty("password", System.getenv("ALIBABA_CLOUD_PASSWORD"));

// Enable SSL.
properties.setProperty("ssl", "true");

// Set the path to the CA root certificate.
properties.setProperty("sslrootcert", path + "/" + "hologres_certificate.crt");

// Set the SSL mode. Valid values: require, verify-ca, verify-full.
properties.setProperty("sslmode", "verify-full");

try {
    Class.forName("org.postgresql.Driver");
    Connection connection = DriverManager.getConnection(jdbcUrl, properties);
    // In this example, assume that a table named example exists in the postgres database.
    // The following code queries data from the example table.
    PreparedStatement preparedStatement = connection.prepareStatement("select * from " +
            "example");
    ResultSet resultSet = preparedStatement.executeQuery();
    while (resultSet.next()) {
        ResultSetMetaData rsmd = resultSet.getMetaData();
        int columnCount = rsmd.getColumnCount();
        Map map = new HashMap();
        for (int i = 0; i < columnCount; i++) {
            map.put(rsmd.getColumnName(i + 1).toLowerCase(), resultSet.getObject(i + 1));
        }
        System.out.println(map);
    }
} catch (Exception exception) {
    exception.printStackTrace();
}