今天新同事遇到一个异常,通过如下方法做一个单元测试:
/**
* 通过HQL语句,取得该条件下的记录数量
* @param hql
* @return
*/
public Long getCountByQueryString(final String hql) {
return (Long) getHibernateTemplate().execute(new HibernateCallback() {
public Object doInHibernate(Session session) throws HibernateException,
SQLException {
Query query = session.createQuery(hql);
return query.uniqueResult();
}
});
}
因为原来的注释没有这么明确指出是用HQL入参,所有同事写了SQL执行查询,结果报错:
org.springframework.orm.hibernate3.HibernateQueryException: T_CC_L3_4S_Info is not mapped;
我看了下,猜到应当是SQL与HQL的不同导致的,于是,我换了成HQL查询:
String hql = "select count(*) from FoursInfo "。
结果还是报错:
org.springframework.orm.hibernate3.HibernateQueryException: FoursInfo is not mapped;
查了好一会,才发现表:T_CC_L3_4S_Info,对应的实体Bean是 FoursShopInfo ,而FoursInfo 是接口的Bean,
而且没有对应关系表导致。
从这件小事,我们应该吸取教训,不要想当然的以为表的名称和实体bean名称一致,当然,我们还是尽量保持表名和实体类命名的一致,这样才符合Java规范:见名知意!
分享到:
相关推荐
org.springframework.orm-3.0.4.RELEASE.jar org.springframework.oxm-3.0.4.RELEASE.jar org.springframework.spring-library-3.0.4.RELEASE.libd org.springframework.test-3.0.4.RELEASE.jar org.spring...
org.springframework.orm-3.0.0.M1.jar
NULL 博文链接:https://hw1287789687.iteye.com/blog/1967701
Class'org.springframework.orm.hibernate3.LocalSessionFactoryBean'not found 解决办法
org.springframework.orm.jar.zip
org.springframework.orm-3.1.RELEASE.jar org.springframework.oxm-3.1.RELEASE.jar org.springframework.spring-library-3.1.RELEASE.libd org.springframework.test-3.1.RELEASE.jar org.springframework....
org.springframework.orm-3.1.0.M2
org.springframework.beans-3.0.0.M4.jar
org.springframework.orm-3.0.0.RELEASE.jar org.springframework.oxm-3.0.0.RELEASE.jar org.springframework.test-3.0.0.RELEASE.jar org.springframework.transaction-3.0.0.RELEASE.jar org.springframework.web...
org.springframework.orm-3.0.0.M4.jar
org.springframework.orm-3.0.0.RELEASE org.springframework.oxm-3.0.0.RELEASE org.springframework.spring-library-3.0.0.RELEASE org.springframework.test-3.0.0.RELEASE org.springframework.transaction-...
org.springframework.orm-3.0.5.RELEASE.jar org.springframework.oxm-3.0.5.RELEASE.jar org.springframework.test-3.0.5.RELEASE.jar org.springframework.transaction-3.0.5.RELEASE.jar org.springframework.web...
org.springframework.orm-3.1.1.RELEASE org.springframework.oxm-3.1.1.RELEASE org.springframework.test-3.1.1.RELEASE org.springframework.transaction-3.1.1.RELEASE org.springframework.web.portlet-3.1.1....
org.springframework.instrument-3.0.5.RELEASE.jar,org.springframework.jdbc-3.0.5.RELEASE.jar,org.springframework.jms-3.0.5.RELEASE.jar,org.springframework.orm-3.0.5.RELEASE.jar,org.springframework....
<bean id="sqlMapClient" class="org.springframework.orm.ibatis.SqlMapClientFactoryBean"> <value>classpath:SqlMapConfig.xml <bean id="dao" class="org.springframework.orm.ibatis....
org.springframework.orm-3.1.0.RELEASE.jar org.springframework.oxm-3.1.0.RELEASE.jar org.springframework.test-3.1.0.RELEASE.jar org.springframework.transaction-3.1.0.RELEASE.jar org.springframework.web...
org.springframework.orm-3.0.1.jar
org.springframework.orm-3.0.2.RELEASE org.springframework.oxm-3.0.2.RELEASE org.springframework.spring-library-3.0.2.RELEASE org.springframework.test-3.0.2.RELEASE org.springframework.transaction-...
spring-hibernate3.jar包,直接导入路径即可,解决Class 'org.springframework.orm.hibernate3.LocalSessionFactoryBean' not found这个错误