Talend community forum / tSybaseInput

denis · 2007-10-23 19:21:07

All

Try to user tSybaseInput and have the same probleme white date format (DB Sybase 12.5)

Code:

Exception in component tSybaseInput_2
java.sql.SQLException: JZ009: L'erreur suivante a été détectée pendant la conversion : java.lang.IllegalArgumentException: Timestamp format must be yyyy-mm-dd hh:mm:ss.fffffffff
    at com.sybase.jdbc3.jdbc.ErrorMessage.raiseError(Unknown Source)
    at com.sybase.jdbc3.jdbc.Convert.objectToTimestamp(Unknown Source)
    at com.sybase.jdbc3.jdbc.Convert.objectToDateObject(Unknown Source)
    at com.sybase.jdbc3.tds.TdsJdbcInputStream.getDateObject(Unknown Source)
    at com.sybase.jdbc3.jdbc.SybResultSet.getTimestamp(Unknown Source)
    at an.j_01_alim_extractionperimetre_na.J_01_ALIM_ExtractionPerimetre_NA.tSybaseInput_2Process(J_01_ALIM_ExtractionPerimetre_NA.java:242)
    at an.j_01_alim_extractionperimetre_na.J_01_ALIM_ExtractionPerimetre_NA.runJob(J_01_ALIM_ExtractionPerimetre_NA.java:491)
    at an.j_01_alim_extractionperimetre_na.J_01_ALIM_ExtractionPerimetre_NA.main(J_01_ALIM_ExtractionPerimetre_NA.java:435)

I have a simple table with
Product varchar(20)
StartDate datetime

trying to use this table with tmap and I get this error message

I trying to convert the datetime with TalendDate.formatDate("yyyy-MM-dd HH:mm:ss",row1.StartDate ) but is not working

I changed the Date Pattern in the Schema is not working

Please help

DN

mhirt · 2007-10-23 22:37:09

Hello Denis,

Just an idea, can you try with TalendDate.formatDate("yyyy-MM-dd HH:mm:ss.SSS",row1.StartDate ) to get the missing milliseconds of the pattern ?

Regards,
Michaël.

Announcement

Unanswered posts

#1 2007-10-23 19:21:07

tSybaseInput

Code:

#2 2007-10-23 22:37:09

Re: tSybaseInput

Board footer