Dbunit and hsqldb - identity generation
<p>I'm working on a framework upgrade for one of my projects, and amongst other things I'm upgrading <code>Hibernate</code> + <code>HSQLDB</code> + <code>DbUnit</code>.</p>

<p>I have some testdata to form the basis of my dbunit test in an excel schema, and some data looking like this:</p>

<pre><code>Table Something
id   | name
101  | Something
102  | Something else
</code></pre>

<p>With an entity looking like this:</p>

<pre><code>@Entity
public class Something implements Serializable {

    @Id
    @GeneratedValue(strategy = GenerationType.AUTO)
    private Long id;
</code></pre>

<p>In my previous version, when adding a new Something to the database, its <code>id</code> will continue the sequence of the testdata, making it <code>103</code>. But, in the new version it generates id <code>1</code>. </p>

<p>One of my testdata tables have id's 1-8, which results in a PK constraint violation, since the added entity will get id <code>1</code>. </p>

<p>Is there some setting I can use to get the old behaviour back, where the ids of the testdata act as a basis for the identity generation?</p>