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 mySQL, MS access, Oracle ...spec question Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "mySQL, MS access, Oracle ...spec question" Watch "mySQL, MS access, Oracle ...spec question" New topic

mySQL, MS access, Oracle ...spec question

Peter Primrose
Ranch Hand

Joined: Sep 10, 2004
Posts: 755

Say I have to create a database with the following spec:

500 users,
30 simultaneous connections,
All information in the db will be text and will not exceed 200Mb

What db should I use?

I�ve been using MS for a while and it worked great, however, I learned that mySQL is much more robust and FREE. As per Oracle � I�m not sure.

Anyone can help on this one?

"I�m the wonder�"
Bear Bibeault
Author and ninkuma

Joined: Jan 10, 2002
Posts: 63865

While Access may be a great little personal database -- I used it quite a bit when I was still using Windows to keep track of personal data -- it is by no means production-capable. And, unless things have changed a bit, you will be saddled with the ODBC-JDBC bridge in order to use it from Java.

Free databases like MySQL and PostgreSQL (I use the latter for my commercial sites) certainly have the chops for the job.

[Asking smart questions] [About Bear] [Books by Bear]
I agree. Here's the link:
subject: mySQL, MS access, Oracle ...spec question
It's not a secret anymore!