> 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