trouble w/ tutorial and foreign keys

From: fishmac (john_capsloc..eb.de)
Date: Sat Jul 28 2007 - 16:46:59 EDT

  • Next message: Andrus Adamchik: "Re: trouble w/ tutorial and foreign keys"

    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 : Sat Jul 28 2007 - 16:47:28 EDT