原生sql org.hibernate.exception.DataException: could not execute query

[thinkpadshi]

如下是异常，但是sql语句直接复制到oracle中可以正常运行，不知道为什么嵌入原生的sql就没法运行了，断点设置发现还有一个异常，在could not execute query之前，那就是

Could not open Hibernate Session for transaction

org.springframework.dao.DataIntegrityViolationException: could not execute query; SQL [select to_char(apply_time,'yyyy-mm') as time,sum(approve_quota) as total from APPLY_INFO group by to_char(apply_time,'yyyy-mm') order by to_char(apply_time,'yyyy-mm');]; nested exception is org.hibernate.exception.DataException: could not execute query

在SSH中用原生的sql语句如下

public List nonPerforming() {
		return getHibernateTemplate().execute(
				new HibernateCallback<List>() {
					@Override
					public List doInHibernate(Session session)
							throws HibernateException, SQLException {
						SQLQuery query = session
								.createSQLQuery("select to_char(apply_time,'yyyy-mm') as time," +
										"sum(approve_quota) as total from APPLY_INFO " +
										"group by to_char(apply_time,'yyyy-mm') " +
										"order by to_char(apply_time,'yyyy-mm');");
						List results = query.list();
						return results;
					}
				});
	}

[thinkpadshi]

额，Could not open Hibernate Session for transaction这个错误消失了，现在只有那一个错误了，不知为什么myeclipse和浏览器都不直接显示错误，非要让我设置断点去看

[thinkpadshi]

卧槽，居然是多了一个分号，奶奶的