which database is good to use???

Hey guys could you please tell me which database is good to use for the java programming language??????

 

i use mysql or msaccess

you can use any db which supports odbc in windows using jdbc

both hv some advantages and disadvantages

Regards

Alex

 

I would go with MySQL or MSSQL. Either should have good integration with Java, and both are fast and stable databases,

 

MSSQL is a little more powerful database server in terms of security, but it does cost money.

 

SQL Server Express (2008 just came out) is free and easy to use and very powerfull. Most people (even businesses) never even come close to using it to capacity.

 

Java is usually used for big and expensive projects. So it's usually combined with Oracle.
PostgreSQL has similar to Oracle architecture and sql syntax and it's free.
MySQL on the other hand is better suited for web applications that do not need the scalability of the above two.

Btw SQL Server Express supports databases, not bigger than 2 GB. Might be good in some limited cases.

 

I recommend using Oracle as vasago suggested and MySQL being available on both Linux and Windows. MySQL is really suitable for web applications and you might need to work with JSP for small projects then you should have experience with Java+MySQL.

 

I also recommend Oracle. but if you're on a budget / beginner / comfortable with LAMP, just go with mysql.

 

if you're into MS. then MS SQL Server is an obvious choice.