aspose file tools*
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 Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Bundled database suggestions" Watch "Bundled database suggestions" New topic
Author

Bundled database suggestions

David Garratt
Ranch Hand

Joined: Aug 08, 2003
Posts: 198

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.

Thanks

Dave


Th
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Bundled database suggestions