I first thought it was a date formatting issue but it appears im unable to insert ANY data into my PostgreSQL database.
- A delimited file that produces a String. Example: " 209"
- A table with 1 column varchar(50)
Job + tMap
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.
FIXED. The database name and schema name weren't filled in...
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.