title: Autoincrement with Grails/Hibernate for different DBs
body: <p>it's not a realy problem, but it surprises me:</p>
  
  <p>when I use Grails with diffrent DBs, I get different counter increments...:</p>
  
  <ul>
  <li>with the ootb hsqldb, every table gets its own counter which is always increased by 1</li>
  <li>with an oracle db, it seems that all tables use the same global counter</li>
  <li>now I am using javadb/derby and the generated id are huge!</li>
  </ul>
  
  <p>where can I find some more information about this behaviour and which one is the best?</p>
  
  <ul>
  <li>hsql seems to keep the counters small</li>
  <li>with oracle, I get a global unique id - also a nice feature</li>
  <li>but what about the derby behaviour?</li>
  </ul>