On 9/6/05, Roberto R <[EMAIL PROTECTED]> wrote:Hi Sebastien.
Is there a value that is being inserted into DATE_MOTIF? What is the date format that the Oracle DB expects (NLS_DATE_FORMAT)? What is the format it is using on insert? Do you have any other SqlMap statements that insert or update a date successfully?
Roberto
Hi Roberto,
Is there a value that is being inserted into DATE_MOTIF?
Yes there is a value inserted. See answer 3 for the exact content.
What is the date format that the Oracle DB expects (NLS_DATE_FORMAT)?
I'll check that.
What is the format it is using on insert?
I use a DateTime object initialized with DateTime.Today or DateTime.Now. I let Ibatis do the conversion for me (It works great with resultMap)
Do you have any other SqlMap statements that insert or update a date successfully?
I successfully insert dates in all other tables. every table of my project has those fields USER_CREATION (user who create the row) DATE_CREATION (creation's date of the row) and the same with modification (MODIF). In all the other tables I never use a parameterMap I only use a resultMap. That's the difference.
I'm currently busy with another problem, I'll check the NLS_DATE_FORMAT tomorrow morning.
Thanks a lot for helping me.
Sebastien.
Sorry for my late answer,
The NLS_DATE_FORMAT is the default one :
DD-MON-YY
Hope this helps.
Sebastien
