NamedQuery

[Treimin Clark]

Source: Maikalai Zaikin's notes.

Given:

@Entity
@NamedQuery(
name="magsOverPrice"
query="SELECT x FROM Magazine x WHERE x.price > ?1"
}
public class Magazine{
.......
}

When invoking this query from another bean,.... Given,

EntityManager em=.....
Query q=em.createNamedQuery("magsOverPrice");
.....

Is it legal to call to that named query as "magsOverPrice"?
Shouldn't it be "Magazine.magsOverPrice" ?

[Raf Szczypiorski]

Named queries are persistence-unit scoped, so the names are global and must be unique per unit. Thus, you don't prefix it with anything as it doesn't add any meaning.

[Treimin Clark]

I understood! Thank you Raf

[Niranjan Deshpande]

Raf,

What would be the result if a entity tries to access a query, out of the entity's persistence-unit?

[Raf Szczypiorski]

EntityManager.createNamedQuery() throws IllegalArgumentException in this case. See the API.

Raf

[Niranjan Deshpande]

Thanks! got it!

[jkjllkj jkjllkj]

[ARG: Removed BA post ]