I run Firebird 1.5.2 Classic with Java and the Jaybird driver. It is
clean and performs reasonably well. I use Hibernate as an ORM layer for
larger projects, or for smaller utilities I write directly to JDBC.

I've always run Firebird as a daemon or service.

The only weakness I have found in Jaybird versus other Java drivers is
it lacks the support for batching. Since this support is optional,
Jaybird is still JDBC compliant.

With some care, you may store and retrieve UTF-8 with Firebird, so easy
internationalization is possible. This puts Firebird ahead of most
other DBMS'.

The caveat is that under the production branch of Firebird, There are no
collations other than binary supported by any option that allows UTF-8
support. Since Java supports such obscure internationalizations as
Swahili, and complex ones like Vietnamese, this should be easy to work
around.

With that said, the intl branch has full UTF8 support, and is working
towards a correction to the core multi-byte character set support.

On Sun, 2005-04-24 at 11:10 +0000, java4sg wrote:
>
>
> Hi,
>
> I'm exploring Firebird as Java embedded database to J2EE based
> solution. What are the best approaches using Firebird as Java embedded
> database? Do we need to always run the engine as Linux/Unix-daemon /
> Windows-services?
>
> Thanks in advance for the info.
>
> Cheers,
> BAM
>
>
>
>
>
>
>
> Yahoo! Groups Links
>
>
>
>
>
>
>