Fix the batch sequence generation for the 2.x version of H2

[marschall]

Due to h2database/h2database#3483 batch sequence generation is broken on versions 2.x of H2.

There are two possible fixes:

We could special case the H2 dialect and use this query

SELECT NEXT VALUE FOR sequenceName
  FROM SYSTEM_RANGE(1, ?);

Or we could simplify / change the default query to

WITH RECURSIVE T(N) AS (
  SELECT 1
   UNION ALL
  SELECT N + 1
    FROM T
   WHERE N < ?
)
SELECT NEXT VALUE FOR sequenceName
  FROM T;

[vladmihalcea]

Thanks for spotting it. Let's change the default query. Would you like to send a Pull Request with the fix?

[marschall]

Yes, I can do a PR.

[vladmihalcea]

Looking forward to it

[vladmihalcea]

Thanks, I integrated it.