时间戳

首页 > 解决方案 > QuerySyntaxException：意外令牌

hibernate - QuerySyntaxException：意外令牌

问题描述

我在 JPA 存储库中定义了这个查询

  @org.springframework.data.jpa.repository.Query("select min(cur.volumeUsd24h), max(cur.volumeUsd24h), "
        + "min(marketCapUsd),       man(marketCapUsd), "
        + "min(availableTickets),   man(availableTickets), "
        + "min(totalTickets),       man(totalTickets)  "
        + "min(maxTickets),             man(maxTickets)  "
        + "from Tickets cur  ")
  Object[] findQueryFiltersValues ();

但是当我启动应用程序时，我收到了这个错误：

Caused by: java.lang.IllegalArgumentException: org.hibernate.hql.internal.ast.QuerySyntaxException: unexpected token: min near line 1, column 211 [select min(cur.volumeUsd24h), max(

我也试过

@Query(value = "select min(cur.volume_usd_24h), max(cur.volume_usd_24h), "
        + "min(market_cap_usd),       max(market_cap_usd), "
        + "min(available_tickets),   max(available_tickets), "
        + "min(total_tickets),       max(total_tickets)  "
        + "min(max_tickets),             max(max_tickets)  "
        + "from tickets cur  ",nativeQuery = true)

但我得到一个编译错误：

Multiple markers at this line
    - Syntax error on token ",", [ expected
    - Syntax error, insert "]" to complete 
     Expression

标签： hibernatespring-bootjpaspring-data-jpaspring-data

解决方案

假设 man 实际上是max，原始查询有语法错误，这就是异常的原因。后面没有逗号max(totalTickets)，这使得查询max(totalTickets) min(maxTickets)。根据发布的代码查看此示例，该代码显示了正确的查询

推荐阅读