cayenne-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Marie Goutière <sweetyl...@hotmail.com>
Subject Re: ProcedureQuery problem
Date Tue, 28 Mar 2006 08:40:49 GMT
We 're using the version 1.1.2 of Cayenne with Oracle 9i.
But I want to know what exactly is the problem.
Many Thanks
Marie



>From: Andrus Adamchik <andrus@objectstyle.org>
>Reply-To: cayenne-user@incubator.apache.org
>To: cayenne-user@incubator.apache.org
>Subject: Re: ProcedureQuery problem
>Date: Mon, 27 Mar 2006 21:33:49 +0400
>
>What version of Cayenne and Oracle do you have? It looks like you are  
>hitting this issue:
>
>http://objectstyle.org/jira/browse/CAY-464
>
>It is fixed in 1.2M12 (but note that you have to use the auto- adapter, 
>i.e. do not enter DataNode adapter name for the fix to work)
>
>Andrus
>
>
>On Mar 27, 2006, at 9:11 PM, Marie Goutière wrote:
>
>>
>>Thanks
>>you're it's quite ok but in Tomcat log there a little problem
>>QueryLogger: === updated 1 row. appears without stopping.
>>Is that normal???
>>My proc doesn't update anything :'(
>>I don't understand
>>
>>Thanks
>>Marie
>>
>>>From: Andrus Adamchik <andrus@objectstyle.org>
>>>Reply-To: cayenne-user@incubator.apache.org
>>>To: cayenne-user@incubator.apache.org
>>>Subject: Re: ProcedureQuery problem
>>>Date: Mon, 27 Mar 2006 20:21:53 +0400
>>>
>>>Hi Marie,
>>>
>>>I noticed a mismatch between your procedure definition and  Cayenne  
>>>mapping:
>>>
>>><procedure name="GETEXAVALBR" returningValue="true">
>>>
>>>"returningValue" should only be "true" for Oracle *functions*,  not  
>>>procedures. Try unchecking the corresponding checkbox in the  Modeler.
>>>
>>>Andrus
>>>
>>>
>>>
>>>
>>>On Mar 27, 2006, at 8:16 PM, Marie Goutière wrote:
>>>
>>>>Hello
>>>>I've a problem pl/sql with a ProcedureQuery.
>>>>here's my java code :
>>>>ProcedureQuery query = new ProcedureQuery("GETEXAVALBR");
>>>>query.addParameter("idDevice", deviceId);
>>>>query.addParameter("codeMcoEnt", codeMco);
>>>>query.addParameter("dateQuestionBR", dateReview);
>>>>query.addParameter("codeForecast", forecastNum);
>>>>
>>>>try{
>>>>List result =dgctContext.performQuery(query);
>>>>}
>>>>catch (Exception e){
>>>>// PB dans la requete return null
>>>>DgctLogger.error("DB Request GETEXIST2VALBR Failed");
>>>>DgctLogger.error(e.toString());
>>>>}
>>>>
>>>>My proc stoc returns only one field of an oracle table
>>>>
>>>>in my map.xml you can find :
>>>><procedure name="GETEXAVALBR" returningValue="true">
>>>><procedure-parameter name="valBr" type="VARCHAR" length="10"   
>>>>direction="out"/>
>>>><procedure-parameter name="idDevice" type="VARCHAR" length="10"   
>>>>direction="in"/>
>>>><procedure-parameter name="codeMcoEnt" type="VARCHAR" length="2"   
>>>>direction="in"/>
>>>><procedure-parameter name="dateQuestionBR" type="VARCHAR"   length="10"

>>>>direction="in"/>
>>>><procedure-parameter name="codeForecast" type="VARCHAR"  length="10"  
>>>>direction="in"/>
>>>></procedure>
>>>>
>>>>and the declation of the procedure is :
>>>>
>>>>CREATE OR REPLACE PROCEDURE GETEXAVALBR(
>>>>valBr OUT varchar,
>>>>idDevice IN varchar,
>>>>codeMcoEnt IN varchar,
>>>>dateQuestionBR IN varchar,
>>>>codeForecast IN varchar
>>>>) IS
>>>>
>>>>here is the trace in tomcat :
>>>>QueryLogger: {? = call GETEXAVALBR(?, ?, ?, ?)} [bind: '[OUT]',   
>>>>'NA485', '2', '01/02/2004', '18']
>>>>I don't know if the binding is correct but I always have the  same  
>>>>error although i'tried a lot of things.
>>>>here is the PL/SQL error
>>>>PLS-00306: wrong number or types of arguments in call to  'GETEXAVALBR'
>>>>
>>>>I've no Idea left
>>>>Can anyone rescue me???? :))
>>>>Thanks
>>>>
>>>>
>>>>
>>>
>>
>>
>>
>



Mime
View raw message