Setting Up a ClickHouse Connection

This section describes the sample code for creating a ClickHouse connection.

The following code snippets are provided in the initConnection method of the ClickhouseJDBCHaDemo class.

During connection creation, the user and password configured in Table 1 are used as authentication credentials. ClickHouse performs security authentication on the server with the user and password.

clickHouseProperties.setPassword(userPass);
clickHouseProperties.setUser(userName);
BalancedClickhouseDataSource balancedClickhouseDataSource = new BalancedClickhouseDataSource(JDBC_PREFIX + UriList, clickHouseProperties);