1

My requirements are

  • Embedded Database
  • Easy Integration with Netbeans IDE
  • Should be able to develop using JPA
  • Free of cost
  • Size of the database should be minimum

Please do suggest me a database with the above mentioned features and some pointers to good tutorials regarding that.

rgksugan
  • 3,521
  • 12
  • 45
  • 53
  • 1
    possible duplicate of [Embedded java databases](http://stackoverflow.com/questions/57102/embedded-java-databases) – Pascal Thivent Nov 03 '10 at 06:05
  • 1
    And http://stackoverflow.com/questions/3771962/100-pure-java-database-closed, http://stackoverflow.com/questions/462923/java-embedded-databases-comparison, http://stackoverflow.com/questions/2431546/lightest-database-to-be-packed-with-an-application, http://stackoverflow.com/questions/3444265/simple-and-reliable-in-memory-database-for-fast-java-integration-tests-with-suppo, http://stackoverflow.com/questions/1187974/firebird-vs-hsqldb-at-java etc, etc, etc. Please do a search. – Pascal Thivent Nov 03 '10 at 06:06

3 Answers3

5

I'd suggest HSQLDB. Looking at tutorials of frameworks like Spring and Hibernate, they tend to use HSQLDB as an example of how to use an embedded database with them.

You can use JPA with it, I've personally tried with Hibernate and have had some great results. It's used in projects such as OpenOffice and Mathematica, so that should speak of its quality.

HSQLDB fits 4 of your 5 requirements. Maybe 5 of 5, only because I don't use Netbeans as my IDE. But I'm sure you can try it yourself.

darioo
  • 46,442
  • 10
  • 75
  • 103
  • 1
    I'd recommend H2 database as it's essentially the same as HSQLDB has way better performance and a GUI console app. – Daniel Fath Nov 27 '11 at 16:39
2

H2 database is also a good choice.

Daniel Fath
  • 16,453
  • 7
  • 47
  • 82
Abdullah
  • 13
  • 1
1

Try with apache derby http://db.apache.org/derby/

Janith
  • 580
  • 1
  • 7
  • 14