Re: Wonder FrontBase plugin exception
Re: Wonder FrontBase plugin exception
- Subject: Re: Wonder FrontBase plugin exception
- From: Stamenkovic Florijan <email@hidden>
- Date: Sat, 27 Jun 2009 18:05:47 -0400
LOL, I was looking at the structure and missed the content. Hm, this
is still a problem. I can live with the user screwing up and ending up
with a bad year, but I prefer it not resulting in a crash... Will try
to see what can be done with FB to accept any date, and not crash.
Thanks,
F
On Jun 27, 2009, at 16:24, Chuck Hill wrote:
It is the year, 0007. FrontBase does not accept dates before the
Gregorian calendar switch. Did you mean 2007?
On Jun 27, 2009, at 12:20 PM, Stamenkovic Florijan wrote:
Hi all,
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
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden
--
Chuck Hill Senior Consultant / VP Development
Practical WebObjects - for developers who want to increase their
overall knowledge of WebObjects or who are trying to solve specific
problems.
http://www.global-village.net/products/practical_webobjects
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden