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