[ https://issues.apache.org/jira/browse/CAY-1975?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14245254#comment-14245254 ]
jotpe commented on CAY-1975: ---------------------------- Ari wrote Wed, 03 Dec 2014 22:23:59 GMT at http://mail-archives.apache.org/mod_mbox/cayenne-user/201412.mbox/%3C547F8D7F.9040504%40maniatis.org%3E {quote} Did you see the documentation here: https://cayenne.apache.org/docs/3.0/advanced-sqltemplate.html At any rate, I suggest that you don't use SQLTemplate unless you really need to. Instead, use a regular SelectQuery where you don't need to craft complex SQL. This will keep your code independent of database specifics. Ari {quote} > Unexpected null value when prefetching with Cayenne.objectForQuery > ------------------------------------------------------------------ > > Key: CAY-1975 > URL: https://issues.apache.org/jira/browse/CAY-1975 > Project: Cayenne > Issue Type: Bug > Components: Core Library > Affects Versions: 3.1 > Reporter: jotpe > Labels: Prefetching, objectforquery > > Querying a select query with addPrefetch over Cayenne.objectForQuery results > in receiving null values for these prefetches. Without addPrefetch, the > relations are loaded correctly. -- This message was sent by Atlassian JIRA (v6.3.4#6332)