Win a copy of Functional Reactive Programming this week in the Other Languages forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Hibernate with MySql or MS Acess in Standalone Application ?

 
Piyush Patel
Ranch Hand
Posts: 127
Android Firefox Browser Ubuntu
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 4968
1
Hibernate Spring Tomcat Server
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 127
Android Firefox Browser Ubuntu
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 10336
Eclipse IDE Hibernate Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
Piyush Patel
Ranch Hand
Posts: 127
Android Firefox Browser Ubuntu
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 4968
1
Hibernate Spring Tomcat Server
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 127
Android Firefox Browser Ubuntu
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thanks Cameron and Paul for replies.
i will try out MySQL in pendrive.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic