This removes creation and use of a dual_foo table for each sequence.
It is a simplification and also solves failures due to white space before the sequence name in the mapping XML :
<id name="id" type="long" column="ID">
will fail in the old code :
"create table dual_" + sequenceName + " (zero integer)"
which would give the following bad SQL :
create table dual_
I asked you on the dev list to determine the hsqldb version in which support for this was added. Which is it?
22.214.171.124 supports it.
the changelog for 126.96.36.199-188.8.131.52 does not mention adding any new feature like this.
And versions before 184.108.40.206 are not supported by HSQLDialect anyway.
I tried now v 1.7.3 and it also supports the "call next value for seq_name" syntax.
applied to 3.2/trunk