JDBC SQL Exception - timestamp

[former_member540174]

I am moving a JDBC  interface into 7.3 from XI 7.0. and need some suggestions from the experts.  The database we are inserting into is Oracle.  With the following command - we get the error "Unable to execute statement for table or stored procedure. 'ATTIOADMIN.ATTNC_TRK' (Structure 'Statement') due to java.sql.SQLDataException: ORA-01861: literal does not match format string".  I only have hasQuot on the Timestamps and set it to No I've also tried it as NO just incase case made a difference.  I am assuming it is the timestamps that are the issue.  We would prefer not changing the source system that created the SQL if possible.  Is there some parm I can use or should have used so that the timestamp matches?

Regcards,

Diane

[former_member184720 · Accepted solution]

I think it's the problem with REVD_TS mapping.

For TO_DATE, format has to be changed from DD-MON-YYYY to YYYY/MM/DD??