• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
WO 5.3.3 / SQL-Server and primary key generation
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

WO 5.3.3 / SQL-Server and primary key generation


  • Subject: WO 5.3.3 / SQL-Server and primary key generation
  • From: Michael DeMan <email@hidden>
  • Date: Wed, 11 Jan 2012 12:04:03 -0800

Hi All,

I have a legacy 5.3.3 application that we need to scale up to multiple instances.  It is a pretty big, old and fragile code base - wonderizing it does not seem to be an option.  I reviewed the code and the use cases are separate enough that there is no need for full inter-app EO change notifications - except for primary key generation.  On the primary key generation, I noticed that the SQL being generated is like the below and was thinking that with that UPDLOCK and ROWLOCK on the EO_PK_TABLE, that it might 'just work'.  However, in testing, I was able to get cases where different application instances were colliding on trying to use the same primary key value.


[2012-01-07 12:29:35 EST] <WorkerThread44>  evaluateExpression: <com.webobjects.jdbcadaptor.MicrosoftPlugIn$MicrosoftExpression: "SELECT PK FROM EO_PK_TABLE WITH (UPDLOCK,ROWLOCK)  WHERE NAME = 'PROVIDER_USER'">
[2012-01-07 12:29:35 EST] <WorkerThread44>  evaluateExpression: <com.webobjects.jdbcadaptor.MicrosoftPlugIn$MicrosoftExpression: "UPDATE EO_PK_TABLE SET PK = 2532643 WHERE NAME = 'PROVIDER_USER' AND PK = 2532642">



I am unsure how to proceed and was hoping somebody might be able to give me some pointers.

#1.  Should that SQL above be okay and doing the right thing?  Maybe we just have something set wrong on SQL-Server and it is ignoring the locks?

#2.  Otherwise - I am thinking my best bet is to override the hook in EOF for primary key generation.


Thanks,

- Mike DeMan

 _______________________________________________
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

  • Follow-Ups:
    • Re: WO 5.3.3 / SQL-Server and primary key generation
      • From: Peter Vandoros <email@hidden>
  • Prev by Date: Re: updateValuesInRowDescribedByQualifier fail. ??
  • Next by Date: Re: TinyMCE and AjaxSubmitButton (field values allways set to null)
  • Previous by thread: Re: Properties, Frameworks and App
  • Next by thread: Re: WO 5.3.3 / SQL-Server and primary key generation
  • Index(es):
    • Date
    • Thread