org.hibernate.hql.internal.ast.QuerySyntaxException：意外令牌：> =靠近第1行

i got an exception, when i run this query with Hibernate:

我有一个例外,当我用Hibernate运行这个查询时:

String query = "FROM A st, B g "
                + "WHERE st.name = g.name AND st.name LIKE :name AND "
                + "g.id = ANY (SELECT c FROM C "
                + "WHERE CASE WHEN name = 'test' THEN condiction >= :value end)";

        try {
            return (List) entityManager.createQuery(query)
                    .setParameter("name", "%" + name + "%")
                    .setParameter("value", value).getResultList();
        } catch (SecurityException | IllegalStateException | RollbackException e) {
            LOGGER.info(e.getMessage());
        }
        return null;

i got an execption:

我有一个execption:

java.lang.IllegalArgumentException: org.hibernate.hql.internal.ast.QuerySyntaxException: unexpected token: >= near line 1, column 336 ...
    at org.hibernate.jpa.spi.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1750)
    at org.hibernate.jpa.spi.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1677)
    at org.hibernate.jpa.spi.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1683)
    at org.hibernate.jpa.spi.AbstractEntityManagerImpl.createQuery(AbstractEntityManagerImpl.java:331)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)

Any ideas about it? i use mysql a database. Can i use CASE WHEN THEN in hibernate? The same query work fine on the command line.

关于它的任何想法?我使用mysql数据库。我可以在休眠时使用CASE吗?相同的查询在命令行上正常工作。

Thank Cheers

1 个解决方案

#1

You have the syntax of the CASE expression incorrect. It should be like this (I think):

您的CASE表达式语法不正确。它应该是这样的(我认为):

  WHERE CASE :name
    WHEN 'test' THEN condiction >= :value
    ELSE false
  END

... except that condiction doesn't make any sense here.

......除了condiction在这里没有任何意义。

At any rate, the syntax for a CASE expression is given here in the Java EE 6 tutorial:

无论如何,CASE表达式的语法在Java EE 6教程中给出:

Full Query Language Syntax

完整查询语言语法

1 个解决方案

#1

更多相关文章

随机推荐