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
Ranch Hand
Joined: Jul 17, 2006
Posts: 387
posted
0
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.
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.
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
Marshal
Joined: Mar 22, 2005
Posts: 35238
7
posted
0
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.
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 ]