Re: Exception: Deployment - FrontbasePlugIn - deadlock - WHY
Re: Exception: Deployment - FrontbasePlugIn - deadlock - WHY
- Subject: Re: Exception: Deployment - FrontbasePlugIn - deadlock - WHY
- From: Kieran Kelleher <email@hidden>
- Date: Tue, 23 Mar 2010 12:57:10 -0400
Thanks Chuck. Yes, that is what I meant .....my excuse is that it was an example and also the some-other-timezone-time shown below that I sent that! ;-)
On Mar 23, 2010, at 12:51 PM, Chuck Hill wrote:
>
> On Mar 23, 2010, at 3:35 AM, Kieran Kelleher wrote:
>
>> If you mean a currently deployed app, the easiest way would be
>>
>> (1) Set the prop as a launch argument in the WOMonitor settings like this (launch arg props override Properties files)
>> -DdbConnectURLGLOBAL=jdbc:frontbase://localhost/netBrackets
>
> Kieran meant:
>
> -DdbConnectURLGLOBAL=jdbc:frontbase://localhost/netBrackets/isolation=read_committed/locking=optimistic
>
>
>>
>> (2) Launch a new instance
>>
>> (3) Refuse Sessions or kill the old instance
>>
>> HTH, Kieran
>>
>> On Mar 23, 2010, at 2:35 AM, Jeff Schmitz wrote:
>>
>>> btw, any way to get a running app to re-read that prop?
>>>
>>>
>>> On Mar 23, 2010, at 1:18 AM, Jeff Schmitz wrote:
>>>
>>>> and bingo. in the eomodel properties file...
>>>>
>>>> #Connection Dictionary
>>>> dbConnectURLGLOBAL=jdbc:frontbase://localhost/netBrackets
>>>>
>>>> thanks again!
>>>>
>>>>
>>>> On Mar 23, 2010, at 12:58 AM, Chuck Hill wrote:
>>>>
>>>>> Look at how the connection dictionary gets set in deployment: is there a property file or arguments in JavaMonitor that override what is in the model?
>>>>>
>>>>> Chuck
>>>>>
>>>>>
>>>>>
>>>>> On Mar 22, 2010, at 10:48 PM, Jeff Schmitz wrote:
>>>>>
>>>>>> I was seeing the same thing as below and it was very repeatable on both my development and deployment machines. I made the suggested change, and the error went away on my development machine. However when I install the new build on my deployment machine, I still get the error (very repeatably). Is there something extra I need to do to make sure that kind of change gets installed when you build and deploy your project? As a note, my EOModel resides in a framework project that I build and install separately from my main project. And yes, I have installed both parts and still am seeing the error.
>>>>>>
>>>>>> Thanks,
>>>>>> Jeff
>>>>>>
>>>>>>
>>>>>> On Jan 10, 2007, at 4:39 PM, Chuck Hill wrote:
>>>>>>
>>>>>>>
>>>>>>> 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:
>>>>>>>>
>>>>>>>> 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
>>>>>>
>>>>>
>>>>> --
>>>>> 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
>>>
>>> _______________________________________________
>>> 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