Hi,
I am working on a server-side app that uses embedded DBs. I would like to give users the option to select which DB they want to use. Currently the app works with H2, Derby, HSQL, and Firebird. Getting it to run using the H2, Derby, and HSQL is simply a matter of putting the jar on the classpath. I am trying to determine the best way of handling this with Firebird. I see three options
[1] Provide instructions to the user for how download FB for their OS and how to point JNA to the correct folder
[2] Work on bundling the native components into the jar, and then the user has to download the system specific jar
[3] Have the system detect the OS, and download all the native components into the current directory, and then set JNA to the current directory.
I think I favor option #3. FB is a small download and the download process would only need to happen once at startup (or not at all if it has already been downloaded).
Would something like #3 work? Can all the native components be put into the "current directly" or will some of them need to be in "system" folders? Or will other environment variables need to be set as well?
Thanks,
-Adam