java.lang.IllegalArgumentException: Named query not found:

Question

I got the following code

@Stateless
public class BondecomandeDAO {

    @PersistenceContext
    private EntityManager em;

    public Bondecommande findBCbyid(int id)
    {
         Query q =em.createNamedQuery("select bc from Bondecommande bc where bc.idbc = :idbc");
         q.setParameter("idbc", id);
         return  (Bondecommande) q.getResultList().get(0);
     }
}

and

@Entity
@Table(name="bondecommande")
public class Bondecommande  implements Serializable {

    private static final long serialVersionUID = 1L;

    @Id
    @GeneratedValue(strategy = GenerationType.AUTO)
    @Column(name="idbc")
    private int idbc;
    @Column(name="devise")
    private String devise;
    @Column(name="modepaiement")
    private String modepaiement;
    @Column(name="modelivraison")
    private String modelivraison;
    @Column(name="delaipaiement")
    private int delaipaiement;

      ////other attributes , getters and setters 
}

When I try to run the function findBCbyid(int id) I get this error

java.lang.IllegalArgumentException: Named query not found: select bc from Bondecommande bc where bc.idbc = :idbc

Although I used this named query in an another project, and it worked, what could be the problem here?

thomas.scheuchzer · Accepted Answer · 2013-12-10 15:25:50Z

17

Use em.createQuery(... instead of em.createNamedQuery()

If you work with named queries (what I would recommend) you have to place the query inside a @NamedQuery annotation on your entity class.

answered Dec 10, 2013 at 15:25

thomas.scheuchzer

3993 silver badges6 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Flying Dumpling · Accepted Answer · 2013-12-10 15:31:55Z

6

In JPA query and named query are not the same things.

Named queries have "names" and you define them by adding @NamedQueries annotation on your entity type class:

@Entity
@Table(name="bondecommande")
@NamedQueries({
    @NamedQuery(name="Bondecommande.findByIdbc", query="select bc from Bondecommande bc where bc.idbc = :idbc"),
    @NamedQuery(name="...", query="..."),
}) 
public class Bondecommande  implements Serializable {

    ....
}

You use named queries by passing the name of the query to create method:

Query q =em.createNamedQuery("Bondecommande.findByIdbc");

I recommend to use TypedQuery<T> not Query if you are using JPA 2.x

answered Dec 10, 2013 at 15:31

Flying Dumpling

1,3241 gold badge11 silver badges13 bronze badges

Comments

Kevin Sadler · Accepted Answer · 2023-08-30 11:13:24Z

2

I had a similar error when I migrated working code from Java 8 to 17 (and also with 11). I was using EclipseLink (2.5).

The fix was to upgrade EclipseLink to 2.7 and it worked again.

answered Aug 30, 2023 at 11:13

Kevin Sadler

2,47628 silver badges34 bronze badges

Comments

Lucky · Accepted Answer · 2015-08-17 10:30:59Z

1

createNamedQuery() takes a name of a query and not the query itself.

The Query can be defined by an annotation @NamedQuery Take a look at this: http://docs.oracle.com/javaee/6/api/javax/persistence/NamedQuery.html

edited Aug 17, 2015 at 10:30

Lucky

17.4k20 gold badges121 silver badges156 bronze badges

answered Dec 10, 2013 at 15:27

treeno

2,6002 gold badges23 silver badges39 bronze badges

Comments

Lucky · Accepted Answer · 2015-08-17 10:31:23Z

-3

Query q =em.createNamedQuery("select bc from Bondecommande bc where bc.idbc = :idbc");

after em.createQuery here, and good

edited Aug 17, 2015 at 10:31

Lucky

17.4k20 gold badges121 silver badges156 bronze badges

answered Jul 10, 2015 at 19:29

matos

1

Collectives™ on Stack Overflow

java.lang.IllegalArgumentException: Named query not found:

5 Answers 5

Comments

Comments

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

Comments

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related