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:13:50 EST
