Re: Wonder FrontBase plugin exception
Re: Wonder FrontBase plugin exception
- Subject: Re: Wonder FrontBase plugin exception
- From: Chuck Hill <email@hidden>
- Date: Sat, 27 Jun 2009 15:39:45 -0700
On Jun 27, 2009, at 3:05 PM, Stamenkovic Florijan wrote:
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.
Good luck with that:
Hello Chuck,
If a timestamp has a year component that is less than 1600, an error
is generated.
Regards,
Geert
A better approach is to validation to your date columns to ensure that
they are reasonable.
Chuck
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
--
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