> The only weakness I have found in Jaybird versus other Java drivers is

it lacks the support for batching

This is a problem in the Firebird API, there is no way to send it a
batch of parameters. I have filed a feature request. If voting is
allowed in the sourceforge system, please vote for it.

-----Original Message-----
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of David Johnson
Sent: Sunday, April 24, 2005 9:30 AM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Best approach using Firebird as
Javaembedded database


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
>
>
>
>
>
>
>




Yahoo! Groups Links