Hi ram,
As far as i know, is not possible to set the select columns as parameters.
If you want to make it dynamic, you can try the Criteria API.
Cheers,Roberto
From: ram <ram_ku...@yahoo.co.in>
To: "users@openjpa.apache.org" <users@openjpa.apache.org>
Sent: Monday, February 15, 2016 1:12 PM
Subject: passing select column list as string
Hello,
i was trying to write a namedquery , but would like to pass the select
columns as arguments .
@NamedQuery(name="emp.findAll", query="SELECT s.id.name,s.id.phone,s.address
FROM emp where s.id.name=:na and s.id.phone=:ph").
I would like to pass "s.id.name,s.id.phone,s.address " it as string instead of
entity.column.
@NamedQuery(name="emp.findAll", query="SELECT ?string FROM emp where
s.id.name=:na and s.id.phone=:ph").
can i do this if so how can i pass this ?string
--Thanks
