RE: Where are Stored Procedures in Modeler

From: Williams, Beth (beth.william..FIB.ORG)
Date: Thu Nov 04 2004 - 10:13:47 EST

  • Next message: Andrus Adamchik: "RE: Where are Stored Procedures in Modeler"

    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