title: auto increment ID in H2 database
body: <p>Is there a way to have an auto_incrementing BIGINT ID for a table.
  It can be defined like so</p>
  
  <pre><code>id bigint auto_increment
  </code></pre>
  
  <p>but that has no effect (it does not increment automatically).
  I would like to insert all fields but the ID field - the ID field should be provided by the DBMS.
  Or do I need to call something to increment the ID counter?</p>