JDBC:what DB is recommended to use?

[gaboware]

Hi people,
I would like some advice on what DB is recommended to use with JDBC. Currently, I am using MSAccess. I know there is MySQL and others but in a multi-tiered app, which database is good to use. Good to use in terms of performance, scalability and affordability. Also, is there a prefered db for stand-alone applications and web applications. In other words, is the use of a certain database better through a web application rather than on a Swing application.

Thanks!

 

[wushutwist]

Depends on alot of factors.

Oracle8i - expensive but good performance
DB2 - expensive and hard to find Administrators compared to Oracle
SQL Server - OK and alot cheaper than Oracle but you will pay out the rear for a JDBC driver (and don't say use JDBC-ODBC bridge because that is slow as heck)
Access - Cheap price, cheap quality, you get what you pay for and please but the good grace of God, do not use this as a backend for a web application.
MySQL - good and free but it doesn't support transactions(show me the money) and foreign keys (still better than Access)

Wushutwist