After 5 days I have finally been able to setup Firebird Embedded in SQuirreL SQL.
And I call myself a programmer... Shame on me!
Since I haven't found any concise tutorial on how this can be achieved (for newbies in Firebird, at least), I'll write here on how to do it.
You will need three things:
Unpack both zips into the same folder. You will only need the following:
Jaybird archive:
- jaybird-full-*.jar
- jaybird21.dll
Firebird embedded archive:
- fbembed.dll
- ib_util.dll
- icudt30.dll
- icuin30.dll
- icuuc30.dll
- firebird.conf (if you wish to provide custom configuration)
- firebird.msg
- intl\* (folder)
After the libraries and SQuirreL SQL are installed, you have to setup a connection and some paths for the libraries.
Before opening SQuirreL, go to the directory where it is installed. In there you will find the main runnable batch file: squirrel-sql.bat. Edit the file and insert the red colored text in the last line:
start "SQuirreL SQL Client" /B "%LOCAL_JAVA%w" -Djava.library.path=/path/to/jaybird_dll -Xmx256m -cp %TMP_CP% net.sourceforge.squirrel_sql.client.Main %TMP_PARMS%
Replace with the path where the file jaybird21.dll is installed. It will typically be in the same folder as jaybird-full-*.jar.
Open SQuirreL and choose "Firebird JayBird" from drivers. On "Extra Class Path", point to the jaybird-full.jar that was unpacked from the archive you downloaded.
Since it is the embedded version, make sure your database string is:
jdbc:firebirdsql:embedded:<database_path>