Thanks Chuck. I am using ERXPartials. I've done a couple of deployments including partial support and it had been working well. This problem just started recently - really seemed to come out of the blue. The exception is reproducible in development so there is no other app touching the database.
Tim UCLA GSE&IS On Jun 10, 2013, at 3:35 PM, Chuck Hill <[email protected]> wrote: > Are you using inheritance or partials? > > > On 2013-06-10, at 3:33 PM, Tim Worman wrote: > >> I am suddenly getting strange optimistic locking failures when when updating >> a row on ec.saveChanges(). At least it seems sudden to me because I can't >> introspect well enough to see where I caused it. :-) I'm seeing this. >> >> Jun 10 15:14:02 eTimesheet[55555] INFO er.transaction.adaptor.Exceptions - >> Database Exception occured: >> com.webobjects.eoaccess.EOGeneralAdaptorException: >> updateValuesInRowDescribedByQualifier -- >> com.webobjects.jdbcadaptor.JDBCChannel method failed to update row in >> database. >> >> So, I logged at the SQL and capture the userInfo() on the exception. What >> really caught my eye is the update statement that was produced. The WHERE >> statement makes it seem like is locking on every attribute in the PERSON >> entity. My model definitely does not reflect that should be happening. >> >> UPDATE PERSON SET campus_mail_code = ?, should_sync = ?, person_first_name = >> ?, start_end_date = ?, norm_vac_max = ?, student_status = ?, >> start_begin_date = ?, campus_phone = ?, home_dept_code = ?, >> person_middle_name = ?, email_address_other = ?, emp_status = ?, >> work_addr_line2 = ?, emp_rel_code = ? WHERE (person_id = ? AND modify_date = >> ? AND comp_time_bal = ? AND emergency_info = ? AND emp_rel_code = ? AND >> norm_vac_max is NULL AND out_of_office = ? AND pto_hrs_bal = ? AND >> sick_lv_hrs_bal = ? AND start_begin_date is NULL AND start_end_date is NULL >> AND start_percent = ? AND vac_hrs_balance = ? AND work_addr_city is NULL AND >> work_addr_line1 = ? AND work_addr_line2 is NULL AND work_addr_state is NULL >> AND work_addr_zip is NULL) >> >> Can anyone help explain the abnormal growth of my WHERE clause? >> >> Tim >> UCLA GSE&IS >> _______________________________________________ >> Do not post admin requests to the list. They will be ignored. >> Webobjects-dev mailing list ([email protected]) >> Help/Unsubscribe/Update your Subscription: >> https://lists.apple.com/mailman/options/webobjects-dev/chill%40global-village.net >> >> This email sent to [email protected] > > -- > Chuck Hill > Executive Managing Partner, VP Development and Technical Services > > 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/gvc/practical_webobjects > > Global Village Consulting ranks 13th in 2012 in BIV's Top 100 Fastest Growing > Companies in B.C! > > Global Village Consulting ranks 44th in 25th annual PROFIT 500 ranking of > Canada’s Fastest-Growing Companies by PROFIT Magazine! > > > > > > > > > > > > _______________________________________________ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list ([email protected]) Help/Unsubscribe/Update your Subscription: https://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to [email protected]
