Inserting a null date

, ,
1

I’m using Integration server 4.6 with the jdbc adapter. I’m trying to insert null values into date columns in an Oracle database. When using the trace log tool, I can see that the date fields have values of “” before insertion. When I query the data base after the insert, the date columns have a value of ‘01-Jan-1900’ instead of null.

Thanks for your help

2

Check the table script in your DB whether you have set the DEFAULT value for that particular column to ‘01-Jan-1900’.
Or check if there is any trigger written on that table to do so if the value is coming as NULL.
Hope this helps!