Error while using PostgreSQL

One Star

Error while using PostgreSQL

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)
Six Stars

Re: Error while using PostgreSQL

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

Re: Error while using PostgreSQL

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

Re: Error while using PostgreSQL

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