Problem with tPostgresqlOutput

[_AnonymousUser]

Hello.
I'm actually using Talend to compare this product with CloverETL.
In this goal, I'm doing some tests with component tPostgresqlOutput but I always receive this message while inserting in PostgreSQL :
Exception in component tPostgresqlOutput_1
org.postgresql.util.PSQLException: ERROR: zero-length delimited identifier at or near """"
...
However, if I return data into flat file there is no problem...
PS : My connection is well configured.

Can somebody help me?
Olivier

[Anonymous]

Hello,
Can you give us more details on your schema and the line of data not inserted ?
Best regards,
Michaël.

[_AnonymousUser]

I tried to put data from a flat file to a postgres table.
For the components, a "tFileInputDelimited" with schema ("firstname" in String, "name" in String and "num" in Integer) linked with a row Main to a "tPostgresqlOutput" having the same schema.
The key is on the "num" column.
In my database I get my table with the columns ("firstname" in text, "name" in text and "num" in integer).
While running I get this error message :
"Exception in component tPostgresqlOutput_1
org.postgresql.util.PSQLException: ERROR: zero-length delimited identifier ..."
None of my lines was inserted in my table.
Thanks for help.
Regards.

[Anonymous]

This postgreSQL error happens when an empty string ("") is provided. Nevertheless I was unable to reproduce this issue with empty values for firstname or name, as it should be handled by jdbc. What is your version of postgres, and could you post a sample of your input file ?
Best regards,
Jeremie.

[Anonymous]

hi,
set the commit to one for the output table so you can see where is the probleme in your text file (it's the line after the last line insert in your DB table)
maybe a null value for num field

[_AnonymousUser]

Thank you for these answers.
I thought too this error was caused by a null value into my data file or an invisible character so I tested to launch a new graph which inserts data provided by a PostgreSQL table to another table (just a copy with one row) but I have the same error...
Best regards
Olivier

[Anonymous]

What version of postgres, TOS ?
Java or Perl Project ?
Can you post a Screenshot of the job ant of the TMAP ?

[_AnonymousUser]

Hello,
here are these images :

job :


Tmap :


Schemas :


I try to link my frst two tables ("bordeaux" & "bordeaux2") with Tmap to load table "bordeaux3".but I have an error :
...ERROR: zero-length delimited identifier at or near """"...
But if I replace my table "bordeaux3" by a flat file it runs...
PS: My version of Postgres is 8.2.3 and TOS is V2.1.0M1
Best regards
Olivier

[Anonymous]

Did you enter a table name in tPostgresqlOutput properties ?
Best regards,
Jeremie.

[Anonymous]

postgres pbm i think,
is input and output are on the same DB, same schema ?
if not, check the codage DB to see if it's different.
may be a post on postgres forum can help you more !!
are you located france, bordeaux ?