Hi

Every time when I try to run a query which contains functions I get
exceptions like the following:

The query e.g.:
select * from "Party" where upper("Name" || ' ' || coalesce("FirstName",''))
like 'SANTIAGO%'

----------------------------------------------------------------------------
--------------------------
java.sql.SQLException: org.firebirdsql.jdbc.FBSQLException: GDS Exception.
Dynamic SQL Error
SQL error code = -804
Function unknown
upper
----------------------------------------------------------------------------
--------------------------

I am using JayBird JCA/JDBC Driver for Firebird version 1.0.1.
Executing the same query with Database Workbench works fine. Has anybody an
idea what could cause the problem?

Regards

Daniel Putra