Hi Gino As you require a number that needs to be unique across all instances, you will have to maintain a number generator out of the WO Application. For this you may have to rely on a data generator at database level more than WO and then assign this new number from the database by using generator functions of DB while inserting in WO EOModels. The same can be alternately done by auto allocate DB functions at DB level e.g. Triggers on each insert as in oracle.
If you implement it in WO, the inserts are faster at DB level but if you implement it from DB, the inserts are slower at DB level. The catch is that overall in the first alternate you will just experience an overhead of channel interfacing and retrieving the number from the DB to WO. Thanks, Ashish On 2/6/06 6:27 AM, "Gino Pacitti" <[EMAIL PROTECTED]> wrote: > Hi All > > Any thoughts on how to address this problem > > I have a multi instance app that connects to a single data store. > > For any user, across the instances, I need to increment a numerical > value newly for each new registered user. > > This then has to be saved back to the data store and for there to be > no conflicts with similar values for new registrants... > > Any ideas or have I missed something easy here.. > > Gino > > > _______________________________________________ > Do not post admin requests to the list. They will be ignored. > Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) > Help/Unsubscribe/Update your Subscription: > http://lists.apple.com/mailman/options/webobjects-dev/ash.ashish.ash%40gmail.c > om > > This email sent to [EMAIL PROTECTED] -- _______________________________________________ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to archive@mail-archive.com
