[Squirrel-sql-develop] JDBC Connection working in SquirrelSql but in Java code (Greenplum drvier to

Hi, All:

Facing a weird issue with JDBC connection using Greenplum JDBC Driver to
Pivotal HD - when configured in SquirrelSql 3.5.0, the connection works
fine. However, when running pure JDBC Java code, the connecting attempt
fails.

Here are some details:

- JDBC Driver class: com.pivotal.jdbc.GreenplumDriver
- Driver: greenplum.jar from Pivotal HD website
- URL: jdbc:pivotal:greenplum://<DB_host>:<DB_port>;DatabaseName=<DB>
- JDBC Java code using JDK 1.7.0_51:
    Class.forName(JDBC_DRIVER);
    Connection conn = DriverManager.getConnection(DB_URL, USER, PASS);

    Error message: FATAL: no pg_hba.conf entry for host "10.2.20.184".


Would appreciate if anyone can point me to where SquirrelSql did something
special to make the connection working! I need to JDBC java code working!

- Charles



--
View this message in context: http://squirrel-sql-client.10976.n7.nabble.com/JDBC-Connection-working-in-SquirrelSql-but-in-Java-code-Greenplum-drvier-to-Pivotal-HD-tp3433.html
Sent from the Developer mailing list archive at Nabble.com.