Can't make Talend Open Studio write to UTF8 firebird database
tFirebirdInput_1 uses "win1257" encoding.
tFileOutputCSV_1 have corect values encoded in UTF8 when I open the file. (only if there is not connection between tMap_1 to tFirebirdOutput_1 ("called DB (Main order:3)"))
tLogRow_1 also displays correct values.
I also tried writing form CSV encoded in UTF8 directly to tFirebirdOutput_1, but it didn't worked too.
If I use database output encoded in not UTF8 (for example we use "UNICODE_FSS") then it works, but only Latin characters being written (second picture).
Output databases are the same except encoding.
I got this error when trying to write in UTF8 database (first picture)
Starting job Copy_Companies at 09:19 04/09/2007.
736|1|Zaras? DB|||||||838538002|||||||1
Exception in component tFirebirdOutput_1
org.firebirdsql.jdbc.FBSQLException: GDS Exception. 335544849. Malformed string
at org.firebirdsql.jdbc.AbstractPreparedStatement.internalExecute(AbstractPreparedStatement.java:712)
at org.firebirdsql.jdbc.AbstractPreparedStatement.executeUpdate(AbstractPreparedStatement.java:172)
at bandymas2.copy_companies.Copy_Companies.tFirebirdInput_1Process(Copy_Companies.java:1356)
at bandymas2.copy_companies.Copy_Companies.main(Copy_Companies.java:1549)
at org.firebirdsql.gds.GDSException: Malformed string
at org.firebirdsql.gds.impl.wire.AbstractJavaGDSImpl.readStatusVector(AbstractJavaGDSImpl.java:2124)
at org.firebirdsql.gds.impl.wire.AbstractJavaGDSImpl.receiveResponse(AbstractJavaGDSImpl.java:2074)
at org.firebirdsql.gds.impl.wire.AbstractJavaGDSImpl.iscDsqlExecute2(AbstractJavaGDSImpl.java:1155)
at org.firebirdsql.gds.impl.GDSHelper.executeStatement(GDSHelper.java:224)
at org.firebirdsql.jdbc.AbstractPreparedStatement.internalExecute(AbstractPreparedStatement.java:708)
at org.firebirdsql.jdbc.AbstractPreparedStatement.executeUpdate(AbstractPreparedStatement.java:172)
at bandymas2.copy_companies.Copy_Companies.tFirebirdInput_1Process(Copy_Companies.java:1356)
at bandymas2.copy_companies.Copy_Companies.main(Copy_Companies.java:1549)
Job Copy_Companies ended at 09:19 04/09/2007.
Copy_Companies.java:1356 is "pstmt_tFirebirdOutput_1.executeUpdate();"
Copy_Companies.java:1549 is "Copy_CompaniesClass.tFirebirdInput_1Process();"
long end = 0;
long start = java.util.Calendar.getInstance().getTimeInMillis();
Copy_Companies Copy_CompaniesClass = new Copy_Companies();
try {
Copy_CompaniesClass.tFirebirdInput_1Process();
} catch (TalendException e) {
status = "failure";
e.printStackTrace();
} finally {
end = java.util.Calendar.getInstance().getTimeInMillis();
if (watch) {
System.out.println((end - start) + " milliseconds");
}
}
Any suggestions?
