Connect to the Aiven for ClickHouse® service with Java
Learn how to connect to your Aiven for ClickHouse® service with Java using the ClickHouse JDBC driver and the HTTPS port.
Prerequisites
- Java 8 or later
- ClickHouse JDBC driver
Identify connection information
To run the code for connecting to your service, first identify values of the following variables:
Variable | Description |
---|---|
CLICKHOUSE_HTTPS_HOST | Host for the ClickHouse connection available in the Aiven console: Service Overview > Connection information > ClickHouse HTTPS & JDBC |
CLICKHOUSE_HTTPS_PORT | Port for the ClickHouse connection available in the Aiven console: Service Overview > Connection information > ClickHouse HTTPS & JDBC |
CLICKHOUSE_USER | User for the ClickHouse connection available in the Aiven console: Service Overview > Connection information > ClickHouse HTTPS & JDBC |
CLICKHOUSE_PASSWORD | Password for the ClickHouse connection available in the Aiven console: Service Overview > Connection information > ClickHouse HTTPS & JDBC |
Connect to the service
-
Add the ClickHouse JDBC driver to your Maven dependencies.
[](dependency)
<groupId>com.clickhouse</groupId>
<artifactId>clickhouse-jdbc</artifactId>
<version>0.3.2-patch11</version>
<classifier>all</classifier>
<exclusions>
<exclusion>
<groupId>*</groupId>
<artifactId>*</artifactId>
</exclusion>
</exclusions>
[](/dependency) -
Replace
CLICKHOUSE_HTTPS_HOST
andCLICKHOUSE_HTTPS_PORT
in the command with your connection values and run the code.jdbc:ch://CLICKHOUSE_HTTPS_HOST:CLICKHOUSE_HTTPS_PORT?ssl=true&sslmode=STRICT
-
Replace
CLICKHOUSE_USER
andCLICKHOUSE_PASSWORD
in the code with meaningful data and run the code.import com.clickhouse.jdbc.ClickHouseConnection;
import com.clickhouse.jdbc.ClickHouseDataSource;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class Main {
public static void main(String[] args) throws SQLException {
String connString = "jdbc:ch://CLICKHOUSE_HTTPS_HOST:CLICKHOUSE_HTTPS_PORT?ssl=true&sslmode=STRICT";
ClickHouseDataSource database = new ClickHouseDataSource(connString);
ClickHouseConnection connection = database.getConnection("CLICKHOUSE_USER", "CLICKHOUSE_PASSWORD");
Statement statement = connection.createStatement();
ResultSet result_set = statement.executeQuery("SELECT 1 AS one");
while (result_set.next()) {
System.out.println(result_set.getInt("one"));
}
}
}
Now you have your service connection set up and you can proceed to uploading data into your database.
Related pages
For information on how to connect to the Aiven for ClickHouse service with the ClickHouse client, see Connect with the ClickHouse client.