hibernate+mysql ÕÒ²»µ½ÁУ¨ÔÚÏߵȣ©

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">