Hi All
I too would much rather see @NamedQuery(ies) defined in a seperate
class like I do other more complicated queries. I also see this as a
good way of keeping things modular or decoupled from the model.
Using a seperate java class which then registers those queries at run
time would be a good way of doing things. The registration not need be
in the persistence.xml file as long as it can be added to the
persistence unit later.
David
On Fri, 5 Jun 2009 08:33:19 -0700 (PDT)
Pinaki Poddar <ppod...@apache.org> wrote:
>
> Hi Daryl,
> This is one feature, for a long time, I am interested to be included
> in JPA or at least in OpenJPA. Having your queries *only* in the
> major compilation unit is a poor idea for usability point of view and
> takes away much of the power from tuning a query a posteriori.
> However, I had considered the facility slightly differently than
> yours. The primary feature that I considered important in this aspect
> is to dissociate my queries from the major compilation units. The
> compilation units will only refer them by name.
>
> How about the following
> <property name="openjpa.NamedQueryRegistry"
> value="path/to/file/that/contains/NamedQueries.java"/>
>
> and in code
> Query q = em.createQuery("ANameThatAppearsInNamedQueryRegsitry");
>
>
> Daryl Stultz wrote:
> >
> > Hello,
> >
> > I'm frustrated by the fact that I need to define @NamedQuery and
> > others inside my entity classes. I would like to put what I
> > consider "logic" where
> > I think it's appropriate which is often not with the model. Is
> > there a way to programmatically define Named Queries Sql Result Set
> > Mappings, etc and register them with the persistence engine? I.e.
> > is there any alternative to
> > using annotations/xml for defining these things?
> >
> > String query = "select o...";
> > NamedQuery nq = new NamedQuery(query);
> > Persistence.registerNamedQuery(nq);
> >
> > Thanks.
> >
> > --
> > Daryl Stultz
> > _____________________________________
> > 6 Degrees Software and Consulting, Inc.
> > http://www.6degrees.com
> > mailto:da...@6degrees.com
> >
> >
>
>
> -----
> Pinaki Poddar http://ppoddar.blogspot.com/
>
> http://www.linkedin.com/in/pinakipoddar
> OpenJPA PMC Member/Committer
> JPA Expert Group Member
