java - 错误 : org. hibernate.exception.SQLGrammarException: 无法提取 ResultSet 并且 dateAccessed 是未知列

Question

我在 spring MVC JAVA 中执行下面的查询

if (currentFireTime != null && previousFireTime != null) {
        timePart = " sal.dateAccessed between '" + previousFireTime + "' and '" + currentFireTime + "' and ";
    }
    String queryString = " select count(*) as COUNT FROM LogData sal where " + timePart + " sal.userSigned = false and sal.batchMetaDataId = "+batchId;
    SQLQuery sq =sessionFactory.getCurrentSession().createSQLQuery(queryString);
    sq.addScalar("COUNT", IntegerType.INSTANCE);
    sq.setResultTransformer(AliasToEntityMapResultTransformer.INSTANCE);
    List<Map<String,Object>> resultSet=sq.list();
    return (Integer)resultSet.get(0).get("COUNT");

当执行时看起来像这样并将其放入 Mysql 中它工作正常。但是我得到如下所示的错误。

select count(*) as COUNT FROM LogData sal where sal.dateAccessed between '2016-12-26 00:00:00.618' and '2016-12-26 01:00:00.618' and  sal.userSigned = false and sal.batchMetaDataId = 86

显示错误

    org.hibernate.exception.SQLGrammarException: could not extract ResultSet
at org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:82)
at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:49)
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:125)
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:110)

我需要更改显示的代码中的哪些内容？

Answer 1

您获取计数的方式有误。试试这个:

resultSet.getInt("COUNT");