cayenne-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From fishmac <john_capsl...@web.de>
Subject trouble w/ tutorial and foreign keys
Date Sat, 28 Jul 2007 20:46:59 GMT

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.


Mime
View raw message