What about creation of "SequeneEJB", which will generate
those numbers for you.
They are indexed using bean names, and every bean having
need in sequence number could call up this sequene EJB for a new ID
Alternative would be to specify some environment variable in DD for a bean in question.
I also wrote some utility clases which perform necessary lookup and makes programming really easy ( basically
calling static method on utility class )
What is SequeneEJB?
I guess what Konstantin means is that u can create an EJB (session) that u can name as equenceEJB. This bean will have a method getId() that will actually talk to the DB to get a sequence number (from a pre-defined DB sequence).
there is a good code example in theserverside.com
I Think that you have to be registered to download the code, but it's free.
Good Luck, Enrique