Join this online group to communicate across IBM product users and experts by sharing advice and best practices with peers and staying up to date regarding product enhancements.
#Automation
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
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!