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