Hello. In general case, if you want to use multiple databases, you should use only standard SQL features. However, the SQL Standard does not provide any way to fetch the current value of the sequence. Such operation has very low meaning. There are other ways to fetch the generated value during insertion into table. For example, the JDBC has methods and parameters for generated keys. The SQL Standard also has own capabilities. But it looks like you use some weird service that can't use any sane and reliable ways.
For H2 1.4.197 (this version is outdated, BTW) you can use something like SELECT CURRVAL(SELECT SEQUENCE_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'acl_class' AND COLUMN_NAME = 'id') instead. Names of table ('acl_class') and column ('id') may need to be written in upper or lower case depending on way how they were created. -- 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/e2deaebf-2f92-469d-92b4-c800facf99e9%40googlegroups.com.