QuerySyntaxException: Unexpected token *

Question

I am getting the following error when I try to run a query using EntityManager:

Exception in thread "main" java.lang.reflect.InvocationTargetException
Caused by: java.lang.IllegalArgumentException: org.hibernate.hql.internal.ast.QuerySyntaxException: unexpected token: * near line 1, column 8

What could be causing this?

Code:

public static void main(String [] args) {

        EntityManagerFactory entityManagerFactory = Persistence.createEntityManagerFactory("myClass");

        EntityManager em = entityManagerFactory.createEntityManager();

        List<String> results= em.createQuery(
                "SELECT * FROM myClass ")
                .setMaxResults(10)
                .getResultList();

}

JPQL != SQL. Suggest you read basic JPA documentation before just dumping a query in — Neil Stockton, Feb 18 '16 at 11:00

score 8 · Accepted Answer · answered Feb 18 '16 at 10:33

8

You cannot use * operator in HQL. You can try like below:

List<String> results= em.createQuery(
                "SELECT myclass FROM myClass ")
                .setMaxResults(10)
                .getResultList();

Hope this helps!

answered Feb 18 '16 at 10:33

Ravi Ranjan

740
2
10
31

QuerySyntaxException: Unexpected token *

1 Answers1