当我尝试从Spring Data仓库运行带有分页的@NamedQuery时，我考虑了一个问题。实体类如下：
@NamedQueries({
@NamedQuery(
name = "Customer.findByNamePattern",
query = "select c from Customer c where c.name like :pattern"
)
})
@Entity
public class Customer {
@Id
@GeneratedValue(strategy = GenerationType.TABLE)
private Long id;
private String name;
存储库接口是：
public interface CustomerRepository extends JpaRepository<Customer, Long> {
//@Query("select c from Customer c where c.name like :pattern")
Page<Customer> findByNamePattern(@Param("pattern") String pattern,Pageable pageable);
}
当我尝试从非事务上下文（junit）调用分页存储库方法时，它可以正常工作。
当我从事务性服务方法中调用它时，例如：
@Service("customerService")
@Transactional
public class CustomerServiceImpl implements CustomerService {
private static Logger log = Logger.getLogger( CustomerServiceImpl.class.getName());
@Autowired
private CustomerRepository customerRepository;
@Transactional(readOnly = true)
public Page<Customer> findAllPaged(int pageNum, int pageSize) {
PageRequest pr = new PageRequest(pageNum,pageSize);
return customerRepository.findAll(pr);
}
@Transactional(readOnly = true)
public Page<Customer> findByNamePatternPaged(String keyword, int pageNum, int pageSize) {
PageRequest pr = new PageRequest(pageNum,pageSize);
String pattern = "%"+keyword+"%";
return customerRepository.findByNamePattern(pattern, pr);
}
...调用findAllPaged()函数可以正常工作。
但是，当我尝试调用应该使用命名查询的方法时，总是会出现异常：
javax.persistence.RollbackException
org.springframework.transaction.TransactionSystemException: Could not commit JPA transaction; nested exception is javax.persistence.RollbackException: Transaction marked as rollbackOnly
at org.springframework.orm.jpa.JpaTransactionManager.doCommit(JpaTransactionManager.java:524)
at org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:757)
at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:726)
at org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:478)
at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:272)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:95)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:207)
at com.sun.proxy.$Proxy35.findByNamePatternPaged(Unknown Source)
at datapagedquery.service.TestCustomerService.testFindByPatternPaged(TestCustomerService.java:36)
...
Caused by: javax.persistence.RollbackException: Transaction marked as rollbackOnly
at org.hibernate.jpa.internal.TransactionImpl.commit(TransactionImpl.java:74)
at org.springframework.orm.jpa.JpaTransactionManager.doCommit(JpaTransactionManager.java:515)
... 33 more
在事务上下文中使用 org.springframework.data.jpa.repository.Query 注释的存储库方法可以正常工作。
经过一段时间的调试，似乎问题出在 org.springframework.data.jpa.repository.query.NamedQuery 的 doCreateCountQuery() 和 hasNamedQuery() 中：
@Override
protected TypedQuery<Long> doCreateCountQuery(Object[] values) {
EntityManager em = getEntityManager();
TypedQuery<Long> countQuery = null;
if (hasNamedQuery(em, countQueryName)) {
countQuery = em.createNamedQuery(countQueryName, Long.class);
} else {
Query query = createQuery(values);
String queryString = extractor.extractQueryString(query);
countQuery = em.createQuery(QueryUtils.createCountQueryFor(queryString, countProjection), Long.class);
}
return createBinder(values).bind(countQuery);
}
private static boolean hasNamedQuery(EntityManager em, String queryName) {
try {
em.createNamedQuery(queryName);
return true;
} catch (IllegalArgumentException e) {
LOG.debug("Did not find named query {}", queryName);
return false;
}
}
它试图从生成的名称
Customer.findByNamePattern.count 创建一个 TypedQuery，但该查询不存在于 EntityManager 的命名查询存储库中。 hasNamedQuery() 进行检查，捕获抛出的 IllegalArgumentException 并以另一种方式创建它。问题在于尽管捕获了 IllegalArgumentException，但事务仍然回滚（有时！）我找到了以下解决方法：
using
org.springframework.data.jpa.repository.Queryannotation on the repository methodOR- creating another named query
@NamedQuery( name = "Customer.findByNamePattern.count", query = "select count(c.id) from Customer c where c.name like :pattern" ),
- 调用
findAll() 应该会导致相同的问题，但它并没有。为什么？
- 使用 org.springframework.data.jpa.repository.Query 替代 @NamedQuery 也不会导致这个问题，为什么？
- 我如何在事务上下文中使用带有 pageable 选项的 @NamedQuery，以避免这个问题（而且不需要显式创建计数查询）？任何帮助都将不胜感激！
更新
所使用的版本为： Spring：4.0.5.RELEASE spring-data：1.6.0.RELEASE、1.7.0.RELEASE Hibernate：4.3.5.Final
阅读了类似错误的报告后[https://jira.spring.io/browse/DATAJPA-442]，我将 Hibernate 版本降级至 4.2.15.Final，问题得到了解决。 然而，一个问题仍然存在，是否可以在不更改 Hibernate 版本的情况下解决这个问题？