File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and the fly likes Database Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Database" Watch "Database" New topic
Author

Database

Hossam Ismail
Greenhorn

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.


http://home.arcor.de/hirnstrom/bewerbung
 
jQuery in Action, 2nd edition
 
subject: Database