Subject Executing functions via JDBC
Author Daniel
Hi All

When I try to run a query which contains functions I get exceptions like the
following:
----------------------------------------------------------------------------
java.sql.SQLException: org.firebirdsql.jdbc.FBSQLException: GDS Exception.
Dynamic SQL Error
SQL error code = -804
Function unknown
upper
----------------------------------------------------------------------------

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

I am using JayBird JCA/JDBC Driver for Firebird version 1.0.1. with Firebird
1.5 RC6
Has anybody an idea what could cause the problem?

Regards
Daniel