Error while using PostgreSQL

ahsin — Tue, 20 Sep 2016 16:05:41 GMT

Hi,
I am getting the following error message when I try to read data from a database using tPostgresql. Would greatly appreciate any help on this. Many thanks.
Exception in component tPostgresqlInput_2
org.postgresql.util.PSQLException: An I/O error occurred while sending to the backend.
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:283)
at org.postgresql.jdbc2.AbstractJdbc2Connection.executeTransactionCommand(AbstractJdbc2Connection.java:791)
at org.postgresql.jdbc2.AbstractJdbc2Connection.commit(AbstractJdbc2Connection.java:815)
at getting_started.dbtest_0_1.dbtest.tPostgresqlInput_2Process(dbtest.java:664)
at getting_started.dbtest_0_1.dbtest.runJobInTOS(dbtest.java:957)
at getting_started.dbtest_0_1.dbtest.main(dbtest.java:814)
Caused by: java.net.SocketException: Connection reset
at java.net.SocketInputStream.read(Unknown Source)
at java.net.SocketInputStream.read(Unknown Source)
at org.postgresql.core.VisibleBufferedInputStream.readMore(VisibleBufferedInputStream.java:143)
at org.postgresql.core.VisibleBufferedInputStream.ensureBytes(VisibleBufferedInputStream.java:112)
at org.postgresql.core.VisibleBufferedInputStream.read(VisibleBufferedInputStream.java:71)

Re: Error while using PostgreSQL

Anonymous — Tue, 20 Sep 2016 16:55:55 GMT

Hi Ahsin,
What is it exactly you're trying to accomplish? Are you bringing in data from postgreSQL or to postgreSQL?

Re: Error while using PostgreSQL

ahsin — Tue, 20 Sep 2016 17:02:18 GMT

Hi, I am using tPostgresqlInput to get the data from a database.

Re: Error while using PostgreSQL

Anonymous — Tue, 20 Sep 2016 17:19:15 GMT

Did you define what table(s) you want to extract the data from in Talend?

topic Re: Error while using PostgreSQL in Talend Studio

Error while using PostgreSQL

Re: Error while using PostgreSQL

Re: Error while using PostgreSQL

Re: Error while using PostgreSQL