I'm attempting to write data from the .csv file to my postgreSQL database. The bond is okay, however when I run my job i recieve the next error:
Exception in component tPostgresqlOutput_1 org.postgresql.util.PSQLException: ERROR: zero-length delimited identifier at or near """" at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1592) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1327) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:192) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:451) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:336) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:328) at talend_test.exporttoexcel_0_1.exportToExcel.tFileInputDelimited_1Process(exportToExcel.java:568) at talend_test.exporttoexcel_0_1.exportToExcel.runJobInTOS(exportToExcel.java:1015) at talend_test.exporttoexcel_0_1.exportToExcel.main(exportToExcel.java:886)
My job really is easy: tFileInputDelimiter -> PostgreSQL_Output
I believe the error implies that the double quotes ought to be single quotes ("" -> ''), but how do i edit this in Talend?
Or perhaps is it one more reason? Can anybody assist me to on that one?
might be if u use customer.csv from repository then u need to change some property of customer file from metadata->file delimited->customer. u get edit existing file window for the reason that at step three (chk out step number at surface of window). for the reason that if u have ur file extension .csv then in Escape char configurations u have check up on csv option n escape char is """ and text enclosure can also be """ making some arrangement in file configurations that encoding is utf-8. n refresh your schema. your file appears like table format. then u can run jobs. its work.
and when your file isn't in repository then click element of ur file n do all above arrangement in fundamental configurations.