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. with Firebird 1.5 RC6
Executing the same query with Database Workbench works fine. Has anybody an
idea what could cause the problem?

Regards

Daniel Putra