Hi, I'm attempting to user Cache with an O/R mapper e.g. hibernate, castor,
etc and I'm stumbling on key generation. The senarios are:
Identity Method
1.) execute insert statement
2.) retrieve autoincrement ID via SQL e.g. select @@identity
Sequence Method
1.) execute SQL call to generate the sequence e.g. select myseq.nextval
from dual
2.) retrieve the sequence ID
3.) execute insert statement with the ID
Has anyone attempted either of these methods in Cache? If so, I would
appreciate any advice you can provide on the subject.
Thanks in advance,
Micah
