Which Hibernate compatible database to use for Java Swing application?

Question

I will be implementing a java swing app. At first, I wanted to use apache derby db, because I needed embeded db.

But it turned out that it does not plays nice with hibernate (https://forum.hibernate.org/viewtopic.php?f=6&t=1003258&p=2433546#p2433546, http://stackoverflow.com/questions/3322575/netbeans-derby-hibernate).

Hibernate ignores auto generated keys and foreign keys...

Can you recommand some db that can be embeded and nicely used with hibernate, or derby can work well with hibernate but I'm doing it wrong?

Thanks in advance.

Answer 1

Try Hypersonic SQL.

Answer 2

I prefer h2, the "Hypersonic 2". See http://www.h2database.com/html/features.html#comparison for a comparsion.

Answer 3

Have you thought of MySQL embedded

Answer 4

All in all, I tested Derby and HSQL, tried to make simple hibernate CRUD app with netbeans.

Both of them set which you need to manually change to if you don't want to worry about generating primary keys, which is not a big deal.

But, derby pojos and mapping files totally ignore foreign table references, didn't tried to add them by hand, but netbeans does not generate them.

HSQL does not have this problem.

People are complaining about corrupted data and inconsistency, they are migrating from HSQL to Derby and from Derby to HSQL.

I don't know if HSQL is good for me and my production use. I would use it in embeded mode for desktop app, and one version for network usage, where it will be in server mode probably, so both.

All suggestions are welcome.