Win a copy of Design for the Mind this week in the Design forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Which database should be used?

 
Shivani Prajapati
Greenhorn
Posts: 9
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 387
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 4010
18
Eclipse IDE Flex Google Web Toolkit
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 689
Eclipse IDE Firefox Browser Mac OS X
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Rancher
Posts: 42967
73
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 257
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Use Lightweight 100% Java SQL Database Engine


http://www.hsqldb.org/
 
Kaydell Leavitt
Ranch Hand
Posts: 689
Eclipse IDE Firefox Browser Mac OS X
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 4010
18
Eclipse IDE Flex Google Web Toolkit
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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 ]
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic