Granny's Programming Pearls
"inside of every large program is a small program struggling to get out"
JavaRanch.com/granny.jsp
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


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
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
Author

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 spring..so 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 ..
thanks
suresh
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
http://doinfinite.com
Cameron Wallace McKenzie
author and cow tipper
Saloon Keeper

Joined: Aug 26, 2006
Posts: 4968
    
    1

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
thanks
Sagar Rohankar
Ranch Hand

Joined: Feb 19, 2008
Posts: 2902
    
    1

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
Bartender

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.


Sandeep
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: which DB to use for practice ? mysql or oracle?
 
Similar Threads
new to hibernate need sample
which DB to use for practice ? mysql or oracle?
i am using orcale, mysql databases , if i use context.xml i can get datasource for only one db
which DB to use for practice ? mysql or oracle?
java.sql.SQLException: Io exception: The Network Adapter could not establish the connection