title: Which Hibernate compatible embedded database to use for Java Swing application?
body: <p>I will be implementing a Java Swing app. At first, I wanted to use Apache Derby DB, because I needed an embedded DB. </p>
  
  <p>But it turned out that it does not plays nice with hibernate (<a href="https://forum.hibernate.org/viewtopic.php?f=6&amp;t=1003258&amp;p=2433546#p2433546" rel="nofollow noreferrer">https://forum.hibernate.org/viewtopic.php?f=6&amp;t=1003258&amp;p=2433546#p2433546</a>, <a href="https://stackoverflow.com/questions/3322575/netbeans-derby-hibernate">Netbeans + derby + hibernate</a>).</p>
  
  <p>Hibernate ignores auto generated keys and foreign keys...</p>
  
  <p>Can you recommend some DB that can be embedded and nicely used with Hibernate, or tell me how to make Derby work well with Hibernate?</p>