While performing an insertion that is performed often (at least a few hundred times till now) and normally without problems, I got:
java.lang.IllegalStateException: Server exception: EvaluateExpression failed: <com.webobjects.jdbcadaptor._FrontBasePlugIn$FrontbaseExpression: "INSERT INTO "BOOKING"("what", "dateDue", "debitID", "hidden", "currencyID", "date", "creditID", "invoiceNumber", "amount", "where", "id", "extraInfo", "comment") VALUES ('Legal ', NULL, 180, NULL, 16210, TIMESTAMP '0007-07-19 21:00:00.000', 3, '6299', 150.0000, 'Dennys Dumont', 784, NULL, 'Volmacht voor afhandeling')" withBindings: >:
Next exception:SQL State:00 subclass = " -- error code: 39 -- msg: Syntax error 39. Improper TIMESTAMP literal.
Next exception:SQL State:40 subclass = 00 -- error code: 363 -- msg: Exception condition 363. Transaction rollback.
The timestamp in question looks quite normal to me. Any thoughts?
I have not updated the FB plugin in a month or three, could it be that I am running into something that has been fixed?
Also, this did not happen after an update or something like that. The deployment in question is running for weeks now. This comes seemingly out of nowhere...
Thx,
F