Timestamp insert problem
399802Jul 24 2003 — edited Mar 14 2008I have Timestamp attribute mapped (as direct to field)to DATE type in the database. On retrieve it works ok but on insert(the sql stmt is below) i am getting sql exception -invalid column. It looks like Toplink generated statement is not syntactically correct. When i change Timestamp attribute to java.sql.Date and remap the field the insert works ok.
Did anyone run into this problem? I would appreciate suggestions to resolve this.
INSERT INTO SM_DATE_ELEMENT (LAST_CHANGED_DATE, LAST_CHANGED_BY, DATE_ELEMENT_DATE, MKTG_ELEMENT_TKEY)
VALUES (NULL, NULL, {ts '2003-06-11 00:00:00.0'}, 'XTRA202159')