How to fetch related object using JDOQL named query?

Asked Feb 14 '17 at 15:54

Active Feb 14 '17 at 15:54

Viewed 37 times

I'm using DataNucleus 2.0.5. And I need to run named JDOQL query to retrieve object with some of related entities.

Suppose I have

class Account{
     Set<Role> roles;
     //... other properties
}

Now I want to execute named query and retrieve account with roles. I need to do something very similar to join fetch in JPQL but using JDOQL named query.

asked Feb 14 '17 at 15:54

Taras Boychuk

2,059
13
21

DataNucleus v2.0.5 has not been supported for many years. Suggest that you use something from this decade! – Neil Stockton Feb 14 '17 at 16:15
@NeilStockton thank you man, I would love to. But unfortunately I need to support some code that uses this version of DN. – Taras Boychuk Feb 14 '17 at 16:29
tried putting the field in the FetchPlan? – Neil Stockton Feb 14 '17 at 16:53
@NeilStockton as I understand fetch plan is not applied when you use named query. – Taras Boychuk Feb 14 '17 at 17:23
Of course it is. You execute the query yourself, so have ample time to specify a FetchPlan before execution. – Neil Stockton Feb 14 '17 at 17:57
@NeilStockton Ok, thanks. I'll try. So, there is no possibility to fetch it inside JDOQL query? – Taras Boychuk Feb 15 '17 at 11:13

How to fetch related object using JDOQL named query?

0 Answers0