java - 期待 IDENT，在第 1 行附近发现 '*'

Question

这个问题已经有答案了:

Hibernate HQL issue expecting IDENT found "*" (3 个回答)

已关闭 4 年前。

我想用 INNER JOIN 实现 JPA 查询。我试过这个:

@Override
    public Optional<PaymentTransactions> paymentTransactionByWpfPaymentId(Integer id) {
        String hql = "SELECT t.* FROM " + PaymentTransactions.class.getName() + " t " 
                + " INNER JOIN " + WpfPaymentPaymentTransactions.class.getName() + " wppt "
                + " ON t.id = wppt.payment_transaction_id " 
                + " WHERE wppt.wpf_payment_id = :id "
                + " ORDER BY t.id ASC LIMIT 1";
        TypedQuery<PaymentTransactions> query = entityManager.createQuery(hql, PaymentTransactions.class).setParameter("id", id);
        List<PaymentTransactions> wpfPayments = query.getResultList();
        return wpfPayments.isEmpty() ? Optional.empty() : Optional.of(wpfPayments.get(0));
    }

但是当我运行代码时出现此错误:

Caused by: org.hibernate.hql.internal.ast.QuerySyntaxException: expecting IDENT, found '*' near line 1, column 10 [SELECT t.* FROM org.datalis.plugin.entity.PaymentTransactions t  INNER JOIN org.datalis.plugin.entity.WpfPaymentPaymentTransactions wppt  ON t.id = wppt.payment_transaction_id  WHERE wppt.wpf_payment_id = :id  ORDER BY t.id ASC LIMIT 1]

您知道如何解决此问题以及导致此问题的原因吗？

也许我需要实现 Spring Repository 并进行 native 查询？

Answer 1

将 t.* 替换为 t。

您希望返回 PaymentTransactions 对象，而不是其字段的值。

此外，HQL 不是 SQL，它不支持 *。