ApsaraDB for ClickHouse:Connect over HTTPS

Step 1: Add the JDBC dependency

Add the following dependency to your Maven project:

<dependency>
  <groupId>ru.yandex.clickhouse</groupId>
  <artifactId>clickhouse-jdbc</artifactId>
  <version>0.3.1</version>
</dependency>

Step 2: Gather connection information

Collect the following values before writing your connection code:

Step 3: Connect to the cluster

All SSL settings are configured through ClickHouseProperties. The JDBC URL uses port 8443 and the ssl=true parameter.

import ru.yandex.clickhouse.ClickHouseConnection;
import ru.yandex.clickhouse.ClickHouseDataSource;
import ru.yandex.clickhouse.settings.ClickHouseProperties;

public void run() throws InterruptedException {
    ClickHouseProperties props = new ClickHouseProperties();
    props.setSslRootCertificate("<certificate-path>");   // path to the SSL CA certificate
    props.setSsl(true);
    props.setSslMode("<ssl-mode>");                      // strict: verify cert against CA; none: skip verification (IP + same VPC only)
    props.setUser("<database-account>");
    props.setPassword("<password>");
    props.setSocketTimeout(<timeout-ms>);                // timeout in milliseconds

    String url = "jdbc:clickhouse://<endpoint>:<HTTPS port number>/<database-name>?ssl=true";
    ClickHouseDataSource dataSource = new ClickHouseDataSource(url, props);

    try {
        final ClickHouseConnection conn = dataSource.getConnection();
        conn.createStatement().executeQuery("select now()");
    } catch (Throwable e) {
        e.printStackTrace();
    }
}

Replace the placeholders with the values you collected in Step 2: