Hi Chuck et al: I wasn't sure if maybe I was missing something in your question - so, is this locking behavior I should expect when using partials? I don't recall seeing an update statement like that in the past.
Tim On Jun 10, 2013, at 3:38 PM, Tim Worman <[email protected]> wrote: > 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/lists%40thetimmy.com > > This email sent to [email protected] _______________________________________________ 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]
