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".
