aspose file tools*
The moose likes JDBC 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

Win a copy of Soft Skills this week in the Jobs Discussion forum!
JavaRanch » Java Forums » Databases » JDBC
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: 61753

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] [Bear's FrontMan] [About Bear] [Books by Bear]
I agree. Here's the link:
subject: mySQL, MS access, Oracle ...spec question