I am using BEA 92 and oracle 10
I have a Entity bean which has a primarykey field mapped to a db column, primary key is generated from @AutomaticKeyGeneration annotation(mapped to seq_one).
This works fine.
I am looking for a solution which will cater to following scenrio.
I am tring to implement a ejbHomeQuery method on the same entity bean which will return me the next value from another database sequence(seq_two).This sequence will not be persisted in entity bean, but will be used somewhere else.
Is it possible to do "select seq_two.nextval from dual" in CMP? or is there any other way where I can get the next value from entity bean without persisting the field.