java hibernate本机查询变量

Question

我正在尝试编写本机查询：

@NamedNativeQuery(name = "getUncheckedTests",
    query = "SELECT t.test_name AS test_name, q.question AS question, @counter \\:= COUNT(ua.is_checked=0) AS uncheckedAnswers FROM user_answer ua" +
            " JOIN result r on r.id = ua.result_id" +
            " JOIN test t on r.test_id = t.id" +
            " JOIN question q on ua.question_id = q.id" +
            " WHERE r.is_checked = false AND q.is_open = true AND ua.is_checked = false" +
            " AND r.test_id IN (SELECT t.id FROM result r" +
            " JOIN test t on t.id = r.test_id" +
            " JOIN user u on u.id = r.user_id" +
            " WHERE r.permission = 2 AND u.id = :userId) and r.permission = 1 and @counter > 0" +
            " GROUP BY ua.question_id")

但是，由于@counter > 0不能正常工作，我得到的结果是空的。我可以在Workbench中执行这个查询，但是如果将它作为本机查询放在Hibernate中，则不会产生任何结果

Answer 1

您可能应该检查由enabling logging of the statements或使用log4jdbc执行的实际SQL Hibernate，并确保使用正确的参数执行查询