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 Advice of database type is needed 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 "Advice of database type is needed" Watch "Advice of database type is needed" New topic

Advice of database type is needed

carl chan
Ranch Hand

Joined: Mar 12, 2003
Posts: 42
Hi all
My company need to purchase a copy of database software out of 3 choices because of the hosting server only support 3 type of db.
1. MS Access
Can anyone suggest which db should we purchase??
Background of out project:
-arround 5 tables
-jsp, servlet, java beans application
Avi Abrami
Ranch Hand

Joined: Oct 11, 2000
Posts: 1141

Amy Phillips
Ranch Hand

Joined: Apr 02, 2003
Posts: 280
don't go with Access, there are too many issues like number of record limits etc. It is also difficult to later change to another database due to the fact you have to use special access SQL statements.
I agree. Here's the link:
subject: Advice of database type is needed
It's not a secret anymore!