Re: ps: database failures not rolling up to eof stack ??
Re: ps: database failures not rolling up to eof stack ??
- Subject: Re: ps: database failures not rolling up to eof stack ??
- From: Chuck Hill <email@hidden>
- Date: Fri, 28 Jan 2011 12:25:22 -0800
On Jan 28, 2011, at 12:21 PM, Simon wrote:
> oops - i forgot to mention:
>
> - full wonder apps and frameworks
> - wo5.4
> - mysql 5.1
>
>
> ---------- Forwarded message ----------
> From: Simon <email@hidden>
> Date: 28 January 2011 20:19
> Subject: database failures not rolling up to eof stack ??
> To: WebObjects Development <email@hidden>
>
>
> hi all -
>
> we have an ongoing issue with database update failures seemingly not rolling up into the eof stack. this is basically what happens:
>
> - create or update a few eo's in an ec & all save changes
> - we see the insert and/or update sql transactions go through
> - app continues and thinks everything is done
> - but in the console we see "roll back" statements, and the insert and/or update hasn't actually happened
>
> the repeatable situation that we see this happening is when we try and set a string value that is defined as width X in the model and DB to something greater than X.
That should cause a validation error in EOF, not a string truncation error in the database. Did you write that backwards?
> my guess is that we must somehow be disposing of the exception somewhere but i can't seem to figure it.
>
> any ideas ?
If you are not catching and swallowing it in your code, my suspicions would like in the JDBC driver or in the EOF plugin for MySQL. I have never seen EOF swallow exceptions originating from a failure to commit.
Chuck
--
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
Attachment:
smime.p7s
Description: S/MIME cryptographic signature
_______________________________________________
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