jdbc - Invalid date supplied


jdbc - Invalid date supplied


I have some problem inserting date into db field which is type of Date.
From java code side i can see prepareStatement debug information and there is Date object which is formated as yyyy-mm-dd hh:mm:ss - Ibatis framework prepare this itself and i have no influence on this.
The community of this framework informed me, that it is jdbc driver task to automatically translated into correct type, and it should not bother me. But whatever i do, there is always a message : .JDBCException: [NCR] [Teradata DBMS] : Invalid date supplied for TABLE_NAME.DATE_FIELD_NAME.

Where is the problem?

Thanks for answer

Re: jdbc - Invalid date supplied

That format is what we call a time stamp in teradata... this is different from a date data type.

And as far I could remember the date object that you supply to jdbc should be a java.sql.Date object ... (though I can't confirm from the top of my mind)