On Sunday, September 8, 2002, at 12:37 , Dmitri Colebatch wrote:

> no - dont do that for the reasons you indicate.  Instead use a
> sequence, or
> other database generated number (my opinion).  given the current
> options,
> this is my preferred choice - and you will not incur the cost of
> locking the
> table.  (note here that a sequence is a vendor specific thing).

What about simply using an UUID instead? That way you can generate a
truly unique primary key on the client side and not incur any overhead
communicating back and forth with the server just to get a key.

PA.

===========================================================================
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff EJB-INTEREST".  For general help, send email to
[EMAIL PROTECTED] and include in the body of the message "help".

Reply via email to