Which database should be used?

[Shivani Prajapati]

Hello Friends
I am new in JDBC programming. I just started learning JDBC. And i have one question - which database i should use? Would you please help me in selecting database. And which software will be needed for working on that database using JDBC.

thank you

[Herman Schelti]

hi Shivani,

JDBC (and SQL) are meant to be database-independent.

If you use JDK6 it comes with a database (Derby), so you don't have to install any drivers.

Herman

[Scott Selikoff]

MySQL is a good (free) all around database. Oracle also offers light versions of their product for developers but that can be a bit too much for beginners.

[Kaydell Leavitt]

MySQL is a good (free)

Isn't mySQL only free for non-commercial use and isn't there a royalty for commercial use?

I believe that Derby is royalty-free for all uses.

Kaydell

[Ulf Dittmer]

Originally posted by Kaydell Leavitt:
Isn't mySQL only free for non-commercial use and isn't there a royalty for commercial use?

MySQL is released under the GPL, so there is no royalty to be paid for commercial use that doesn't involve distribution.

The MySql web site is deliberately vague on this point, though - they very much want commercial users to buy a support contract; but it's not required.

[Amit M Tank]

Use Lightweight 100% Java SQL Database Engine


http://www.hsqldb.org/

[Kaydell Leavitt]

Use Lightweight 100% Java SQL Database Engine

Does HSQLDB have any royalties?

How does it compare to Apache Derby (also known as IBM Cloudscape and known as Sun's Java DB)?

Kaydell
[ June 25, 2007: Message edited by: Kaydell Leavitt ]

[Scott Selikoff]

Side note- I suggested MySQL because if you're getting started in JDBC for the first time and need a learning tool, you're probably *not* making the decision to release products for a commercial company

PS And even if you are, then if you are a beginning you should *definitely* use MySQL in this case so you don't waste tons of money buying DBMS software you might not learn to use. Oracle, MySQL and DB2 ain't cheap for real licenses.
[ June 25, 2007: Message edited by: Scott Selikoff ]