If you use declare the Oracle sequence to increment by more than
1 (eg, 50), you don't have to make calls to the database each
time you need a new unique sequence number.
-eric
Mihir Mehta wrote:
>
> Hi,
>
> I have gone through the archive and realized that the two safe options
> for implementing database (Oracle) base primary key generation are
>
> 1. Singleton Entity Bean (BMP)
> 2. Stateless Session Bean
>
> I am going to use Oracle Sequence to generate the primary keys.
>
> Questions :
>
> 1. Which one is better - using a singleton entity bean (BMP) or
> stateless session bean in terms of performance ?
>
> 2. What are the tradeoffs of using James Cook's UUID generation bean
> versus a sequence in Oracle database.
>
> - UUID option generates large ids
> - Using Oracle Sequence requires accessing the database
> - How much do large ids affect an application that does a lot of
> complex queries ?
>
> Thanks for your help and suggestions.
>
> Mihir
>
> ===========================================================================
> 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".
===========================================================================
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".
