Connect to Hologres

psql

JDBC

Hologres offer JDBC/ODBC Driver,that means you can use JDBC to connect Hologres,steps are as floowing:

Step 1: Add dependency via MVN

Download PostgreSQL JDBC Driver 42.xxx, and configurate dependency in MVN.

<dependencies>
    <dependency>
        <groupId>org.postgresql</groupId>
        <artifactId>postgresql</artifactId>
        <version>42.2.8.jre6</version>                     
    </dependency>
 </dependencies>

Step 2: Connect Hologres

public class HologresTest {

    private void jdbcExample() throws Exception {
        String url = "jdbc:postgresql://{ENDPOINT}:{PORT}/{DBNAME}?user={ACCESS_ID}&password={ACCESS_KEY}";
        Connection conn = DriverManager.getConnection(url);
        Statement st = conn.createStatement();
        String sql = "SELECT * FROM table where xxx limit 100";
        ResultSet rs = st.executeQuery(sql);
        String c1 = rs.getString(1);
    }
}