Datadeploy: how to allow nulls in date values?

tanguyr

Hello,

I am attempting to write a datadeploy job to deploy xml files to an oracle database. In my xml files, i have fields which represent dates (formatted as "yyyy-MM-dd") which i map to database column types using the data-format attribute. My problem is that, while this works fine for date fields which are always populated in the xml files, it fails for date files which are optional. The database error returned in the datadeploy log is "java.sql.SQLException: ORA-01861: literal does not match format string". I have marked the column in question as allows-null="yes", but i still can't get this to work.

Can any one point me in the right direction here? I am attaching the deploment configuration and the sql of the table in question.

Thanks in advance,
/t

Edit: replaced attachments with new versions - used windows line endings - sorry 'bout that

Edit2: just to say that i solved my problem - just needed to restart odeploy. I saw in the deployment log that it mentioned "TTableSchemaHelper object for [KB_TIP] found in cache." so i restarted odeploy on a hunch and the problem went away. I had originally defined the offending field as a varchar2 before changing it to date, and i guess datadeploy caches this information.