今天用Hibernate来执行sql语句,简单总结一下
SQLQuery query = null;
query = session.createSQLQuery("select * from fun as ca,(select * from comment as r1 where r1.created_at>=all(select r2.created_at from comment as r2 where r1.fun_id=r2.fun_id)) as re where ca.id=re.fun_id order by re.created_at desc;");
List<Fun> list = query.addEntity(Fun.class).list();
如果没有最后一行的addEntity方法,在执行过程中会产生
org.hibernate.MappingException: No Dialect mapping for JDBC type: -1
类似异常!