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

MySQL vs ORACLE and JDBC

Peter Tran
Bartender

Joined: Jan 02, 2001
Posts: 783
All,
I've seen a lot of posts regarding mySQL. I've heard some things about mySQL and it all sounds good. I'm currently using Personal ORACLE on my notebook to do some development. This thing is a total memory hog! I have 512M of RAM on this baby (my notebook). Unfortunately, P. Oracle can eat up more than half of it. I can't believe my machine is swapping with 512M!!! These are the questions I have (more like concerns):
1. If I use mySQL, will it each up as much memory?
2. Nothing can eat up as much diskspace as ORACLE, but I'll ask anyway. Does mySQL require a lot of diskspace?
3. Is mySQL pretty robust?
4. Will the JDBC driver implementation for mySQL support JDBC 2.0 functionality?
Thanks,
-Peter
Thomas Paul
mister krabs
Ranch Hand

Joined: May 05, 2000
Posts: 13974
1) I have run MySQL on a PC with 64 meg of ram without any trouble.
2) The zip file was about 8 meg. Unzipped it is less than 20 meg.
3) I haven't had any problems with it. I know that some small-medium size companies are using it as their main database.
4) According to the Sun site, the MM.MySQL driver (which is the one I use) supports JDBC 2.x but it is in Beta. There are at least two other drivers supporting JDBC 2.x listed.
The only problem I had was that the database doesn't support transactions.


Associate Instructor - Hofstra University
Amazon Top 750 reviewer - Blog - Unresolved References - Book Review Blog
liu qingqing
Greenhorn

Joined: Oct 13, 2005
Posts: 1
i think mysql is an very good database, first,it's a smart database which not like oracle once runing will eat a lot of memroy.
Paul Sturrock
Bartender

Joined: Apr 14, 2004
Posts: 10336

MySQL is OK for playing around with JDBC. I wouldn't use it for any other purpose than personal development. If all you want is a small DB for playing around with then HSQLDB is a much smaller DB (their example is an 100k install).

MySQL is (in my opinion) not really a good choice for commercial uses though. The partial support for transactions has all ready been mentioned (InnoDB supports them in its newest version), there is also the problem that only the InnoDB engine supports foreign key constraints. MyISAM is the default, and MySQL allows you to generate DDL statements that specify FK consraints, but the DB engine doesn't actually implement them.


JavaRanch FAQ HowToAskQuestionsOnJavaRanch
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
 
subject: MySQL vs ORACLE and JDBC
 
Similar Threads
Screen Scaping
Got it!!!!!!!
Passed with 97%
Cattle drive has
Is installing J2EE necessary for the exam?