ClassCastException for scrolling queries

[sergey-morenets]

Hi

We tried to use Scrolling API:

public interface OrderRepository 
	extends CrudRepository<Order, UUID> {
	
	Window<Order> findBy(ScrollPosition position);
}

However we received an exception when we invoked findBy() method:

Window<Order> window = orderRepository.findBy(ScrollPosition.offset());

Exception in thread "main" java.lang.ClassCastException: class demo.Order cannot be cast to class org.springframework.data.domain.Window (demo.Order and org.springframework.data.domain.Window are in unnamed module of loader 'app')
	at jdk.proxy2/jdk.proxy2.$Proxy89.findBy(Unknown Source)

[schauder]

Keyset pagination is not yet supported for Spring Data Relational.

[sergey-morenets]

Hi @schauder

Did you read carefully the ticket description? I didn't use pagination or keyset pagination. I used offset scrolling:

Window<Order> window = orderRepository.findBy(ScrollPosition.offset());

[schauder]

Window and ScrollPosition are part of the new Key Set pagination. Use Slice, Page and Pageable and you should be fine.

Readers of this issue might be interested in #1299

[ElTav]

@schauder Do you know when you folks plan to add support for Window/ScrollPosition? The infra you mentioned in #1299 was aded in spring-projects/spring-data-commons#2151 a few months back

[schauder]

Sorry, we don't have any specifics on those plans yet.

[ElTav]

Got it, what about Limit support from the 2023.M1 announcement?

[ElTav]

And is there an issue I can track for the rollout? Happy to create one otherwise

[schauder]

#1299

[ElTav]

Got it, will Limit be incorporated into the same release/any chance that could be incorporated sooner? Would fulfill the same requirement