Primary key generation

Ricardo Parada <[email protected]> Wed, 24 Sep 2025 14:27:49 -0400
Newsgroups gmane.comp.java.cayenne.user
Message-ID <[email protected]>
Hello all,

I haves beginner’s question. 

We have an Oracle database which we currently use with Apple’s Enterprise Objects Framework (EOF). 

For every table name, e.g. ORDER there is a sequence derived from the table name and spending “_SEQ”, e.g. CLAIM_SEQ. 

How is this handled in Cayenne normally? Will it derive the sequence name correctly?

The modeler gives me three options:

Cayenne-Generated (Default)
Database-Generated
Custom Sequence

Which one would be the right one for this database? 

Thank you
Ricardo Parada