I've been trying FirebirdDialect with 3.0, and have gotten enough
help here to realize that Hibernate is trying to call the
UDF "lower" and that I need to configure the Firebird service and my
database to support UDFs.

I didn't know I had to restart the Firebird service after changing
firebird.conf, but now that I have, the UDFs are accessible and I'm
able to at least do an 'ant eg' in Hibernate and get the example
program to run.

Now I'm on to trying 'ant junitreport' and there are failures I need
to look into there. I may try your suggestion and set the dialect
to "NONE".

And yes, I basically spammed the Hibernate, Firebird and Jaybird
lists, hoping one of them would know where I went wrong.

Thanks,
-Jeff

--- In firebird-support@yahoogroups.com, David Johnson
<d_johnson@c...> wrote:

> Hibernate has a configuration that specifies the dialect of SQL to

use.

> Their documentation (version 2.x) states that with

Interbase/Firebird,

> use "NONE", even though there is an interbase setting. This

worked well

> for me with version 2.x
>
> This may also be a bug in version 3.x, since 3.0 was only moved to

RC1

> status yesterday evening. Have you checked the Hibernate lists?
>
> On Mon, 2005-02-28 at 11:54, jeffrobertsky@y... wrote:
> >
> >
> >
> > > Firebird implements a very small set of functions natively.

Most

> > common
> > > functions are available through libraries of User Defined
> > Functions
> > > which are distributed with Firebird but must be added to each
> > database,
> > > using a script of SQL commands. One of those functions is

LOWER

> > which
> > > hibernate references. Looking at your log, I'm not sure that

the

> > > absence of LOWER is the primary cause of your problems, but

it's

> > > certainly going to keep your build from working.
> > >
> > > So, add useStandardUdf to your properties. Add ib_udf.sql to

the

> > steps
> > > run after the database is created and before the tables for
> > hibernate
> > > are created. And try the firebird-java list
> > > (Firebird-Java@yahoogroups.com)... They speak your language.
> > >
> > > Regards,
> > > Ann
> >
> > Thanks - I found enough articles on UDF's to try executing
> > ib_udf.sql from within isql.exe and now I can "show function"

and

> > see the definitions.
> >
> > I've tried adding "useStandardUdf = 1" as well as "UdfAccess =
> > Restrict UDF" (and "UdfAccess = Full") in firebird.conf but

when

> > LOWER is specified in SQL by Hibernate I keep getting:
> >
> > Access to UDF library "ib_udf.DLL" is denied by server

administrator

> >
> > -Jeff
> >
> >
> >
> >
> >
> >
> > Yahoo! Groups Links
> >
> >
> >
> >
> >
> >
> >