I tried with the FetchGroup & FetchPlan but it didn't work. I have an Entity
called Employee(name, DOJ, designation) out of which I want to select only
(name, designation) [DOJ shouldn't get populated in the resultList objects]
Attaching my code in Session Bean for your reference.
public Employee getEmployeeDetails(int empId)
{
OpenJPAQuery jpaquery =
OpenJPAPersistence.cast(manager.createQuery("select o from employee o where
id =:a"));
FetchPlan fetchPlan = jpaquery.getFetchPlan();
fetchPlan.clearFetchGroups();
fetchPlan.clearFields();
fetchPlan.removeFetchGroup(org.apache.openjpa.meta.FetchGroup.NAME_DEFAULT);
fetchPlan.addFetchGroup("empDetails");
jpaquery.setParameter(1, empId);
return (Employee)jpaquery.getResultList().get(0);
}
FetchGroup "empDetails" is defined in Entity class Employee.
@FetchGroup(name="empDetails",
attribute...@fetchattribute(name="designation"),
@FetchAttribute(name="name")})
Let me know in case you need anything for this.
I configured FetchGroup from the reference of link given below.
http://openjpa.apache.org/builds/1.0.2/apache-openjpa-1.0.2/docs/manual/ref_guide_fetch.html#ref_guide_fetch_custom
Pinaki Poddar wrote:
>
> Hi,
> FetchPlan is the right solution fof your requirement. FetchPlan should
> work for this case and has been used by many users so far for more complex
> fetch requirements.
> May be there are some slight mistakes in how the fetch plans are
> configured/used?
>
>
> Himadri wrote:
>>
>> Hi ,
>>
>> I have a requirement to get only selective colums from an Entity and all
>> ..ie I want something like
>> Select o.name , o.dec from Employee o
>> instead of
>> Select 0 from Employee o.
>>
>> How can I achive this using openJpa ? I though FetchPlan is the answer ,
>> where in FetchAttributes will have the columns to be fetched , but it
>> doesnt work. OpenJPA gets all the attributes of the columns not the only
>> selected one?
>>
>
>
--
View this message in context:
http://n2.nabble.com/How-to-get-selective-columns-only-tp4197516p4202262.html
Sent from the OpenJPA Users mailing list archive at Nabble.com.
