Syntax error in JPA query

Question

When I execute the following code

return entityManager
            .createQuery("select a from Article where a.slug = ?1", Article.class)
            .setParameter(1, slug)
            .getSingleResult();

I get the following exception

java.lang.IllegalArgumentException: An exception occurred while creating a query in EntityManager: 
Exception Description: Syntax error parsing the query [select a from Article where a.slug = '?1'], line 1, column 22: syntax error at [where].
Internal Exception: MismatchedTokenException(77!=78)
    at org.eclipse.persistence.internal.jpa.EntityManagerImpl.createQuery(EntityManagerImpl.java:1328)

I'm using JPA 2 with EclipseLink 2.0.2.

What is wrong with my query?

Clement P · Accepted Answer · 2011-02-01 11:54:15Z

8

... From Article a ... (missing alias)

answered Feb 1, 2011 at 11:54

Clement P

3,2831 gold badge21 silver badges20 bronze badges

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

Comments

Gursel Koca · Accepted Answer · 2011-02-01 12:09:22Z

1

Well, the answer has alredy given.. But what I dont like about JPQL, you have to put an identifier after Entity name, but it is uncessary if your from clause does have only one Entity. Most of time, I also forget to put that unnecessarily required identifier. I wish I would write the above query as below;

select * from Article where slug = ?1

answered Feb 1, 2011 at 12:09

Gursel Koca

21.4k2 gold badges26 silver badges34 bronze badges

Collectives™ on Stack Overflow

Syntax error in JPA query

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related