sql - how to return last inserted (auto incremented) row id in HSQL?

Question

i am working with HSQL database for testing purpose. i want standalone db file. but now i am in trouble to get last inserted row id (auto-incremental - identity) in HSQL. how can i get id??

Answer 1

http://www.hsqldb.org/doc/guide/ch09.html

the last inserted value into an identity column for a connection is available using the function IDENTITY(), for example (where Id is the identity column):

INSERT INTO Test (Id, Name) VALUES (NULL,'Test');
CALL IDENTITY();