RE: Getting relation with itself(same Object)

From: Gentry, Michael \(Contractor\) ("Gentry,)
Date: Mon Jun 20 2005 - 14:17:24 EDT

  • Next message: Dhruti Ramani: "RE: Getting relation with itself(same Object)"

    Hmmm ...
     
    If you click on the "Tables" tab in the modeler, is your "Deal" table
    selected (checked)? If not, click the checkbox and go back to the SQL
    Options tab. It should be in there now (assuming "Create Primary Key
    Support" is checked).
     
    If that isn't it, you can always bootstrap it by hand using SQL:
     
    INSERT INTO AUTO_PK_SUPPORT (TABLE_NAME, NEXT_ID) VALUES ('Deal', 200)
     
    (Note that the 200 is the first primary key to produce)
     
    You didn't mention, but I hope you are using Cayenne 1.1 currently. 1.2
    is still in development and I know there are modeler changes, but I
    haven't looked into the differences yet.
     
    /dev/mrg
     

            -----Original Message-----
            From: Dhruti Ramani [mailto:dhrutiraman..ahoo.com]
            Sent: Monday, June 20, 2005 2:05 PM
            To: cayenne-use..bjectstyle.org
            Subject: RE: Getting relation with itself(same Object)
            
            
            hey thanks, you won't believe it but after I posted this
    question I did exactly what you sent here.
             
            But now I have another problem. My "Deal" object should have 1
    to 1 relation with this "TypeToken" and if I do that in cayenne modeler
    and generate the database schema it does not create entry for "Deal"
    class in auto_pk_support.
             
            I also tried generating only "primary key support" for Deal but
    did not work.
             
            Any help?
            Thanks in advance,
            Denne
            
            "Michael Gentry (Yes, I'm a Contractor)"
    <michael_gentr..anniemae.com> wrote:

                    This seems to come up a lot. Might should add a wiki
    page for it, but until
                    then, try something like these screen shots.
                    
                    /dev/mrg
                    
                    
                    

            
    ________________________________

            Yahoo! Sports
            Rekindle the Rivalries. Sign up for Fantasy Football
    <http://pa.yahoo.com/*http://us.rd.yahoo.com/evt=33539/*http://football.
    fantasysports.yahoo.com?ovchn=YAH&ovcpn=Integration&ovcrn=Mail+footer&ov
    rfd=YAH&ovtac=AD>



    This archive was generated by hypermail 2.0.0 : Mon Jun 20 2005 - 14:17:28 EDT