Radompaginierung mit Spring Boot warf Ausnahme [org.springframework.dao.invaliddataAccessapiusageException] ⇐ Java

[Anonymous]

Ich erhalte den Fehler aus meinem Code, wenn ich versuche, zufällige paginierte Daten zu erhalten. Könnte mir bitte jemand helfen? Vielen Dank!2025-03-01T09:03:24.971Z ERROR 1 --- [twestmsevent] [http-nio-8094-exec-4] o.a.c.c.C.[.[.[/].[dispatcherServlet] : Servlet.service() for servlet [dispatcherServlet] in context with path [] threw exception [Request processing failed: org.springframework.dao.InvalidDataAccessApiUsageException: No position associated] with root cause
< /code>
Controller < /p>
@GetMapping
@ResponseStatus(OK)
public ResponseEntity
> getAllEvenements(@RequestParam(name = "page", defaultValue = "0") int page,
@RequestParam(name = "pageSize", defaultValue = "10") int pageSize,
@RequestParam(name = "seed", defaultValue = "0") int seed) {

Page evenementDtoPage = evenementService.getAllEvenements(page, pageSize, seed);
return ResponseEntity.status(OK).body(evenementDtoPage);
}
< /code>
Service -Implementierung < /p>
@Override
public Page getAllEvenements(int page, int pageSize, int seed) {
Page evenementPage = evenementRepository.findAllRandomized(seed, PageRequest.of(page, pageSize));
List evenementDtoList = evenementPage.stream().map(evenementMapper).toList();
return new PageImpl(evenementDtoList, evenementPage.getPageable(), evenementPage.getTotalElements());
}
< /code>
Repository < /p>
public interface EvenementRepository extends JpaRepository, JpaSpecificationExecutor {
Page findEvenementsByUserId(Long userId, Pageable pageable);

@Query(value = "SELECT DISTINCT evenement.user_id FROM evenement", nativeQuery = true)
Page findDistinctUserId(Pageable pageable);

@Query(value = "SELECT * FROM evenement ORDER BY RAND(:seed)", nativeQuery = true)
Page findAllRandomized(@Param("seed") int seed, Pageable pageable);
< /code>
} < /p>
Voller Stack < /p>

java.lang.ILLEGALSTATEException: Keine Position assoziiert
at org.springframework.data.jpa.repository.query.parameterbinding $ bindingIdentifier.getPosition (ParameterBinding.java:420) ~ [Spring-Data-Jpa-3.4.0.jar! /: 3.4.0]
AT org.springFramework.data.jpa.repository.query.queryparametersetterFactory $ BasicQueryparametersetterFactory.create (QueryparameterSetter.java:246) ~ [Spring-Data-JPA-3.4.0.jar! /: 3.4.0]
AT org.springFramework.data.jpa.repository.query.parameterbinderfactory.createqueryparameterSetter (parameterbinderfactory.java:146) ~ [Spring-Data-Jpa-3.4.0.jar! /: 3.4.0]
AT org.springframework.data.jpa.repository.query.parameterbinderfactory.createSetters (parameterbinderfactory.java:135) ~ [Spring-Data-JPA-3.4.0.jar! /: 3.4.0]
AT org.springframework.data.jpa.repository.query.parameterbinderfactory.createqueryawarebinder (parameterbinderfactory.java:102) ~ [Spring-Data-JPA-3.4.0.jar! /: 3.4.0]
at org.springframework.data.jpa.repository.query.abstractStringBasedJpaquery.Createbinder (AbstractStringBasedJpaQuery.java:141) ~ [Spring-Data-JPA-3.4.0.jar! /: 3.4.0]
AT org.springframework.data.jpa.repository.query.abstractStringBasedJpaquery.lambda $ 1 (AbstractStringBasedJpaquery.java:98) ~ [Spring-Data-JPA-3.4.0.jar! /: 3.4.0]
at org.springframework.data.util.lazy.getnullable (lazy.java:135) ~ [Spring-Data-Commons-0.4.0.Jar! /: 3.4.0]
at org.springframework.data.util.lazy.get (Lazy.java:113)) ~ [Springdata-commons-3.4.0.jar! /: 3.4.0]
at org.springframework.data.jpa.repository.query.abstractStringBasedJpaquery.docreatEcountQuery (AbstractStringbasedJpaquery.java:157)) ~ [Spring-Data-jpa-3.4.0.jar! /: 3.4.0]
at org.springFramework.data.jpa.repository.query.Abstractjpaquery.CreatEcountQuery (AbstractJpaquery.java:269) ~ [Spring-data-JPA-JPA-JPA-JPA-JPA-JPA-JAR! org.springframework.data.jpa.repository.query.jpaQueryexecution $ pagedExecution.count (jpaQueryexecution.java:211) ~ [Spring-Data-JPA-3.4.0.jar! /: 3.4.0]
at org.springFramework.data.jpa.repository.query.jpaqueryexecution $ pagedExecution.lambda $ 0 (jpaqueryexecution.java:206) ~ [Spring-Data-JPA-3.4.0.jar! /: 3.4.0]
at org.springframework.data.support.pagableExecutionutils.getPage (lehntedexexecutionutils.java:71) ~ [Spring-Data-commons-3.4.0.jar! /: 3.4.0]
at org.springFramework.data.jpa.repository.query.jpaqueryexecution $ pageExecution.doexecute (jpaqueryexecution.java:205) ~ [Spring-Data-Jpa-3.4.0.jar! /: 3.4.0]
AT org.springframework.data.jpa.repository.query.jpaqueryexecution.execute (jpaQueryexecution.java:93) ~ [Spring-Data-Jpa-3.4.0.jar! /: 3.4.0]
at org.springframework.data.jpa.repository.query.abstractjpaQuery.doexecute (AbstractJpaquery.java:152) ~ [Spring-Data-Jpa-Jpa-Jpa-JPA-JPA-JPA-JPA-JPA-JPA! /: 3.4.0]
AT org.springframework.data.jpa.repository.query.abstractjpaquery.execute (AbstractjpaQuery.java:140) ~ [Spring-Data-Jpa-3.4.0.jar! /: 3.4.0]
at org.springframework.data.repository.core.support.repositoryMethodinvoker.doinvoke (RepositoryMethodinvoker.java:170) ~ [Spring-Data-Commons-3.4.0.jar! /: 3.4.0]
AT org.springframework.data.repository.core.support.repositoryMethodinvoker.invoke (RepositoryMethodinvoker.java:158) ~ [Springdata-commons-3.4.0.jar! /: 3.4.0]
at org.springframework.data.repository.core.support.queryexecutorTheTinterceptor.doinvoke (queryexecutorTheDodinterceptor.java:170) ~ [Spring-Data-Commons-3.4.0.jar! /: 3.4.0]
at org.springFramework.data.repository.core.support.queryexecutorTheTinterceptor.invoke (queryexecutorTheTinterceptor.java:149) ~ [Spring-DATA-COMMONS-3.40.JAR! /: 3.4.0]
AT org.springframework.aop.framework.reflectivemethodinVocation.ProSece (reflectivemethodinVocation.java:184) ~ [Spring-AOP-6.2.0.jar! /: 6.2.0]
at org.springFramework.data.projection.DefaultMethodinVokingMethodinterceptor.invoke (DefaultMethodinVokingMethodinterceptor.java:69) ~ [Spring-Data-Commons-3.4.0.jar! /: 3.4.0]
AT org.springframework.aop.framework.reflectivemethodinVocation.ProSece (reflectivemethodinVocation.java:184) ~ [Spring-AOP-6.2.0.jar! /: 6.2.0]
at org.springframework.transaction.Interceptor.transactionaspectSupport.invokeWitHinTransaction (TransactionaspectSupport.java:380) ~ [Spring-TX-6.2.0.jar! /: 6.2.0]
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:119) ~[spring-tx-6.2.0.jar!/:6.2.0]
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184) ~[spring-aop-6.2.0.jar!/:6.2.0]
at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:138) ~[spring-tx-6.2.0.jar!/:6.2.0]
at org.springframework.aop.framework.reflectivemethodinVocation.ProSece (reflectivemethodinVocation.java:184) ~ [Spring-AOP-6.2.0.jar! /: 6.2.0]
at org.springFramework.data.jpa.repository.support.crudmethodmetadatapostprozessor $ crudmethodmetaPopulationsmethodinterceptor org.springframework.aop.framework.reflectivemethodinVocation.ProSece (reflectivemethodinVocation.java:184) ~ [Spring-AOP-6.2.0.jar! /: 6.2.0]
at org.springframework.aop.framework.jdkdynamicaoproxy.invoke (jdkdynamicaopproxy.java:223) ~ [Spring-Aop-6.2.0.jar!/: 6.2.0]
bei jdk.proxy2/jdk.proxy2. ~ [na: na]
at com.twest.msevent.service.serviceImpl.evenementsserviceImpl.getAllevenements (SavorementServiceImpl.java:190) ~ [! /: 0.0.1]
at com.twest.msevent.controller.even ~ [! /: 0.0.1]
at java.base /jdk.internal.reflect.nativemethodaccessorimpl.invoke0 (native Methode) ~ [Na: na]
at java.base /jdk.internal.reflect.nativemethodaccessorimpl.invoke (nativemethodaccessorimpl.java:77) ~ [na: na]
at java.base /jdk.internal.reflect.delegatingMethodaccessorimpl.invoke (DelegatingMethodaccessorImpl.java:43) ~ [na: na]
at java.base /java.lang.reflect.method.invoke (methody.java:568) ~ [na: na: method.java.java.java:568) ~ [na: na: method.java.java.java:568) ~ [na: na: method.java.java:568) [na: method.java org.springframework.web.method.support.invocableHandlermethod.doinvoke (invocableHandlermethod.java:255) ~ [Spring-Web-6.2.0.jar! /: 6.2.0]
at org.springframework.web.method.support.invocableHandlermethod.invokeForRequest (invocableHandlermethod.java:188) ~ [Spring-Web-6.2.0.jar! /: 6.2.0]
at org.springframework.web.servlet.mvc.method.annotation.servletinvocableHandlermethod.invokeandhandle (ServletinvocableHandlermethod.java:118) ~ [Spring-Webmvc-6.2.0.jar! /: 6.2.0]
AT org.springframework.web.servlet.mvc.method.annotation.requestmapingHandleradapter.invokeHandlermethod (RequestMappingHandlerAdapter.java:986) ~ [Spring-Webmvc-6.2.0.jar! org.springFramework.web.servlet.mvc.method.annotation.requestmapingHandleradapter.handleinternal (RequestMappingHandlerAdapter.java:891) ~ [Spring-Webmvc-6.2.0.jar! /: 6.2.0]
AT org.springframework.web.servlet.dispatcherServlet.dodispatch (DispatcherServlet.java:1088) ~ ~ [Spring-Webmvc-6.2.0.jar! /: 6.2.0]
at org.springFramework.web.Javlet.Dispatcherlet.Dispatcherlet.DispatcherLet.DispatcherServlet.DispatcherServlet.DispatcherServlet.DispatcherServlet.DispatcherServlet.DispatcherServlet.DispatcherServlet. ~ [Spring-Webmvc-6.2.0.jar! /: 6.2.0]
at org.springframework.web.servlet.FrameWorkServlet.ProcessRequest (FrameworkServlet.java:1014) ~ [Spring-Webmvc-6.2.jar! /: 6.2.0]
at AT-Webmvc-6.2.jar! /: 6.2.0: 6.2.2]
at AT-Webmvc-6.0.jar! /: 6.2.0: 6.2.0: 6.2.2]
at AT-Webmvc-6.0.jar! /: 6.2.0: 6.2. org.springframework.web.servlet.frameworkServlet.doget (FrameworkServlet.java:903) ~ [Spring-Webmvc-6.2.0.jar! /: 6.2.0]
at jakarta.Servlet.http.httplet.Servlet.Service (httplet.http.htplet.Service (httplet.httplet ~ [tomcat-embed-core-10.1.33.jar! /: na]
at org.springFramework.web.servlet.FrameWorkServlet.Service (FrameworkServlet.java:885) ~ [Spring-Webmvc-6.2.0.jar! /: 6.2.0]
at AT-Webmvc-6.0.jar! /: 6.2.0]
at AT-Webmvc-6.0.jar! /: 6.2.0]
at AT-Webmvc-6.0.jar! /: 6.2.0]
at at AT-Webmvc-6.0.jar! /: 6.2.0]
at at AT-Webmvc-6.0.jar! /: 6.2.0]
at at AT-Webmvc-6.0.jar! /: 6.2.0]
at at att jakarta.servlet.http.httpServlet.Service (httpServlet.java:658) ~ ~ [tomcat-embed-core-10.1.33.jar! /: na]
at org.apache.catalina.core.ApplicationFilterchain.interniler.inTerChain.Internilter.Internilter.Internilter.Internilter.Internilter (Application.InternChain. ~[tomcat-embed-core-10.1.33.jar!/:na]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:140) ~[tomcat-embed-core-10.1.33.jar!/:na]
at org.apache.tomcat.websocket.server.wsfilter.dofilter (wsfilter.java:51) ~ [tomcat-embed-websocket-10.1.33.jar! /: na]
at org.apache.catalina.core.applicationFilterchain.internaldofilter (applicationfilterchain.java:164) ~ [tomcat-embed-core-10.1.33.jar! /: na]
at org.apache.catalina ~ [tomcat-embed-core-10.1.33.jar! /: na]
at org.springFramework.web.filter.ServerhttpobServationFilter.Dofilterinternal (ServerhttpobServationFilter.java:114) ~ [Spring-Web-6.2.Jar! org.springframework.web.filter.onceperrequestFilter.dofilter (EinmalerRequestFilter.java:116) ~ [Spring-Web-6.2.0.jar! /: 6.2.0]
at org.apache.catalina.core.applicationFilterchain.internaldofilter (applicationfilterchain.java:164) ~ [tomcat-embed-core-10.1.33.jar! /: na]
at org.apache.catalina ~ [tomcat-embed-core-10.1.33.jar! /: na]
at org.springframework.web.filter.CharactercodingFilter.Dofilterinternal (charakteritätsschützer. org.springframework.web.filter.onceperrequestFilter.dofilter (EinmalerRequestFilter.java:116) ~ [Spring-Web-6.2.0.jar! /: 6.2.0]
at org.apache.catalina.core.applicationFilterchain.internaldofilter (applicationfilterchain.java:164) ~ [tomcat-embed-core-10.1.33.jar! /: na]
at org.apache.catalina ~[tomcat-embed-core-10.1.33.jar!/:na]
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:167) ~[tomcat-embed-core-10.1.33.jar!/:na]
at org.apache.catalina.core.standardcontextvalve.invoke (StandardContextValve.java:90) ~ [tomcat-embed-core-10.1.33.jar! /: na]
at org.apache.catalina.authenticator.Aauthenticator.authenticator. ~ [tomcat-embed-core-10.1.33.jar! /: na]
at org.apache.catalina.core.StandardHostvalve.invoke (StandardHostvalve.java:115) ~ [Tomcat-embed-core-10.1.33.jar! /: na]
AT AT AT AT AT AT AT AT AT AT AT AT. org.apache.catalina.valves.ErorRePortValve.invoke (ErrorRorportvalve.java:93) ~ [tomcat-embed-core-10.1.33.jar! /: na]
at org.apache.catalina.standardengine.invoke (standardgine.standardenvalvalvalvoke.invoke (standardgine.invoke ).invalval.invoke (standhardengine.invoke (standharnEgine.invoke ).invalvalvoke (standardargine.invoke (standharge.invoke ).invalvalvoke (standhardengine.invoke (standharge.invoke ).invalval.invoke (standhardengine.invoke (standhargegine.invoke ~ [tomcat-embed-core-10.1.33.jar! /: na]
at org.apache.catalina.connector.coyoteadapter.Service (Coyoteadapter.java:344) ~ [Tomcat-embed-core-10.1.33.jar! /: na]
at org. ~ [tomcat-embed-core-10.1.33.jar! /: na]
at org.apache.coyote.abstractProtocol $ connectionHandler.process (AbstractProtocol.java:905) ~ [Tomcat-embed-core-10.1.33.jar! /: na]
AT AT AT AT AT AT AT AT IN AT AT. org.apache.tomcat.util.net.nioendpoint $ socketProcessor.dorun (nioendpoint.java:1741) ~ [tomcat-embed-core-10.1.33.jar! /: na]
at org.apache.tomcat.util.net.socketprocessorbase.run (SocketProcessorbase.java:52) ~ [tomcat-embed-core-10.1.33.jar! /: na]
at org.apache.tomcat.util.threads.threadpoolexecutor.runworker (threadpoolexecutor.java:1190) ~ [tomcat-embed-core-10.1.33.jar! /: na]
at org.apache.tomcat.util.threads.threadpoolexecutor $ worker.run (threadpoolexecutor.java:659) ~ ~ [tomcat-embed-core-10.1.33.jar! /: na]
at org.apache.tomcat.util.taskthreads ~ [tomcat-embed-core-10.1.33.jar!/: na]
at java.base/java.lang.thread.run (thread.java:833) ~ [na: na]