jeffrobertsky@... wrote:

>
>
> Can someone help me over this hurdle? Someone on the firebird-devel
> list suggested that I:
>
> "include standard UDF declaration into your database build script
> (the
> ib_udf.sql script is located in the $FIREBIRD_HOME/UDF directory).
> Additionally you may want to use the "useStandardUdf" property (the
> value is not important) to enable support of the standard UDF
> functions
> in escaped syntax."
>
> I'm afraid I don't understand what to do from that explanation.

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