About Question enthuware.oce-jpad.v6.2.567 :
Posted: Mon Mar 26, 2012 4:29 am
Hi
I think the query
select s.courses from Student s
is correct, I test the same query on the toyAppForJPA
SELECT co.lineItems FROM CustOrder co
and get the results:
JPA Query Output -
[ArrayList Size=20
[OrderLineItem : salesapp.OrderLineItem[id=1 quantity=2 item = Not Loaded]]
[OrderLineItem : salesapp.OrderLineItem[id=2 quantity=2 item = Not Loaded]]
[OrderLineItem : salesapp.OrderLineItem[id=3 quantity=4 item = Not Loaded]]
[OrderLineItem : salesapp.OrderLineItem[id=4 quantity=3 item = Not Loaded]]
[OrderLineItem : salesapp.OrderLineItem[id=5 quantity=5 item = Not Loaded]]
[OrderLineItem : salesapp.OrderLineItem[id=6 quantity=3 item = Not Loaded]]
[OrderLineItem : salesapp.OrderLineItem[id=7 quantity=4 item = Not Loaded]]
[OrderLineItem : salesapp.OrderLineItem[id=8 quantity=1 item = Not Loaded]]
[OrderLineItem : salesapp.OrderLineItem[id=9 quantity=3 item = Not Loaded]]
[OrderLineItem : salesapp.OrderLineItem[id=10 quantity=5 item = Not Loaded]]
[OrderLineItem : salesapp.OrderLineItem[id=11 quantity=4 item = Not Loaded]]
[OrderLineItem : salesapp.OrderLineItem[id=12 quantity=5 item = Not Loaded]]
[OrderLineItem : salesapp.OrderLineItem[id=13 quantity=1 item = Not Loaded]]
[OrderLineItem : salesapp.OrderLineItem[id=14 quantity=1 item = Not Loaded]]
[OrderLineItem : salesapp.OrderLineItem[id=15 quantity=4 item = Not Loaded]]
[OrderLineItem : salesapp.OrderLineItem[id=16 quantity=1 item = Not Loaded]]
[OrderLineItem : salesapp.OrderLineItem[id=17 quantity=2 item = Not Loaded]]
[OrderLineItem : salesapp.OrderLineItem[id=18 quantity=5 item = Not Loaded]]
[OrderLineItem : salesapp.OrderLineItem[id=19 quantity=2 item = Not Loaded]]
[OrderLineItem : salesapp.OrderLineItem[id=20 quantity=3 item = Not Loaded]]
]
Can you explain why it is not a valid query?
Thanks,
Peter
I think the query
select s.courses from Student s
is correct, I test the same query on the toyAppForJPA
SELECT co.lineItems FROM CustOrder co
and get the results:
JPA Query Output -
[ArrayList Size=20
[OrderLineItem : salesapp.OrderLineItem[id=1 quantity=2 item = Not Loaded]]
[OrderLineItem : salesapp.OrderLineItem[id=2 quantity=2 item = Not Loaded]]
[OrderLineItem : salesapp.OrderLineItem[id=3 quantity=4 item = Not Loaded]]
[OrderLineItem : salesapp.OrderLineItem[id=4 quantity=3 item = Not Loaded]]
[OrderLineItem : salesapp.OrderLineItem[id=5 quantity=5 item = Not Loaded]]
[OrderLineItem : salesapp.OrderLineItem[id=6 quantity=3 item = Not Loaded]]
[OrderLineItem : salesapp.OrderLineItem[id=7 quantity=4 item = Not Loaded]]
[OrderLineItem : salesapp.OrderLineItem[id=8 quantity=1 item = Not Loaded]]
[OrderLineItem : salesapp.OrderLineItem[id=9 quantity=3 item = Not Loaded]]
[OrderLineItem : salesapp.OrderLineItem[id=10 quantity=5 item = Not Loaded]]
[OrderLineItem : salesapp.OrderLineItem[id=11 quantity=4 item = Not Loaded]]
[OrderLineItem : salesapp.OrderLineItem[id=12 quantity=5 item = Not Loaded]]
[OrderLineItem : salesapp.OrderLineItem[id=13 quantity=1 item = Not Loaded]]
[OrderLineItem : salesapp.OrderLineItem[id=14 quantity=1 item = Not Loaded]]
[OrderLineItem : salesapp.OrderLineItem[id=15 quantity=4 item = Not Loaded]]
[OrderLineItem : salesapp.OrderLineItem[id=16 quantity=1 item = Not Loaded]]
[OrderLineItem : salesapp.OrderLineItem[id=17 quantity=2 item = Not Loaded]]
[OrderLineItem : salesapp.OrderLineItem[id=18 quantity=5 item = Not Loaded]]
[OrderLineItem : salesapp.OrderLineItem[id=19 quantity=2 item = Not Loaded]]
[OrderLineItem : salesapp.OrderLineItem[id=20 quantity=3 item = Not Loaded]]
]
Can you explain why it is not a valid query?
Thanks,
Peter