在执行这个方法时:
public List<Sendnews> selectSNbyUid(int id) {
String sql = "select * from Sendnews s where s.isdel not in (1,2) and s.newid in (select n.newid from News n where n.uid=? and n.ispublic=1 and n.isdel not in(1,2))";
return getHibernateTemplate().find(sql, id);
}
报如下错误:
org.springframework.orm.hibernate3.HibernateQueryException: unexpected token: * near line 1, column 8 [select * from com.oa.pojo.Sendnews s where s.isdel not in (1,2) and s.newid in (select n.newid from com.oa.pojo.News n where n.uid=? and n.ispublic=1 and
n.isdel not in(1,2))];
后来发现报这个错的都是因为hql语句中有非法字符,比如次语句中的*
分享到:
相关推荐
### 关于 "org.springframework.orm.hibernate3.LocalSessionFactoryBean" 未找到问题的知识点解析 #### 一、问题背景 在开发基于Spring与Hibernate整合的应用时,可能会遇到“`org.springframework.orm.hibernate...
标题中的"org.springframework.orm.hibernate4.HibernateOptimisticLockingFailureException"是一个具体的异常类型,源自Spring框架的Hibernate4模块。这个异常通常在乐观锁(Optimistic Locking)机制失败时抛出,...
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
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.ObjectRetrievalFailureException`、`org.springframework.beans.factory.BeanCreationException` 和 `org.springframework.dao.InvalidDataAccessApiUsageException...
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.jar`是Spring框架中的一个子模块,主要关注对象关系映射(ORM)集成,使得Java应用程序能够方便地与各种数据库进行交互。本文将深入探讨Spring ORM模块的核心概念、功能以及实际应用...
org.springframework.orm-3.1.0.M2
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.beans-3.0.0.M4.jar
org.springframework.orm-3.0.0.M4.jar
<bean id="transactionManager" class="org.springframework.orm.hibernate5.HibernateTransactionManager"> ``` 2. **使用 `@Transactional` 注解**: 在Service层或具体的业务逻辑方法上添加 `@...
org.springframework.orm-3.0.0.M4.jar: 整合第三方的ORM框架,如hibernate,ibatis,jdo,以及spring的JPA实现 org.springframework.transaction-3.0.0.M4.jar: 为JDBC、Hibernate、JDO、JPA等提供的一致的声明式和...
<bean id="sqlMapClient" class="org.springframework.orm.ibatis.SqlMapClientFactoryBean"> <value>classpath:SqlMapConfig.xml <bean id="dao" class="org.springframework.orm.ibatis....
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'entityManagerFactory' defined in class path resource [org/springframework/boot/autoconfigure/orm/jpa/...
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-...
1. **org.springframework.context-3.0.5.RELEASE.jar**: 这个jar包是Spring框架的核心模块之一,它提供了应用上下文(ApplicationContext)的支持,这是Spring中管理和装配bean的主要接口。ApplicationContext...
spring-hibernate3.jar包,直接导入路径即可,解决Class 'org.springframework.orm.hibernate3.LocalSessionFactoryBean' not found这个错误