Readme
This document describes how to setup PXF with JDBC examples.
Error "ERROR: remote component error (0) from ':5888': Failed to connect to localhost port 5888: Connection refused (libchurl.c:944) (seg0 slice1 172.18.0.2:40000 pid=505) (cdbdisp.c:254)"
This error is displayed whenever PXF service is not running.
gpadmin=# select * from pxf_jdbc_postgres_testpxf;
ERROR: remote component error (0) from ':5888': Failed to connect to localhost port 5888: Connection refused (libchurl.c:944) (seg0 slice1 172.18.0.2:40000 pid=505) (cdbdisp.c:254)
DETAIL: External table pxf_jdbc_postgres_testpxf
Error "ERROR: remote component error (500) from '127.0.0.1:5888': type Exception report message org.postgresql.Driver description The server encountered an internal error that prevented it from fulfilling this request. exception java.io.IOException: org.postgresql.Driver (libchurl.c:944) (seg1 slice1 172.18.0.2:40001 pid=718) (cdbdisp.c:254)"
This error is displayed whenever JDBC driver is not loaded by PXF service.
gpadmin=# select * from pxf_jdbc_postgres_testpxf;
ERROR: remote component error (500) from '127.0.0.1:5888': type Exception report message org.postgresql.Driver description The server encountered an internal error that prevented it from fulfilling this request. exception java.io.IOException: org.postgresql.Driver (libchurl.c:944) (seg1 slice1 172.18.0.2:40001 pid=718) (cdbdisp.c:254)
DETAIL: External table pxf_jdbc_postgres_testpxf