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 06:35:33 -0400
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
(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