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 [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/h2-database/e2deaebf-2f92-469d-92b4-c800facf99e9%40googlegroups.com.
