Bryan,
this is a bug, I can confirm that:
https://issues.apache.org/cayenne/browse/CAY-750
I fixed it on trunk (Cayenne 3.0). Will apply it to 2.0 and 1.2
branches shortly.
Andrus
On Feb 6, 2007, at 1:35 PM, Bryan Lewis wrote:
I had this code working on an Oracle8 database:
ProcedureQuery procQuery = new
ProcedureQuery("proc_eu_update_begin");
dc.performQuery(procQuery);
The procedure is only a few sql statements to create a temporary table
and takes no parameters. When I ported to Postgres 8.2, Cayenne
says it
can't find the procedure. The log shows:
{call proc_eu_update_begin}
org.postgresql.util.PSQLException: ERROR: relation
"proc_eu_update_begin" does not exist
I could execute the procedure manually with "select
proc_eu_update_begin()". Note that the empty parentheses were
required.
I had other working procedures so I suspected it was the absence of
parameters causing the problem. Adding a dummy parameter made
things work:
{call proc_eu_update_begin(?)} [bind: 'xx']
So I have a work-around, but... maybe Cayenne could generate a call
that
Postgres would handle better, something like the empty parentheses in
the manual command.
P.S. The definition of the procedure (now a function in Postgres)
looks
like:
CREATE OR REPLACE function proc_eu_update_begin()
RETURNS void AS ...