Hi all,
While upgrading to Leopard we discovered a problem with the SQL which is generated by the EOF for FrontBase.
It seems that during
the generation of the SQL the notmeaningful zeroes in the timestamp are truncated.
For example in TIMESTAMP '2008-01-16 9:28:19.983' there is a missing zero before 9 in the hours section; TIMESTAMP '2008-01-16 13:8:19.983' is missing 0 before 8 in the minutes section.
The resulting error is for example:
com.webobjects.eoaccess.EOGeneralAdaptorException: EvaluateExpression failed: <com.webobjects.jdbcadaptor.FrontbasePlugIn$FrontbaseExpression: "INSERT INTO "TT_WORKFLOW_CYCLE"("IS_COMPLETED", "VERSION", "LABEL", "CYCLE_COMPLETION_TIME", "IS_POST_COMPLETION_COMPACTING_FINISHED", "OBJECT_UID", "WORKFLOW_ID", "ID", "HAS_EXCEPTIONS", "CYCLE_INITIATION_TIME") VALUES (0, NULL, 'SSCC_S1_S1-1_20080116112442', NULL, 0, X'0000C0A80103000007DB02000000011787A538C35D2153F5', 300600, 1002654, 0, TIMESTAMP '2008-01-17 12:9:
7.957')"
Our setup:
System Version: Mac OS X 10.5.1 (9B18)
WOLips 3.3.4763
FrontBase Version 4.2.8
WebObjects Version 5.4
FrontBasePlugIn Version 2.6.4