[CAY-351] Switch HSQLDB to use sequences for PK generator

• Type: Improvement
• Status: Open
• Priority: Minor
• Resolution: Unresolved
• Affects Version/s: 3.0
• Fix Version/s: Undefined future
• Component/s: Database integration
• Assignee: Mike Kienenberger
• Reporter: Andrus Adamchik
• Created: 22/Aug/05 22:51
• Updated: 24/Sep/13 20:30

Description

HSQLDB since 1.7.2 supports sequences:

http://hsqldb.org/doc/guide/ch09.html#create_sequence-section

This is probably much better way to make primary key than auto_pk_table (hopefully there is no concurrency issues like CAY-245). Once challenge in doing this switch is that we need to implement a migration procedure for CayenneModeler preferences.