CODEWITHSUNDEEP
javadatabase
fenec
fenec

Reputation: 5806

Desktop application in java with database

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)

Upvotes: 2

Views: 3236

Answers (9)

Ted Kenney
Ted Kenney

Reputation:

Another option is Perst, an open source, object-oriented database that is 100% Java.

For info on Perst, see www.mcobject.com/perst.

You can download Perst, with source code, at www.mcobject.com/perst_eval.

Upvotes: 0

Joey Robert
Joey Robert

Reputation: 7604

Here is a Java binding for SQLite. SQLite is very lightweight and should suit your needs very well.

A nice database editor is also a godsend. I recommend SQLite Manager, a Firefox plugin, when working with SQLite.

Upvotes: 3

Hugues Van Landeghem
Hugues Van Landeghem

Reputation: 6808

You can use Firebird with JayBird

Firebird is free, very easy to install and setup with good backup

Upvotes: 0

Surya
Surya

Reputation: 4992

We used HSQLDB initially for a similar application . But after going to production with it some of the users experienced random data corruption ( look though their forum, it seems like a common issue ), So we switched to Derby which proved to be stable . So my vote is Derby .

Also, I would stay away from hibernate for desktop applications due to huge startup time (it has to prepare the metadata upfront ), unless you only have few tables / models.

Upvotes: 1

Adeel Ansari
Adeel Ansari

Reputation: 39907

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

Upvotes: 4

Nuno Furtado
Nuno Furtado

Reputation: 4568

For the engine, look into embedded databases like sqllite, derby and hsqldb

For the integration you can either keep it simple and use plain old JDBC which will make things easier to an extent or go the Hibernate or JPA way

Upvotes: 1

chburd
chburd

Reputation: 4159

you can also use SQLite

Upvotes: 0

Yaneeve
Yaneeve

Reputation: 4779

I would use Hibernate (or JPA) in order to create a standard mapping between the relational database and the object oriented java design.

As far as databases are concerned I often use MySql or Oracle XE which are free and robust enough for your purposes.

Upvotes: 0

Jeremy Huiskamp
Jeremy Huiskamp

Reputation: 5304

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.

Upvotes: 3

Related Questions