aspose file tools*
The moose likes JDBC and the fly likes Which database should be used? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Which database should be used?" Watch "Which database should be used?" New topic
Author

Which database should be used?

Shivani Prajapati
Greenhorn

Joined: Aug 23, 2006
Posts: 9
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
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
author
Saloon Keeper

Joined: Oct 23, 2005
Posts: 3710
    
    5

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.


My Blog: Down Home Country Coding with Scott Selikoff
Kaydell Leavitt
Ranch Hand

Joined: Nov 18, 2006
Posts: 689

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
Marshal

Joined: Mar 22, 2005
Posts: 42264
    
  64
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.


Ping & DNS - my free Android networking tools app
Amit M Tank
Ranch Hand

Joined: Mar 28, 2004
Posts: 257
Use Lightweight 100% Java SQL Database Engine


http://www.hsqldb.org/


Amit Tank
Linked In
Kaydell Leavitt
Ranch Hand

Joined: Nov 18, 2006
Posts: 689

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
author
Saloon Keeper

Joined: Oct 23, 2005
Posts: 3710
    
    5

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 ]
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Which database should be used?