Re: Exception: Deployment - FrontbasePlugIn - deadlock - WHY
Re: Exception: Deployment - FrontbasePlugIn - deadlock - WHY
- Subject: Re: Exception: Deployment - FrontbasePlugIn - deadlock - WHY
- From: Zhijie Guan <email@hidden>
- Date: Wed, 10 Jan 2007 14:42:27 -0800
Is it related to the JDBC driver between WO and Frontbase? Have you
updated all your systems with the latest JDBC driver for Frontbase?
Zhijie
KITP, UCSB
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? Thanks.
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:
40kitp.ucsb.edu
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