• Index
  •  » Talend Open Studio for Data Integration » Usage, Operation
  •  » tSybaseIQBulkExec :Error message with a Date field

#1 2010-09-20 17:29:33

fabone
Member
Registered: 2010-06-28
Posts: 10

tSybaseIQBulkExec :Error message with a Date field

Tags: [database, date, sybase]

Hello everybody,

When I try to load data in Sybase IQ, I have the following error :

Exception in component tSybaseIQBulkExec_1
java.sql.SQLException: [Sybase][ODBC Driver][Sybase IQ]Cannot convert 09/01/2010 to a date(4) (column arrDate)
    at ianywhere.ml.jdbcodbc.IIStatement.execute(Native Method)
    at ianywhere.ml.jdbcodbc.IStatement.execute(IStatement.java:210)
    ...

In my Database, my field arrDate is a type Date.

Why I have this error ?

In my schema, my model date is "MM/dd/yyyy"

Thanks for your help

Last edited by fabone (2010-09-20 17:30:35)

Offline

  • Index
  •  » Talend Open Studio for Data Integration » Usage, Operation
  •  » tSybaseIQBulkExec :Error message with a Date field

Board footer

Powered by FluxBB