Get H2 Database Version String

For retrieving the server version of a H2 database you connect to use

SELECT H2VERSION() FROM DUAL

which returns something like 1.3.174

Recently needed this for preventing an application being started with a specific version of H2 (which contained a specific bug), and the only reference on google was this issue entry

This entry was posted in Software. Bookmark the permalink.