tSybaseInput

Anonymous — Sat, 16 Nov 2024 14:32:04 GMT

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

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

Re: tSybaseInput

Anonymous — Tue, 23 Oct 2007 21:37:09 GMT

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.

topic Re: tSybaseInput in Talend Studio

tSybaseInput

Re: tSybaseInput