Mailing-List: contact user-help@cayenne.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@cayenne.apache.org
Received-SPF: pass (herse.apache.org: domain of bryan@maine.rr.com designates
 24.24.2.56 as permitted sender)
Message-ID: <45CB6564.7050105@maine.rr.com>
Date: Thu, 08 Feb 2007 13:01:08 -0500
From: Bryan Lewis <bryan@maine.rr.com>
User-Agent: Thunderbird 1.5.0.9 (Windows/20061207)
MIME-Version: 1.0
To: user@cayenne.apache.org
Subject: Re: can't find procedure without a parameter on Postgres
References: <45C867F9.5050608@maine.rr.com>
 <B2AF67D4-1306-4880-9F28-C5B2A1065D8E@objectstyle.org>
In-Reply-To: <B2AF67D4-1306-4880-9F28-C5B2A1065D8E@objectstyle.org>
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

Thanks!


Andrus Adamchik wrote:
> 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 ...
>>
>>
>