Results 1 to 17 of 17
Like Tree1Likes
  • 1 Post By Tolls

Thread: Q : which database is best for java?

  1. #1
    rjagan's Avatar
    rjagan is offline Member
    Join Date
    Feb 2011
    Location
    Puducherry
    Posts
    53
    Rep Power
    0

    Post Q : which database is best for java?

    Hi Friends,
    am new to develop database applications in java.
    which database is best and globally used.. tell me some suggestion friends
    ThanX
    Rj

  2. #2
    masijade is offline Senior Member
    Join Date
    Jun 2008
    Posts
    2,571
    Rep Power
    9

    Default

    Definately not Access. Just take the the one with the highest license cost. Oh wait, that would be Access.

  3. #3
    DarrylBurke's Avatar
    DarrylBurke is offline Member
    Join Date
    Sep 2008
    Location
    Madgaon, Goa, India
    Posts
    11,188
    Rep Power
    19

    Default

    JavaDB, earlier known as Derby, comes included with the JDK.

    db

  4. #4
    rjagan's Avatar
    rjagan is offline Member
    Join Date
    Feb 2011
    Location
    Puducherry
    Posts
    53
    Rep Power
    0

    Default

    what about mssql and mysql?
    ThanX
    Rj

  5. #5
    Tolls is offline Moderator
    Join Date
    Apr 2009
    Posts
    11,792
    Rep Power
    19

    Default

    Any of them work.
    You're question depends on your funding levels, what support you require, what you are planning on actually using the database for, the target platform, the developer knowledge base...and probably more than that. None of which are to do with Java.

    Oh, and to echo masijade...anything but Access.

  6. #6
    JosAH's Avatar
    JosAH is offline Moderator
    Join Date
    Sep 2008
    Location
    Voorschoten, the Netherlands
    Posts
    13,336
    Blog Entries
    7
    Rep Power
    20

    Default

    Quote Originally Posted by Tolls View Post
    Oh, and to echo masijade...anything but Access.
    Is it that bad? As far as I know I never used it so I have no grounds for a good bashing of Access; enlighten me please on the shortcomings of Access ;-)

    kind regards,

    Jos
    cenosillicaphobia: the fear for an empty beer glass

  7. #7
    JeffGrigg is offline Member
    Join Date
    Aug 2011
    Posts
    95
    Rep Power
    0

    Default

    Here's a good list of options: Comparison of relational database management systems - Wikipedia, the free encyclopedia

    Oracle is popular in the industry. It's expensive but well supported.

    SQL Server is popular on Microsoft Windows.

    MySQL is a very popular open source product.

    Access worked well for small single-user databases. It's cheap and easy to use. But it's known for poor multi-user performance and for corrupting your data when your database gets large.

    Different tools are optimal for different uses. For most casual use, it doesn't really matter which one you use.

  8. #8
    Tolls is offline Moderator
    Join Date
    Apr 2009
    Posts
    11,792
    Rep Power
    19

    Default

    I think the main thing is it's built to be easy to create dbs for non-programmer types. Which is fine. But then you end up with all these little dbs lying around the place (rather reminiscent of Lotus Notes to be honest) that bright sparks think ought to be connected up, which should be easy since after all the db is already there. Only Access doesn't have a decent JDBC driver. And it doesn't have indexes. So the whole thing becomes slow and clunky.

    I can probably come up with more, but I already feel sullied.
    Fubarable likes this.

  9. #9
    JosAH's Avatar
    JosAH is offline Moderator
    Join Date
    Sep 2008
    Location
    Voorschoten, the Netherlands
    Posts
    13,336
    Blog Entries
    7
    Rep Power
    20

    Default

    Quote Originally Posted by Tolls View Post
    I think the main thing is it's built to be easy to create dbs for non-programmer types. Which is fine. But then you end up with all these little dbs lying around the place (rather reminiscent of Lotus Notes to be honest) that bright sparks think ought to be connected up, which should be easy since after all the db is already there. Only Access doesn't have a decent JDBC driver. And it doesn't have indexes. So the whole thing becomes slow and clunky.

    I can probably come up with more, but I already feel sullied.
    Aw, come on, you can do better than that; I'd expected rational remarks such as "Access stinks big times!" and "Anyone who uses Access is a d*ckless loser!" etc. I want to be able to bash Access with a lot of ratio and I need help; try again! ;-)

    kind regards,

    Jos
    cenosillicaphobia: the fear for an empty beer glass

  10. #10
    Tolls is offline Moderator
    Join Date
    Apr 2009
    Posts
    11,792
    Rep Power
    19

    Default

    Jeff mentions a coupleof the salient real points, but just to give you some more ammunition...

    Access sucks wet farts out of dead pidgeons!

  11. #11
    JosAH's Avatar
    JosAH is offline Moderator
    Join Date
    Sep 2008
    Location
    Voorschoten, the Netherlands
    Posts
    13,336
    Blog Entries
    7
    Rep Power
    20

    Default

    Quote Originally Posted by Tolls View Post
    Jeff mentions a coupleof the salient real points, but just to give you some more ammunition...

    Access sucks wet farts out of dead pidgeons!
    Ah! Yes! Very good; I'll jot that one down for my list. Any more? I can't bash Access with just that one (although it is quite good). Anything with a bad smell or genitals mayhap?

    kind regards,

    Jos ;-)
    cenosillicaphobia: the fear for an empty beer glass

  12. #12
    Joel's Avatar
    Joel is offline Member
    Join Date
    May 2011
    Location
    Placerville, CA
    Posts
    86
    Rep Power
    0

    Default

    MySQL all the way, or Derby (that is the one that comes with the latest JDK) although, I must warn you, MySql is a bitch to configure at times, especially if you're one of the lucky Windows 7 owners. A lot easier on XP 32 bit. So, if you have Windows 7 like a true patriot of Microsoftland, then use Derby. It is pretty seamless to install and configure.
    ~MSP430 Lover~

  13. #13
    sibernewf is offline Member
    Join Date
    Mar 2011
    Posts
    48
    Rep Power
    0

    Default

    Great, thanks Joel lol. I have just upgraded my PC and purchased Windows 7.
    With Vista, I found MYSQL a cinch to install/configure.
    Sounds like Im in for fun on my new Win 7 OS!

    I'm hoping its not as difficult as you've mentioned tho.

  14. #14
    Tolls is offline Moderator
    Join Date
    Apr 2009
    Posts
    11,792
    Rep Power
    19

    Default

    Have to say I didn't have any problems with it, but these things are rarely consistent.

  15. #15
    JosAH's Avatar
    JosAH is offline Moderator
    Join Date
    Sep 2008
    Location
    Voorschoten, the Netherlands
    Posts
    13,336
    Blog Entries
    7
    Rep Power
    20

    Default

    Quote Originally Posted by Tolls View Post
    Have to say I didn't have any problems with it, but these things are rarely consistent.
    And Access is a bit fart and its mother was a hamster! So there.

    kind regards,

    Jos ;-)
    cenosillicaphobia: the fear for an empty beer glass

  16. #16
    Joel's Avatar
    Joel is offline Member
    Join Date
    May 2011
    Location
    Placerville, CA
    Posts
    86
    Rep Power
    0

    Default

    Quote Originally Posted by sibernewf View Post
    Great, thanks Joel lol. I have just upgraded my PC and purchased Windows 7.
    With Vista, I found MYSQL a cinch to install/configure.
    Sounds like Im in for fun on my new Win 7 OS!

    I'm hoping its not as difficult as you've mentioned tho.
    Hey, if you've got the time and the wherewithal to google errors...
    ~MSP430 Lover~

  17. #17
    Joel's Avatar
    Joel is offline Member
    Join Date
    May 2011
    Location
    Placerville, CA
    Posts
    86
    Rep Power
    0

    Default

    And Access is the equivalent of the scum that lines the inner-part of the grooves of the soles of your shoes. You know, the stuff that will never come out and makes the shoe age faster like Mel Gibson's character in that one movie where he was an Air Force pilot who chose to undergo a time-machine experiment due to the unforeseen tragedy that claimed the life of his sweetheart and forced him to wake up in the nineties or some decade thereof.....whew.
    ~MSP430 Lover~

Similar Threads

  1. Connecting with database in java
    By UJJAL DHAR in forum New To Java
    Replies: 3
    Last Post: 06-05-2010, 07:34 AM
  2. help with database using java
    By computerbum in forum New To Java
    Replies: 5
    Last Post: 04-26-2010, 01:45 PM
  3. Replies: 2
    Last Post: 02-11-2009, 04:43 AM
  4. java database connectivity
    By thamizhisai in forum Advanced Java
    Replies: 1
    Last Post: 04-28-2008, 05:59 PM
  5. PDA, Database, and Java
    By percivalwcy in forum CLDC and MIDP
    Replies: 0
    Last Post: 08-08-2007, 03:12 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •