Standalone DB with Hibernate

Question

I have to develop a Spring MVC project. This give user the possibility to work online using normal web access. I also need to give user possibility to work offline.

So I want to develop a standalone java app that the users can install on theirs pc. They can exchange data with server using JSON with Jackson for example.

My question is about the client side. Supposing to handle data with an ORM like Hibernate, which standalone db are best suited for avoid to install DBMS (like mysql, mssql, ...)?

I want to avoid install many software on client.

I have developed a project like this, where the clients are Android tablet, the ORM tool is ormlite and the db sqlite. The db consist in a file.

Thank you for any response!! Marco

BenCole · Accepted Answer · 2012-05-16 15:38:27Z

2

I'd actually recommend H2 Database over Apache Derby. I've used both, and found that Derby can be difficult to configure and access in a non-embedded manner (which may not be an issue for you, but it was for me).

H2 was faster also.

answered May 16, 2012 at 15:38

BenCole

2,1223 gold badges17 silver badges27 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

kostja · Accepted Answer · 2012-05-16 15:07:19Z

2

Apache Derby works well locally, is embeddable, fast and small (2.5 MB).

If you are more comfortable working with "officially supported" products, you could go with JavaDB - it's Derby in disguise.

answered May 16, 2012 at 15:07

kostja

61.8k51 gold badges186 silver badges227 bronze badges

Collectives™ on Stack Overflow

Standalone DB with Hibernate

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related