Insert into PostgreSQL not working

Anonymous — Sat, 16 Nov 2024 09:55:03 GMT

Hey all,

I first thought it was a date formatting issue but it appears im unable to insert ANY data into my PostgreSQL database.

The situation:

- A delimited file that produces a String. Example: " 209"

- A table with 1 column varchar(50)

Job + tMap

http://imgur.com/a/Xwqe0

The error:

Starting job testPostgreConnect at 15:10 13/04/2017.

[statistics] connecting to socket on port 3645
[statistics] connected
Batch entry 0 INSERT INTO "newtable" ("id") VALUES (  209) was aborted.  Call getNextException to see the cause.
[statistics] disconnected
Job testPostgreConnect ended at 15:10 13/04/2017. [exit code=0]

I went debugging and found this... only it doesnt tell me much.

http://imgur.com/a/Gd1lx

FIXED. The database name and schema name weren't filled in...

Re: Insert into PostgreSQL not working

Anonymous — Thu, 13 Apr 2017 19:43:32 GMT

The first solution in such cases is to switch off the batch mode in the advanced settings of the component.

The good news is, Talend will provide the "next exception" in one of the next releases - so you do not have to change your job to get the detailed error message.

topic Re: Insert into PostgreSQL not working in Talend Studio

Insert into PostgreSQL not working

Re: Insert into PostgreSQL not working