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.
