java - 分页 - 使用 Spring Data JPA 访问第二页时出现 UnsupportedOperationException

Question

我想向当前的应用程序添加分页。为此，我有以下代码:

MyEntity.java

@Entity
@Table(name="MY_ENTITY_1")
public class MyEntity {

    @Id
    @GeneratedValue
    @Column(name="P_ID")
    private Integer id;

    @Column(name = "C_CODEBRANCHE")
    private Integer codeBranche;

    // ...
}

MyEntityRepository.java

@Repository
public interface MyEntityRepository extends JpaRepository<MyEntity, Integer> {
}

MyServiceImpl.java

@Service
@Transactional
public class MyServiceImpl implements MyService {    
    @Autowired
    private MyEntityRepository myEntityRepository;

    @Override
    public Page<MyEntity> getEntities(Pageable pageable) {
        return myEntityRepository.findAll(pageable);
    }
}

和MyResource.java

@RestController
@RequestMapping("/")
public class MyResource {
    @Autowired
    private MyService myService;

    @GetMapping(path = "/myentity")
    public Page<MyEntity> getEntities(Pageable pageable) {
        return myService.getEntities(pageable);
    }
}

当我调用“/myentity”时，我有 20 个结果，这是正常的。

当我调用“/myentity?page=0&size=10”时，我有 10 个结果。

但是，当我调用“/myentity?page=1&size=10”时，我遇到以下问题:

ERROR 6864 --- [nio-8082-exec-1] o.a.c.c.C.[.[.[/].[dispatcherServlet] : Servlet.service() for servlet [dispatcherServlet] in context with path [] threw exception [Request processing failed; nested exception is java.lang.UnsupportedOperationException: query result offset is not supported] with root cause

java.lang.UnsupportedOperationException: query result offset is not supported at org.hibernate.dialect.DB2400Dialect$1.processSql(DB2400Dialect.java:26) ~[hibernate-core-5.0.12.Final.jar:5.0.12.Final] at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1893) ~[hibernate-core-5.0.12.Final.jar:5.0.12.Final] ...

我真的不知道出了什么问题。

Answer 1

也许您遇到了这个错误HHH-10489 。此错误已在 Hibernate 5.2.4.Final 中修复，那么您应该将 Hibernate 更新到该版本或更高版本。