Hmm, one of the parameters has type="OTHER". Not sure why this should
matter though, but this is the only thing I can think of. So please open a
bug report.
Andrus
> I think I'm getting to the bottom of the problem. It appears to be a
> problem with one specific procedures (xml mapping below). Basically I
> took out all of the stored procedures mapping and then one by one put
> them back until I found the culprit. Now that I've removed the stored
> procedure below, I am also able to see all of the other procedures in
> the Modeler. Do you see any obvious problems with the xml below? If
> not, I can still open a bug report. Thanks.
>
> <procedure name="DB_SIX_MONTH_MEMBER" schema="MEMBERSHIP"
> returningValue="true">
> <procedure-parameter name="_return_value" type="OTHER"
> direction="out"/> <procedure-parameter name="I_MEM_SOURCE"
> type="VARCHAR" direction="in"/> <procedure-parameter name="I_MEM_DUES"
> type="DECIMAL" length="22" precision="2" direction="in"/>
> </procedure>
>
> -----Original Message-----
> From: Andrus Adamchik [mailto:andru..bjectstyle.org]
> Sent: Thursday, November 04, 2004 9:06 AM
> To: cayenne-use..bjectstyle.org
> Subject: RE: Where are Stored Procedures in Modeler
>
>
> Beth,
>
> both issues maybe related to each other. What I am suspecting is that
> some special character in the procedure or parameter name may be causing
> these problems (though I may be wrong of course). You can do more
> investigation on your own - track what's being logged in
> ".cayenne/modeler.log" file in your home directory when you open a
> project with procedures in the Modeler.
>
> If this doesn't give you any clues, I will need your full *.map.xml file
> to try to reproduce the problem. Preferred way would be to open a bug
> report (http://objectstyle.org/cayenne/bugs-features.html) and attach
> the file to it. But if your mapping contains sensitive/confidential
> information, you can email it to me directly instead.
>
> Andrus
>
>
>> Andrus,
>>
>> This issue is somewhat related to Brian's issue before. There are
>> actually a couple issues that we are having with stored procedures.
>> The one Brian mentions of the run time errors we are getting when
>> there are stored procedures to load. In the *.map.xml file we do see
>> the
>> <procedure>....</procedure> sections for each procedure. From what I
>> can tell they look okay. We have quite a number of procedures.
>> Here's just a snippet of what we have.
>>
>> <procedure name="AADBMS_LAST_ROWID" schema="MEMBERSHIP"
>> returningValue="true">
>> <procedure-parameter name="_return_value" type="VARCHAR"
>> direction="out"/>
>> </procedure>
>> <procedure name="ACTIVE_MEM_FOR_SENDING_EMAIL" schema="MEMBERSHIP"
>> catalog="EMAIL_PREF_PKG" returningValue="true">
>> <procedure-parameter name="_return_value" type="DECIMAL" length="22"
>> direction="out"/> <procedure-parameter name="I_PERSON_ID"
>> type="DECIMAL" length="22" direction="in"/>
>> </procedure>
>> <procedure name="ACTIVE_MEM_FOR_VIEWING_PREFS" schema="MEMBERSHIP"
>> catalog="EMAIL_PREF_PKG" returningValue="true">
>> <procedure-parameter name="_return_value" type="DECIMAL" length="22"
>> direction="out"/> <procedure-parameter name="I_PERSON_ID"
>> type="DECIMAL" length="22" direction="in"/>
>> </procedure>
>> <procedure name="CALCULATE_REN_RATES" schema="MEMBERSHIP"
>> catalog="RRENGINE">
>> <procedure-parameter name="I_WE_DT" type="TIMESTAMP"
>> direction="in"/>
>> </procedure>
>> <procedure name="COMPLETED" schema="MEMBERSHIP" catalog="PGMEVTS"
>> returningValue="true">
>> <procedure-parameter name="_return_value" type="VARCHAR"
>> direction="out"/>
>> </procedure>
>>
>>
>> The other issue which is the one I was asking about is regarding the
>> view of the procedures in the Modeler. If we create a procedure
>> through the Modeler directly, then we can see it listed under the
>> DbEntities with the icon you mentioned. However, the procedures that
>> are created through the ReEngineering function of the modeler do not
>> show up under the DbEntities. The only way we can see what procedures
>> are loaded is through the *map.xml file.
>>
>> Beth
>>
>> -----Original Message-----
>> From: Andrus Adamchik [mailto:andru..bjectstyle.org]
>> Sent: Wednesday, November 03, 2004 5:55 PM
>> To: cayenne-use..bjectstyle.org
>> Subject: Re: Where are Stored Procedures in Modeler
>>
>>
>> Beth,
>>
>> Is this something related to the stored procedure problems mentioned
>> by Brian?
>>
>> http://objectstyle.org/cayenne/lists/cayenne-user/2004/10/0147.html
>>
>> Stored procedures in the Modeler are displayed under DbEntities using
>> this icon -
>> http://objectstyle.org/cayenne/images/modeler/icon-stored-procedure.gif
>>
>> Another thing to check is the XML stored in *.map.xml after you save a
>> map with stored procedures. It should contain them as
>> <procedure>...</procedure> sections. If they are there, but there is a
>> problem with loading them back, please open a bug report and attach
>> your *.map.xml file, so that the problem can be reproduced.
>>
>> Andrus
>>
>>
>> On Nov 3, 2004, at 4:45 PM, Williams, Beth wrote:
>>> This seems like a very simple question and I'm probably just
>>> overlooking it, but how can the Stored Procedures be seen in the
>>> Modeler? I have gone through the process to reengineer a db table
>>> and
>>> specify Load Procedures. When I do a Validate Project, I get some
>>> errors that pop up saying ProcedureParameter has no direction. When
>>> I
>>> click on each error, the procedure is displayed with two tabs
>>> (Procedure and Parameters). But once I fix all the errors I have not
>>> found a way to get back to the Prodcedures in the Modeler. I can see
>>> where I can create a new procedure, but what I need to do is to view
>>> the ones that are already there. Any help is greatly appreciated.
>>> Thanks.
>>>
>>> Beth
This archive was generated by hypermail 2.0.0 : Thu Nov 04 2004 - 10:18:26 EST
