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) Eclipse Platform Version: 3.3.1.1 WOLips 3.3.4763 FrontBase Version 4.2.8 WebObjects Version 5.4 FrontBasePlugIn Version 2.6.4
Has anyone already had/solved this one?
Thanks and regards, Irina
Irina Popova Tuparev Technologies 3 Sofijski Geroj Str., Entr.2, Apt.27 1612 Sofia Bulgaria
phone: +359 2 950 15 05 fax: +359 2 953 22 16 www.tuparev.com
|