Desktop application in java with database

Question

I am trying to implement an application for a friend who sells t-shirts and hats, so we are dealing with interconnected tables. I was wondering what would be the perfect libraries to achieve this goal. What kind of database should I use to make it portable and easy to deploy. I would really like to insist on the database stuff, what should I use?

Thank you so much (I use Netbeans)

Answer 1

It seems like it needs to go production. Better go for H2, its a better, faster HSQLDB.

Answer 2

Check out Hypersonic and Derby. They are embedded databases that store their data in a simple file so you don't have to worry about installing and managing a complex system like mysql or postgres or sql server. They work with the regular jdbc front end.