Oracle sequences for PK generation

Markus Ruggiero <[email protected]> Fri, 4 Jul 2008 21:47:05 +0200
Newsgroups gmane.comp.web.webobjects.devel
Message-ID <[email protected]>
Hi,

I am to create a (small) WO app that sits on top of an existing Oracle  
DB. One requirement I cannot change is that each table has an  
associated sequence for the primary key. So I cannot use EOF's  
automatic PK generation but I have to get the next value from the  
corresponding sequence. What options do I have? What have others done  
in such a situation, what are your experiences? How do you access the  
sequence? Model it as kind of an entity? Use raw SQL? Use the adaptor  
delegate to provide the PK? Simply trat te PK attribute like a  
"normal" attribute and assign a value to it?

Thanks for any help
---markus---