File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/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


Win a copy of EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
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
Saloon Keeper

Joined: Oct 23, 2005
Posts: 3697
    
    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: 688

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: 39547
    
  27
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 - updated with new look and Ping home screen widget
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: 688

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

Joined: Oct 23, 2005
Posts: 3697
    
    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?
 
Similar Threads
Can I use EJB with a non transactional db?
database & JDBC
Connecting Java Application with a Database
Problem in database connectivity in JSP
connection of JDBC with oracle 9i database