select sum(seconds) as c1, userid as c2, DATE_FORMAT(begintime,'%Y-%m-%d') as c3
from ActionRecord
where begintime >= '2009-09-01'
and endtime <= '2009-09-27'
and userid='admin'
and actiontype='LOGIN'
group by userid, DATE_FORMAT(begintime,'%Y-%m-%d')
报如下错误:
INFO - could not read column value from result set: ; Column '' not found.
WARN - SQL Error: 0, SQLState: S0022
ERROR - Column '' not found.
WARN - org.hibernate.exception.SQLGrammarException: could not execute query
数据库中表有列确实存在，就是会报错，这条语句有数据库中执行没有问题
实体与表没有映射好吧。
再检查检查。
<hibernate-mapping>
<class name="com.zldigital.domain.model.act.ActionRecord" table="ACTIONRECORD">
<id name="uid" type="java.lang.String">
<column name="ACTIONID" length="64" />
<generator class="assigned" />
</id>
<property name="userid" type="java.lang.String">
