wood burning stoves 2.0*
The moose likes Object Relational Mapping and the fly likes Hibernate with MySql or MS Acess in Standalone Application ? 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 "Hibernate with MySql or MS Acess in Standalone Application ?" Watch "Hibernate with MySql or MS Acess in Standalone Application ?" New topic
Author

Hibernate with MySql or MS Acess in Standalone Application ?

Piyush Patel
Ranch Hand

Joined: Feb 24, 2009
Posts: 127

hi, i am not able to decide which database to use with Hibernate , MS Access or MySql ? for Standalone JAVA Swing base Desktop Application.
i have one thing to do with this application is that,
user should be able to run application from pen-drive .
how it can be done with hibernate +MySql.
i apology if i have asked Qn in wrong forum.

Waiting for your valuable replies.

Cameron Wallace McKenzie
author and cow tipper
Saloon Keeper

Joined: Aug 26, 2006
Posts: 4968
    
    1

I actually have MySQL on a pen drive, and often move from laptop to laptop and just plug it in and access it. It's just my development stuff, but it works.
Piyush Patel
Ranch Hand

Joined: Feb 24, 2009
Posts: 127

Thanks for reply,
i have one Qn
hibernate with MS Access is good choice or should i go with MySQL ? i require to keep Database in pen-drive ....
Paul Sturrock
Bartender

Joined: Apr 14, 2004
Posts: 10336

Piyush Patel wrote:Thanks for reply,
i have one Qn
hibernate with MS Access is good choice or should i go with MySQL ? i require to keep Database in pen-drive ....


Nothing with Access is a good choice. This is not anti-MS sentiment, there are no freely available type 4 JDBC drivers for Access. Hiberntae does not officially support Access either.

If you are looking for an in-memory database you might find Hypersonic or Derby a better fit.


JavaRanch FAQ HowToAskQuestionsOnJavaRanch
Piyush Patel
Ranch Hand

Joined: Feb 24, 2009
Posts: 127

If you are looking for an in-memory database


what about MySQL ? does it work from pen-drive ?
Cameron Wallace McKenzie
author and cow tipper
Saloon Keeper

Joined: Aug 26, 2006
Posts: 4968
    
    1

In memory, and 'from pen drive' are two different concepts.

The databases Paul suggested are excellent.

As I mentioned, MySQL will definitely run from a pen drive.

-Cameron McKenzie
Piyush Patel
Ranch Hand

Joined: Feb 24, 2009
Posts: 127

Thanks Cameron and Paul for replies.
i will try out MySQL in pendrive.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Hibernate with MySql or MS Acess in Standalone Application ?
 
Similar Threads
Hibernate and MS Access?
Shared mysql database
How to get the DB dump from MS ACCESS using java code?
Regarding Hibernate?
ID GENERATOR FOR DATABASES???