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