I'm facing issue with Sequences. The system generated sequences via auto_increment work fine with hibernate. But the custom made sequences fail to work with hibernate.
When using auto_increment, I want to set the min,max and starting value. The only way I found to do it is via two queries as follows - select SEQUENCE_NAME FROM INFORMATION_SCHEMA.COLUMNS where table_name='DUMMY' and column_NAME='ID' alter sequence SYSTEM_SEQUENCE_768B1C27_B791_41AE_ADBD_5F71B00 MINVALUE 1 MAXVALUE 9999999999 INCREMENT BY 1 RESTART WITH 1040 CACHE 20 NOCYCLE; I'm looking for a way where I can use nested queries, such that the output of first query can be fed as 'sequence_name' to the alter query. -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
