Re: Exception: Deployment - FrontbasePlugIn - deadlock - WHY
Re: Exception: Deployment - FrontbasePlugIn - deadlock - WHY
- Subject: Re: Exception: Deployment - FrontbasePlugIn - deadlock - WHY
- From: Chuck Hill <email@hidden>
- Date: Wed, 10 Jan 2007 14:39:15 -0800
On Jan 10, 2007, at 2:33 PM, Gaastra Dennis - WO Lists wrote:
Dear colleagues,
This exception just appeared at random during deployment. Yes,
there are multiple WO application instances and multiple sessions
per instance, but this never has caused a problem before. We were
just trying to insert an object into the database. Any tips,
pointers? Frontbase? WO?
You. :-) Add /isolation=read_committed/locking=optimistic to your
URL so that it looks like this:
JDBCUrl = "jdbc:FrontBase://localhost/GVCSiteMaker/
isolation=read_committed/locking=optimistic";
Chuck
EXCEPTION:
com.webobjects.eoaccess.EOGeneralAdaptorException:
EvaluateExpression failed:
<com.webobjects.jdbcadaptor.FrontbasePlugIn$FrontbaseExpression:
"INSERT INTO "Client"("address_PostalZip", "phone_Fax",
"modify_user_id", "create_user_id", "date_Registration",
"notes_textblob_id", "birthDate", "date_LastPayment", "client_id",
"isActive", "sourceInformation", "address_Line1", "address_Line2",
"name_Last", "salesPerson_employee_id", "address_ProvinceState",
"branch_id", "name_First", "date_RTEligible", "modify_date",
"currentBalance", "address_Additional", "address_City3C",
"dlClass_id", "address_Country", "address_City", "division_id",
"create_date", "phone_Home", "dlNumber", "date_LastBooking",
"phone_Cell", "highSchool", "phone_Additional", "office_id",
"eMail", "programCourse") VALUES ('A1Z-5Z1', NULL, NULL, 'rhonda',
TIMESTAMP '2007-01-10 00:00:00.000', 1000633, TIMESTAMP '1951-07-29
00:00:00.000', NULL, 1000553, 1, NULL, '87-Spear Rd', NULL,
'Nesty', 1000018, 'BC', 100000
1, 'Mario', NULL, NULL, NULL, NULL, 'Chi', 1000001, 'Canada',
'Chillilove', 1000002, TIMESTAMP '2007-01-10 11:56:10.003',
'604-793-8439', '6892720', NULL, NULL, NULL, NULL, 1000001, NULL,
'CL-3 ABC($900.00)')">:
Next exception:SQL State:00 subclass = " -- error code:
380 -- msg: Exception condition 380. Pessimistic locking: multiple
transaction conflict detected (deadlock).
Next exception:SQL State:40 subclass = 00 -- error code:
363 -- msg: Exception condition 363. Transaction rollback.
With Kind Regards,
Dennis Gaastra, M.B.A.[sfu.ca], B.Sc.[ubc.ca]
Chief Technology Officer,
WEBAPPZ Systems, Inc.
HQ: (+1) 604.921.1333
Fax: (+1) 604.921.4313
Cell: (+1) 604.787.2532
Web: www.webappz.com & www.1tracker.com
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
40global-village.net
This email sent to email@hidden
--
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