hibernate执行hql语句问题！！

[corruptsatan]

String hql = "select new map(convert(char(10),a.testDate,111) as testDate,sum(totalCase) as totalCase,sum(okCase) as okCase,sum(pokCase) as pokCase,sum(ntCase) as ntCase,sum(ngCase) as ngCase) " +
"from AutoTestRecord as a " +
"where a.testDate between '"+DateUtil.formatDate(beginDate)+"' and '"+DateUtil.formatDate(endDate)+"' group by convert(char(10),a.testDate,111)";

执行时报错。
java.lang.NullPointerException
org.hibernate.hql.NameGenerator.generateColumnNames(NameGenerator.java:23)
org.hibernate.hql.ast.util.SessionFactoryHelper.generateColumnNames(SessionFactoryHelper.java:386)
org.hibernate.hql.ast.tree.SelectClause.initializeColumnNames(SelectClause.java:247)
org.hibernate.hql.ast.tree.SelectClause.finishInitialization(SelectClause.java:237)
org.hibernate.hql.ast.tree.SelectClause.initializeExplicitSelectClause(SelectClause.java:231)
org.hibernate.hql.ast.HqlSqlWalker.useSelectClause(HqlSqlWalker.java:704)
。。。
。。。

改成这样就可以：
String hql = "select new map('2010-06-17' as testDate,sum(totalCase) as totalCase,sum(okCase) as okCase,sum(pokCase) as pokCase,sum(ntCase) as ntCase,sum(ngCase) as ngCase) " +
"from AutoTestRecord as a " +
"where a.testDate between '"+DateUtil.formatDate(beginDate)+"' and '"+DateUtil.formatDate(endDate)+"' group by convert(char(10),a.testDate,111)";

因为testDate为datetime类型，而我只要group by 日期，所以必须转换，但convert函数在group by后面是可以，但前面我也要select出来用，但就是报错。
请高手指点！！

[qiheia]

你的值有空，检查下你的参数值吧。。。

[i李小武]

可能是日期格式不匹配吧

[corruptsatan]

convert函数放到select后面就会报错，不知道什么原因。

我最后是用max函数解决问题的，反正我只关心日期，后面的时间取哪个都一样，所以max和min都可以。

String hql = "select new map(max(testDate) as testDate,sum(totalCase) as totalCase,sum(okCase) as okCase,sum(pokCase) as pokCase,sum(ntCase) as ntCase,sum(ngCase) as ngCase) " +"from AutoTestRecord " +"where testDate between '"+DateUtil.formatDate(beginDate)+"' and '"+DateUtil.formatDate(endDate)+"' group by convert(char(10),testDate,111)";

遇到同样问题的兄弟，可以参考我的办法。

这贴在留几天，希望高手可以讲解下convert函数出错的原因。

[tongxt1986tongxt1986]

回楼主："这贴在留几天，希望高手可以讲解下convert函数出错的原因。"

你留几天，等高手来解决，你自己都说不定已经解决了。等不了高手你就会自己解决的了。希望你快速解决