Can't greenplum JDBC Driver be used on CloudBerry?

[mannago]

In my case, if I access the DB using postgresql JDBC and psql, it works without problem.
However, when accessing the DB using greenplum JDBC, a Hang occurs.

Installation was done according to the instructions here: https://cloudberry.apache.org/docs/cbdb-linux-compile
Am I missing something?

This is the sample code I tried and the results.

cloudberry version

PostgreSQL 14.4 (Cloudberry Database 1.6.0+dev.1244.g189bd60cba build dev) on x86_64-pc-linux-gnu,
compiled by gcc (GCC) 8.5.0 20210514 (Red Hat 8.5.0-23), 64-bit compiled on Feb 17 2025 16:36:02

jdbc versions

greenplum : 5.1.4.275
postgresql : 42.2.5

sample code

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Properties;

public class SelectCurrentDate {
    public static void main(String[] args) {
        // Server connection info
        // String url = "jdbc:pivotal:greenplum://192.168.0.115:5432;DatabaseName=warehouse";
        String url = "jdbc:postgresql://192.168.0.115:5432/warehouse";
        String user = "admin";
        String password = "changeme";

        Connection conn = null;
        Statement stmt = null;
        ResultSet rs = null;
        try {
            System.out.println("1. Starting JDBC driver load");
            // Load JDBC driver (JDBC 4 or later auto-loads, but we load explicitly)
            // Class.forName("com.pivotal.jdbc.GreenplumDriver");
            Class.forName("org.postgresql.Driver");
            System.out.println("2. JDBC driver load complete");

            // Set connection timeout (in seconds)
            DriverManager.setLoginTimeout(10);
            System.out.println("3. Attempting to connect to database (timeout 10 seconds): " + url);

            // Set connection properties using Properties
            Properties props = new Properties();
            props.setProperty("user", user);
            props.setProperty("password", password);

            // Attempt to connect to the database
            conn = DriverManager.getConnection(url, props);
            System.out.println("4. Database connection successful");

            System.out.println("5. Creating Statement");
            stmt = conn.createStatement();
            System.out.println("6. Executing query: select current_date");
            rs = stmt.executeQuery("select current_date");

            System.out.println("7. Processing query results");
            if (rs.next()) {
                System.out.println("Current Date: " + rs.getDate(1));
            } else {
                System.out.println("No results found.");
            }
            System.out.println("8. Program terminated");
        } catch (ClassNotFoundException e) {
            System.err.println("JDBC driver load failed: " + e.getMessage());
        } catch (SQLException e) {
            System.err.println("Database connection/query error: " + e.getMessage());
        } finally {
            System.out.println("9. Starting resource cleanup");
            try {
                if (rs != null) {
                    rs.close();
                    System.out.println("   - ResultSet closed");
                }
            } catch (SQLException ex) {
                System.err.println("   - ResultSet close error: " + ex.getMessage());
            }
            try {
                if (stmt != null) {
                    stmt.close();
                    System.out.println("   - Statement closed");
                }
            } catch (SQLException ex) {
                System.err.println("   - Statement close error: " + ex.getMessage());
            }
            try {
                if (conn != null) {
                    conn.close();
                    System.out.println("   - Connection closed");
                }
            } catch (SQLException ex) {
                System.err.println("   - Connection close error: " + ex.getMessage());
            }
            System.out.println("10. Resource cleanup complete");
        }
    }
}

psql

sample - postgres

sample - greenplum

[tuhaihe]

IMO, PG JDBC Driver is recommended for Cloudberry, right? @my-ship-it

[yjhjstz]

PG JDBC Driver is recommended.

[fanfuxiaoran]

@mannago Could you try gpdb-jdbc 6.0 ? version 5.1.4.275 is too old. And why don't you use pgjdbc instead of gpdb-jdbc?

[mannago]

That was the latest version I could get. I will test it later with the method you suggested