Only one named query allowed???

[Greg Reinl]

I am using annotion to create named queries for an EJB. When I add one annotation it works fine but when I addthe second I get this compile error:

Error(10,2): duplicate annotation javax.persistence.NamedQuery

The annotations at the class level look like this:

@Entity
@NamedQuery(name = "Response.findAll", query = "select o from Response o")
@NamedQuery(name = "Response.searchForText",
query = "select o from Response o where o.question Like :text")

Is ther no way to associate multiple named queries with one EJB?

[Jeanne Boyarsky]

Moving to our JPA forum.

[Shailesh Kini]

Hi Greg,

There is a way to add multiple Named Queries to your entity.

@NamedQueries( { @NamedQuery(name = "Response.findAll query = "select o from Response o"), @NamedQuery(name = "Response.searchForText" query = "SELECT o from Response o where o.question like :text")})

Hope this helps

[Greg Reinl]

It does. Thanks.