Sounds like you may not be running SQuirreL and your Java app on the same
machine. That would be what is different - not custom SQuirreL code.
Check out this posting:
http://www.postgresql.org/message-id/108...@lo...
(Greenplum is derived from PostgreSQL, I believe)
Rob
On Sat, Sep 27, 2014 at 2:22 PM, cha...@gm... <
cha...@gm...> wrote:
> 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.
>
>
> ------------------------------------------------------------------------------
> Meet PCI DSS 3.0 Compliance Requirements with EventLog Analyzer
> Achieve PCI DSS 3.0 Compliant Status with Out-of-the-box PCI DSS Reports
> Are you Audit-Ready for PCI DSS 3.0 Compliance? Download White paper
> Comply to PCI DSS 3.0 Requirement 10 and 11.5 with EventLog Analyzer
>
> http://pubads.g.doubleclick.net/gampad/clk?id=154622311&iu=/4140/ostg.clktrk
> _______________________________________________
> Squirrel-sql-develop mailing list
> Squ...@li...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-develop
>
|
