• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
  • Campbell Ritchie
  • Paul Clapham
  • Ron McLeod
  • Liutauras Vilda
  • Bear Bibeault
  • Jeanne Boyarsky
  • Tim Cooke
  • Devaka Cooray
Saloon Keepers:
  • Tim Moores
  • Tim Holloway
  • Piet Souris
  • salvin francis
  • Stephan van Hulst
  • Frits Walraven
  • Carey Brown
  • Jj Roberts

Bundled database suggestions

Ranch Hand
Posts: 272
Mac Eclipse IDE Safari
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
First impressions count as they say. My application - however fool proof I make the install still requires the user to install and configure a database environment. Currently I support mySQL, MS SQL and Oracle. In theory mySQL is the easiest to setup - but the current versions of the SQL Workbench are buggy and problematic.

What I would like to do is to be able to bundle some kind of sql database in the form of jar files which would allow my application to create a database itself for local use - but also support remote connections for network usage if required. I was wondering if Java DB / Derby might fulfil this requirement.

The sort of thing I would like to offer during setup would be :-

Create a Java DB database.
Connect to a remote Java DB database
Connect to a remote my SQl database.
Connect to a remote..... etc

If anyone who has experience with Java DB (or similar alternatives) could comment I would be grateful.

I would need to know if I could accomplish this setup without any user interaction or technical knowledge. Does it require a special JVM version.

My application runs with Windows, Linux and OSX so any DB solution would ideally work on all 3.

I don't envisage the DB solution to be a "heavyweight" solution - but mainly a simple way of letting the user try the application out with minimal effort. They can always migrate to one of the more established db vendors once they are happy the application does what they want.



It's exactly the same and completely different as this tiny ad:
the value of filler advertising in 2020
    Bookmark Topic Watch Topic
  • New Topic