| Subject | Executing functions via JDBC | 
|---|---|
| Author | Daniel | 
| Post date | 2003-11-10T23:15:13Z | 
Hi
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
            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