RE: Where are Stored Procedures in Modeler

From: Andrus Adamchik (andru..bjectstyle.org)
Date: Thu Nov 04 2004 - 10:18:24 EST

  • Next message: Andrus Adamchik: "Re: get ID of the inserted record"

    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