It's not a secret anymore!*
The moose likes JDBC 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
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: 1121

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
Similar Threads
Best JDBC drivers?
How Can I Use Type 4 Driver for MS-Access and Oracle
JDBC type 3 driver
JBoss 4.0 and MSSQL Server 2000
JDBC:ODBC bridge for remote access