Then I will give you my fresh suggestion.
Do not use autoincrement for your keys.
This is discussed in depth on the web in various articles, but I can
give you one good reason now - not portable. Autoincrement is supported
only in some databases. Furthermore, often, simple integer keys are not
a very good idea, especially if they are 32 bit based. Finally, it is
often considered better to use keys that are unique across all tables,
even databases sometimes, which is not the case when you use autoincrement
on a table basis.
If you have no choice but to use the feature, then I believe both a BMP
and CMP solution have been posted to this list, and I don't think you
will improve upon them greatly. There have also been some useful postings
on the Orion mailing list.
HTH,
tim.
> Of course not, but I'm looking for solutions that people have actually
> implemented. I know that there are ways to do it. And I did read the
> archives. I am looking for fresh developers suggestions. Maybe someone
> has discovered a solution since the last message was posted. Thanks for
> your contribution...
>
> --------------------------------------------------
> Kevin E. Gaasch
> Anderson Merchandisers, Inc.
> Java Application Development
> Lotus Notes Development
> [EMAIL PROTECTED]
> (806)376-6251 ext. 4819
> (800)999-0904 ext. 4819
>
> "Chaganthi,
> Madhusudan R." To: [EMAIL PROTECTED]
> <[EMAIL PROTECTED]> cc:
> 02/05/01 03:22 PM
>
> It doesnt hurt to go through the archives once. Would it?
>
> -----Original Message-----
> From: Kevin Gaasch [mailto:[EMAIL PROTECTED]]
> Sent: Monday, February 05, 2001 2:52 PM
> To: [EMAIL PROTECTED]
> Subject: Autonumber primary keys
>
>
> I would like to see everyone's suggestions on how to handle Automatically
> generated primary keys. Utility objects, vendor specific, etc...
>
>
> --------------------------------------------------
> Kevin E. Gaasch
> Anderson Merchandisers, Inc.
> Java Application Development
> Lotus Notes Development
> [EMAIL PROTECTED]
> (806)376-6251 ext. 4819
> (800)999-0904 ext. 4819
===========================================================================
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".
