File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes Object Relational Mapping and the fly likes which DB to use for practice ? mysql or oracle? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » Object Relational Mapping
Bookmark "which DB to use for practice ? mysql or oracle?" Watch "which DB to use for practice ? mysql or oracle?" New topic

which DB to use for practice ? mysql or oracle?

suresh mandalapu
Ranch Hand

Joined: Sep 14, 2008
Posts: 32
HI, i started looking into hibernate and which DB knowledge is good regarding job point of view? either mysql or oracle?
i am a newbee to sql/mysql/oracle..
initially i wanted to learn mysql.But now i am confused of learning oracle or mysql?
i posted this doubt in jdbc /spring forum also... sorry ..
Ram Para
Ranch Hand

Joined: Jul 09, 2008
Posts: 50
MYSQL is a good option. In 5.x you can find most of the functionalities.

Ofcourse its not robust like Oracle.

for start up I suggest go with MYSQL.

But from JOB perspective You should go for oracle.

I suggest go with MYSQL then migrate to Oracle

Ram Parashar
Cameron Wallace McKenzie
author and cow tipper
Saloon Keeper

Joined: Aug 26, 2006
Posts: 4968

Howdy Greenhorns!

MySQL is real easy to play with, and easy to install. I don't even think it pings the registry or anything. Whenever I test a new technology, I like using MySQL - it tends to not get in the way too much.

Here's a little CBT tutorial I put together on setting up a Windows environment with MySQL. Enjoy:

Setting up a MySQL Environment on an XP Machine

-Cameron McKenzie
suresh mandalapu
Ranch Hand

Joined: Sep 14, 2008
Posts: 32
Sagar Rohankar
Ranch Hand

Joined: Feb 19, 2008
Posts: 2904

Is it really matter ? All you have to know is sql ans pl/sql thing, If you have the database design knowledge like normaliazation, then it comes handy in understanding the database.

[LEARNING bLOG] | [Freelance Web Designer] | [and "Rohan" is part of my surname]
Paul Sturrock

Joined: Apr 14, 2004
Posts: 10336

Well, if you need to know PL/SQL, MySQL is no use.

Big databases like Oracle present quite a learning curve just to get going. With MySQL you can just get stuck in. On the flip side, MySQL is quite lax about some fairly key relational database concepts (for example, the MyISAM DB engine does not enforce constraints!) so if you are planning to do any database backed programming long term mix it up and use both.

JavaRanch FAQ HowToAskQuestionsOnJavaRanch
Sandeep Awasthi
Ranch Hand

Joined: Oct 23, 2003
Posts: 597
It does not really matter much if you use mysql or Oracle if you want to focus on Spring and Hibernate. Would be better if you use Oracle if you have job focus because it has been used in many enterprise level applications. If you do not want to use PL/SQL, you can choose to not to use it.

I agree. Here's the link:
subject: which DB to use for practice ? mysql or oracle?
It's not a secret anymore!