Re: Null value in column on insert when marked as mandatory in EOModel?
Re: Null value in column on insert when marked as mandatory in EOModel?
- Subject: Re: Null value in column on insert when marked as mandatory in EOModel?
- From: Chuck Hill <email@hidden>
- Date: Mon, 8 Dec 2008 12:06:47 -0800
On Dec 5, 2008, at 3:28 PM, Alan Zebchuk wrote:
Ya, you know, does an ec, I'm sure you know... lol
sorry, it does an insert :)
yes, it locks the EC.
There's no other other validation errors.
In fact the exception handling is set up to do the resave, and in
most circumstances this resave works correctly, however sometimes it
doesn't. Personally I'm purely convinced it's related to the load,
since if I don't try a resave I'm getting a lot more of these
errors. And again, on the instance with low traffic, I never get
this exception.
I agree that this is load and concurrency based. Did you read the
thread that Gary Teter started? This sounds like it may be the same,
or a very similar, problem.
Chuck
On 6-Dec-08, at 2:12 AM, Chuck Hill wrote:
On Dec 5, 2008, at 3:09 PM, Alan Zebchuk wrote:
In my case, I'm running on 5.4.3 and it is a direct action that
creates an EC, does an EC, and that's all.
Alan
"does an EC"?
Sounds kinky! Does it tie up, er lock, the EC before it does
this? Are there any validation (or other exceptions) and a resave?
Chuck
On 5-Dec-08, at 7:04 PM, Ken Anderson wrote:
What release of webobjects are you both running?
On Dec 5, 2008, at 10:59 AM, Simon McLean wrote:
Hi -
We've seen this too, but running on MySQL. It's really bizarre.
The EO's are built, the relationship set but then sometime
between saveChanges() and the raw SQL being sent to the DB it
seems to forget the foreign key in the relationship.
I've asked myself the same question too: how the hell did it get
passed model validation ?!!
Unfortunately we've never got to the bottom of it either...
Simon
On 5 Dec 2008, at 15:22, Alan Zebchuk wrote:
I seem to get the following exception in one of my applications
lately:
com.webobjects.eoaccess.EOGeneralAdaptorException:
EvaluateExpression failed:
<com.webobjects.jdbcadaptor.PostgresqlExpression: "INSERT INTO
"......
Next exception:SQL State:23502 -- error code: 0 -- msg: ERROR:
null value in column "oid_person_type" violates not-null
constraint
Any ideas how this could happen? The relationship and attribute
are marked as mandatory in the EO Model, so I'm not sure how
this would even pass through the validation?
It might be possible that this is related to load on the
application. I have 2 instance of this application, one which
has a much heavier load. This error is only occurring on this
instance.
Any help is greatly appreciated,
Thanks,
Alan
_______________________________________________
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
_______________________________________________
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
_______________________________________________
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
--
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