wood burning stoves 2.0*
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


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Advice of database type is needed" Watch "Advice of database type is needed" New topic
Author

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
2. MS SQL SERVER
3. MYSQL
Can anyone suggest which db should we purchase??
Background of out project:
-arround 5 tables
-jsp, servlet, java beans application
Thanks
Avi Abrami
Ranch Hand

Joined: Oct 11, 2000
Posts: 1121

MySQL
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.
 
Don't get me started about those stupid light bulbs.
 
subject: Advice of database type is needed
 
Similar Threads
JDBC type 3 driver
How Can I Use Type 4 Driver for MS-Access and Oracle
Best JDBC drivers?
JDBC:ODBC bridge for remote access
JBoss 4.0 and MSSQL Server 2000