> > Do you have an option to enable this on h2? > What exactly do you want to enable?
You can use GENERATED BY DEFAULT AS IDENTITY (CACHE 1) instead of AUTO_INCREMENT to disable the cache of the sequence. The default cache size is 32. Cached identities may be lost on abnormal termination of the process. However, you should check why your application does not shutdown the database properly. -- 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 h2-database+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/h2-database/3aa90f02-f140-48ef-aac5-fc077710d558%40googlegroups.com.