One Star

Problem to insert data in a PostgreSQL database

I have some problem to insert data in a PostgreSQL database.
I created a job in Talend OS which allows to import data from a CSV file into a PostgreSQL database.
I have in my table a varchar (10) attribute "date_start" that contains a date in "dd.MM.yyyy" format.
And in my CSV file I have a String (10) attribute that contains a date in the same format.
And when I run my job, I have always this error:
Exception in component tPostgresqlOutput_1
org.postgresql.util.PSQLException: ERROR: date/time field value out of range: "10.10.2013"
                at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(
                at org.postgresql.core.v3.QueryExecutorImpl.processResults(
                at org.postgresql.core.v3.QueryExecutorImpl.execute(
                at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(
                at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(
                at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(
                at data_encoding.treatments_0_1.Treatments.tFileInputDelimited_1Process(
                at data_encoding.treatments_0_1.Treatments.runJobInTOS(
                at data_encoding.treatments_0_1.Treatments.main(

I got the SQL query of the tPostgresqlOutput component and execute it with pgAdmin in my database.
The insertion is carried without problems.
I don’t know how to solve this problem.
Thank you for your help.

Re: Problem to insert data in a PostgreSQL database

Your workflow is tfileinputdelimited-->tPostgresqlOutPut?
Please show us the screenshot of schema setting. Have you also checked your postgresql.conf file? Is the parameter datestyle = 'iso, dym'?
Best regards
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
One Star

Re: Problem to insert data in a PostgreSQL database

The parameter datestyle is 'german, dym'. It's a problem?
For the schema I have :
tfileinputdelimited                         ----->       tPostgresqlOutPut
Date_user    String  Nullable    10              Date_user    VARCHAR  Nullable    10