> I am looking for JDBC-compliant embedded database worked on Windows
> and most popular UNIX platforms (Solaris, Linux, AIX, HPUX, OSF1)
>
> I tested JayBird on Windows. Looks perfect for me.
>
> What am I need to compile for using JayBird on other platforms?

JayBird is not embedded database, it is just JDBC driver suite. JayBird has
two connection modes: pure java that uses sockets to connect to the remote
server (even running on the same host) and the one that uses jni-bridge. In
latter case you have an option to use Firebird's client library or any other
library with compatible API. On Windows you have option to use fbembed.dll.

On UNIX platform situation is more complex. Strictly speaking there is no
emebdded Firebird for UNIX. There is libfbembed.so on Linux, however it
requires Firebird installation. And there is no official release of Firebird
1.5 for Solaris for Sparc, only for Solaris x86. Also as far as I can see
there is not official release of Firebird for AIX and I would be careful
with HPUX and OSF1 - check first if you get at least JDK 1.3.1 for those
OSes first.

Now about the situation with JayBird on that platforms: JayBird was built
and tested with JNI-bridge on Windows and Linux. It should compile for
Solaris, both x64 and Sparc, though I did not test it. I have no clue
whether it will compile and work on AIX or HPUX.

As I already mentioned, there is no true embedded engine for UNIX platforms.
But in general situation is not bad. Jim Starkey (original creator of
InterBase) now works on Vulcan - a Firebird fork providing true SMP support
for Windows, Linux and Solaris with improved architecture that will work as
server and as an embedded engine. Later Vulcan will be merged with Firebird
code base and will form Firebird 3.0. As soon as Vulcan is released, JayBird
will be updated to support it.

So, if you're looking for a embedded database engine for Windows, Linux and
Solaris out of the box, Vulcan + JayBird is the right solution for you.
Though you have to wait some time until Vulcan is released (if I'm correct
that will happen this year), or you can join the team and start testing
Vulcan and JayBird even now. I think Jim would also welcome your
contribution in building Vulcan and JayBird for AIX, HPUX and OSF1 if that
would not break the architecture.


Roman Rokytskyy

P.S. Alternatively, you can look for pure Java databases, for example
JDataStore from Borland. But before deciding to buy licenses, think, maybe
it would be better to sponsor Firebird ports on the platforms you need? ;-)