Subject Executing functions via JDBC
Author cssoft8
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 e.g.:
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