Hi all I've been looking at the sequence support in DBDictionary and extending it for Ingres. Ingres supports native sequences, but it seems that by default, OpenJPA prefers to use the OPENJPA_SEQUENCE_TABLE for internal sequence numbering. Setting openjpa.Sequence=native changes this to use the native sequences.
Is there a way/would it be desirable to set a preference for native sequences in the DB Dictionary? I don't see this in any other dictionary, so I assume it's not desirable. Perhaps this is so the schema is predictable? Thanks Alan
