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);
}
}