File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes Database Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Head First Android this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Database" Watch "Database" New topic


Hossam Ismail

Joined: May 02, 2004
Posts: 1
what are the disadvantages of JData Store which in JBuilder?
which is better as a database Oracle, mysql ,ms sql server,JData Store?
Stefan Wagner
Ranch Hand

Joined: Jun 02, 2003
Posts: 1923

It depends on your needs.
MySql is far away from standards, missing subqueries and loved by webhackers - because of it's silly name. If you're looking for an OpenSource Database which is a bit professional, have a look at postgresql.
MSsqlServer is bad. A) it's from Micorsoft. B) it's bad.
Once I was forced to use it, and made a query to timefields. I took the value as string. I send the same string back for update. It worked fine till '03-12'. On '03-13' it gave me an error. And - did I mention it is from MS?
Oracle is the market-leader. Fast, big - and expensive.
For small projects I would have a look at hsqldb - a pure java/in-memory-db.
JDataStore is a perfect stranger to me.
I agree. Here's the link:
subject: Database
It's not a secret anymore!