This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan on-line!
See this thread for details.
The moose likes JDBC and the fly likes Bundled database suggestions Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Bundled database suggestions" Watch "Bundled database suggestions" New topic

Bundled database suggestions

David Garratt
Ranch Hand

Joined: Aug 08, 2003
Posts: 196

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.



I agree. Here's the link:
subject: Bundled database suggestions
Similar Threads
create mysql db for web application
Converting an application to Java (new to Java)
connecting to Remote Database
please help me in my database problems
Connecting to DB2 with no database name