Re: trouble w/ tutorial and foreign keys

From: Andrus Adamchik (andru..bjectstyle.org)
Date: Sun Jul 29 2007 - 11:24:51 EDT

  • Next message: Andrus Adamchik: "DataViews heads up"

    Hi there,

    So what output did you get in the previous step - persisting the data
    objects?

    http://cayenne.apache.org/doc/tutorial-dataobjects.html

    Andrus

    On Jul 28, 2007, at 11:46 PM, fishmac wrote:

    >
    > Cayenne 2.0.3 w/ derby-db
    >
    > The query at the bottom of this
    > http://cayenne.apache.org/doc/tutorial-selectquery.html page does not
    > return 2 rows - it does return 0 rows.
    >
    > INFO QueryLogger: SELECT t0.NAME, t0.ARTIST_ID, t0.GALLERY_ID,
    > t0.ID FROM
    > PAINTING t0, ARTIST t1 WHERE t0.ARTIST_ID = t1.ID AND
    > (t1.DATE_OF_BIRTH < ?)
    > [bind: '1907-01-01 00:00:00.881']
    > INFO QueryLogger: === returned 0 rows. - took 2 ms.
    > INFO QueryLogger: +++ transaction committed.
    >
    > To narrow the problem I tried mysql instead of derby-db. The problem
    > persists and for some strange reason there is no data in
    > PAINTINGS.ARTIST_ID
    > and PAINTINGS.GALLERY_ID for the two paintings.
    >
    > ????
    >
    > --
    > View this message in context: http://www.nabble.com/trouble-w--
    > tutorial-and-foreign-keys-tf4163514.html#a11846371
    > Sent from the Cayenne - User mailing list archive at Nabble.com.
    >
    >

    This archive was generated by hypermail 2.0.0 : Sun Jul 29 2007 - 11:25:25 EDT