What is the best database to use with a java program? [closed]

Question

I've been struggling to get a Java program to connect to MS SQL Server, and I'm starting to wonder if MySQL would be a better choice for my (learning) project.

Sun's tutorials refer to Java DB, but I've never heard of that in any other context, so it seems not the most useful database to learn about.

I appreciate any insight into the most natural way to connect Java to a commonly used database.

Answer 1

Perhaps you could describe the problems you've been having with connecting to MS SQL. Of course it's possible, so it's likely something small that you have or have not done that's preventing the connection from working.

There are many open source database servers with JDBC drivers. One that you might consider is HSQLDB which has a completely in-memory mode so you don't even have to think about setting up a server. This is probably a great way to learn the basics of SQL.