> It can theoretically support DISJOINT_BY_ID, but IIRC it does not.
Actually I was wrong about this one. DISJOINT_BY_ID works just fine with
SQLSelect, and will save you a lot of trouble mapping SQL:
List result = SQLSelect.query(Artist.class, "SELECT "
+ "#result('ARTIST_NAME' 'String'
Hi,
We may need to make it more obvious in the API, but SQLSelect only supports
JOINT prefetching [1]. It can't support disjoint, as Cayenne has no way of
building the right WHERE clause for prefetch queries. It can theoretically
support DISJOINT_BY_ID, but IIRC it does not.
So let's focus on
Hello,
I have to do some complex queries to data base and to do that on I'm
writing them in SQL.
It works great with SQLSelect but when I need to prefetch something ( to
avoid hundreds of queries when showing data in a tableView) it does not
work,
from javaDoc it seems that prefetching wit
Hello,
I have to do some complex queries to data base and to do that on I'm
writing them in SQL.
It works great with SQLSelect but when I need to prefetch something ( to
avoid hundreds of queries when showing data in a tableView) it does not
work,
from javaDoc it seems that prefetching wit
