Радом странификация с пружинной загрузкой, брошенной исключением [org.springframework.dao.invaliddataaccessapiusageexexc ⇐ JAVA

[Anonymous]

Я получаю ошибку от своего кода, когда пытаюсь получить случайные страницы. Кто -нибудь может мне помочь? Большое спасибо! < /P>
Я использую Spring 3.4.0 и Java 17 < /p>
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>
контроллер < /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>
Реализация службы < /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>
Полный стек < /p>

Java.lang.illegalStateException: без положения
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 (queryparametersetterfactory.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.createequeryawarebinder (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-3.4.0.jar! /: 3.4.0]
at org.springframework.data.util.lazy.get (razy.java:113) ~ [Spring-Data-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-3.4.0.0. org.springframework.data.jpa.repository.query.jpaqueryExecution $ pagegexecution.count (jpaqueryexecution.java:211) ~ [Spring-Data-JPA-3.4.0.jar! /: 3.4.0]
at org.springframework.data.jpa.repository.query.jpaqueryexecution $ pagegexecution.lambda $ 0 (jpaqueryexecution.java:206) ~ [Spring-Data-JPA-3.4.0.jar! /: 3.4.0]
at org.springframework.data.support.pagableExecutionutils.getPage (PagableExecutionutils.java:71) ~ [Spring-Data-Commons-3.4.0.jar! /: 3.4.0]
at org.springframework.data.jpa.repository.query.jpaqueryexecution $ pagegexecution.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-3.4.0.jar! /: 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) ~ [Spring-Data-Commons-3.4.0.jar! /: 3.4.0]
at org.springframework.data.repository.core.support.queryexeCutormethodinterceptor.doinvoke (QueryExeCutormethodinterceptor.java:170) ~ [Spring-Data-Commons-3.4.0.jar! /: 3.4.0]
at org.springframework.data.repository.core.support.queryexeCutormethodinterceptor.invoke (QueryExeCutormethodinterceptor.java:149) ~ [Spring-Data-Commons-3.4.0.jar! /: 3.4.0]
at org.springframework.aop.framework.reflectivemethodinvocation.proceed (Refertivemethodinvocation.java:184) ~ [Spring-Aop-6.2.0.jar! /: 6.2.0]
at org.springframework.data.proction.defaultmethodinvokingmethodinterceptor.invoke (defaultmethodinvokingmethodinterceptor.java:69) ~ [Spring-Data-Commons-3.4.0.jar! /: 3.4.0]
at org.springframework.aop.framework.reflectivemethodinvocation.proceed (Refertivemethodinvocation.java:184) ~ [Spring-Aop-6.2.0.jar! /: 6.2.0]
at org.springframework.transaction.Interceptor.transactionAseppectsupport.invokewithinTransaction (TransactionAseppectsupport.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.reflectivemethodvocation.proecuecectocation. ~ [Spring-aop-6.2.0.jar! /: 6.2.0]
at org.springframework.dao.support.persistenceexceptionTranslationInterceptor.invoke (PersistenceExceptionTranslationInterceptor.java:138) ~ [Spring-TX-6. org.springframework.aop.framework.reflectivemethodinvocation.proceed (Refertivemethodinvocation.java:184) ~ [Spring-Aop-6.2.0.jar! /: 6.2.0]
at org.springframework.data.jpa.repository.support.crudmethodmetadatapostprocessor $ crudmethodmetadatapopulationmethodinterceptor.invoke (crudmethodmetadatapostprocessor.java:136) ~ [Spring-data-jpa-34.0.0. org.springframework.aop.framework.reflectivemethodinvocation.proceed (Refertivemethodinvocation.java:184) ~ [Spring-Aop-6.2.0.jar! /: 6.2.0]
at org.springframework.aop.framework.jdkdynamicaopproxy.invoke (jdkdynamicaopproxy.java:223) ~ [Spring-aop-6.2.0.jar!/: 6.2.0]
at jdk.proxy2/jdk.proxy2. ~ [na: na]
at com.twest.msevent.service.serviceimpl.evenementserviceimpl.getallevenements (werementserviceimpl.java:190) ~ [! /: 0.0.1]
at com.twest.msevent.controler.evenementemementconementementementementvenementsenementementementvenementevenementementevenementementevenementementementevenementementementsementementsementementementementementsenementementementsementementementementsement. ~ [!/: 0.0.1]
at java.base/jdk.internal.reflect.nativemethodaccessoriMpl.invoke0 (нативный метод) ~ [na: na]
at java.base/jdk.internal.reflect.nativemethodaccressirempl.invoke (nativemet.jhesspresspressprecspor.j -j ~ [na: na]
at java.base /jdk.internal.reflect.delegatingmethodaccessorimpl.invoke (делегирующий methodaccessorimpl.java:43) ~ [na: na]
at java.base /java.lang.reflect.method.invoke (метод. ~ [na: na]
at org.springframework.web.method.support.invocableHandlerMethod.doinvoke (envociateHandlerMethod.java:255) ~ [Spring-web-6.2.0.jar! /: 6.2.0]
at at org.springframework.web.method.support.invocablehandlermethod.invokeforRequest (выдвигаемый handhandhethod.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.requestmappingHandlerAdapter.invokehandlermethod (requestMappingHandlerAdapter.java:986) ~ [Spring-Webmvc-6.2.0.jar! /: 6.2.0]
at org.springframework.web.servlet.mvc.method.annotation.requestmappingHandlerAdapter.handleinternal (requestMappingHandlerAdapter.java:891) ~ [Spring-Webmvc-6.2.0.jar! /: 6.2.0]
at org.springframework.web.servlet.mvc.method.abstracthandlermethodadapter.handle (Abstracthandlermethodapter.java:87) ~ [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.servlet.dispatcherservlecererverveler.doserviceervererv. ~ [Spring-webmvc-6.2.0.jar! /: 6.2.0]
at org.springframework.web.servlet.frameworkservlet.processrequest (Frameworkservlet.java:1014) ~ [Spring-webmvc-6.2.0.jar! /: 6.2.0] org.springframework.web.servlet.frameworkservlet.doget (frameworkservlet.java:903) ~ [Spring-webmvc-6.2.0.jar! /: 6.2.0]
at jakarta.servlet.http.httpservlet.service.service.service.service (httpllet.javlet.http.httpservlet.service.servlet.javlet.http.httpservlet.service.http.httpservlet.service.http.http.htp ~ [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] jakarta.servlet.http.httpservlet.service (httpservlet.java:658) ~ [tomcat-embed-core-10.1.33.jar! /: na]
at org.apache.catalina.core.applicationFilterChain.InternAldOfilter (ApplionFilterChain. ~ [tomcat-embed-core-10.1.33.jar! /: na]
at org.apache.catalina.core.applicationfilterchain.dofilter (ApplicationFilterChain.java:140) ~ [Tomcat-Embed-Core-10.1.33. 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.core.applicationfilterchain.dofilter ~ [Tomcat-embed-core-10.1.33.jar! /: na]
at org.springframework.web.filter.serverhttpobservationfilter.dofilterinternal (serverhttpobservationfilter.java:114) ~ [Spring-web-6.2.0.0.1.1.0.12.0 /:. org.springframework.web.filter.onceperrequestfilter.dofilter (oneperrequestfilter.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.core.applicationfilterchain.dofilter ~ [Tomcat-embed-core-10.1.33.jar! /: na]
at org.springframework.web.filter.characterencodingfilter.dofilterinternal (Harxerencodingfilter.java:201) ~ [Spring-web-6. org.springframework.web.filter.onceperrequestfilter.dofilter (oneperrequestfilter.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.core.applicationfilterchain.dofilter ~ [tomcat-embed-core-10.1.33.jar! /: na]
at org.apache.catalina.core.standardwrappervalve.invoke (Standardwrappervalve.java:167) ~ [tomcat-embed-core-10.1.33. org.apache.catalina.core.standardcontextvalve.invoke (StandardContextValve.java:90) ~ [tomcat-embed-core-10.1.33.jar! /: na]
at org.apache.catalina.authenticator.authenticatorbase.invoke (autenticatorbasebasebasebasebasebasebasebasebasebasebasebase.jjauthator. ~ [tomcat-embed-core-10.1.33.jar! /: na]
at org.apache.catalina.core.standardhostvalve.invoke (standarhostvalve.java:115) ~ [tomcat-embed-core-10.1.33. org.apache.catalina.valves.errorreportvalve.invoke (errorReportValve.java:93) ~ [tomcat-embed-core-10.1.33.jar! /: na]
at org.apache.catalina.core.standardenginevalve.invoke (standarenginevalve.javaavawalive.javaaavawalive.javaavawalive.javaavaalve.javaavaalve.javaawaal ~ [tomcat-embed-core-10.1.33.jar! /: na]
at org.apache.catalina.connector.coyoteadapter.service (coyoteadapter.java:344) ~ [tomcat-embed-core-10.1.33. org.apache.coyote.http11.http11processor.service (http11processor.java:397) ~ [tomcat-embed-core-10.1.33.jar! /: na]
at org.apache.coyote.abstractprocessorse.process (Abstractprocessorlight. ~ [tomcat-embed-core-10.1.33.jar! /: na]
at org.apache.coyote.abstractprotocol $ connectionhandler.process (AbstractProtocol.java:905) ~ [tomcat-embed-cor-10.1.33. 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. org.apache.tomcat.util.threads.threadpoolexecutor $ abray.run (threadpoolexecutor.java:659) ~ [tomcat-embed-core-10.1.33.jar! /: na]
at org.apache.tomcat.util.threads.taskthread $ wrappingrunnable.run (taskthread.java:63) ~ [tomcat-embed-core-10.1.33.jar!/: na]
at java.base/java.lang.thread.run (Thread.java:8333333333333 гг. /> < /blockquote>

Подробнее здесь: https://stackoverflow.com/questions/794 ... -dao-inval