Four Stars

Insert into PostgreSQL not working

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...

 

1 REPLY
Seventeen Stars

Re: Insert into PostgreSQL not working

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.