我正在尝试使用EntityGraph获取一些Lazy集合

在我的实体上

@Entity
@Table
......
 @NamedEntityGraph(name = "getDetails", attributeNodes = { @NamedAttributeNode(value = "prices") })
    @NamedNativeQuery(name = "MyTable.getData", query = "SELECT * FROM MyTable", resultClass = MyTable.class)

知识库

@Query(nativeQuery = true)
    @EntityGraph(value = "getDetails", type = EntityGraphType.FETCH)
            MyTable findData();

使用本机查询时,我得到了下一个异常

java.lang.ClassCastException:org.hibernate.internal.SQLQueryImpl无法在org.hibernate.jpa的org.hibernate.jpa.internal.QueryImpl.list(QueryImpl.java:604)中强制转换为org.hibernate.internal.QueryImpl . .internal.QueryImpl.getSingleResult(QueryImpl.java:529)at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl .java:43)在com.un.proxy的org.springframework.orm.jpa.SharedEntityManagerCreator $ DeferredQueryInvocationHandler.invoke(SharedEntityManagerCreator.java:372)的java.lang.reflect.Method.invoke(Method.java:498) . org.springframework.data.jpository.repository.query.JpaQueryExecution $ SingleEntityExecution.doExecute(JpaQueryExecution.java:206)org.springframework.data.jpa.repository.query.JpaQueryExecution.execute上的$ Proxy276.getSingleResult(未知来源) JpaQueryExecution.java:78)在org.springframework.data.jpa.re位于org.springframework.data.repository.core.support的org.springframework.data.jpa.repository.query.AbstractJpaQuery.execute(AbstractJpaQuery.java:92)中的pository.query.AbstractJpaQuery.doExecute(AbstractJpaQuery.java:102) . RepositoryFactorySupport $ QueryExecutorMethodInterceptor.doInvoke(RepositoryFactorySupport.java:482)org.springframework.data.repository.core.support.RepositoryFactorySupport $ QueryExecutorMethodInterceptor.invoke(RepositoryFactorySupport.java:460)at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed( ReflectiveMethodInvocation.java:179)org.springframework.data.projection.DefaultMethodInvokingMethodInterceptor.invoke(DefaultMethodInvokingMethodInterceptor.java:61)org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)at ..... ................................................在组织.apache.tomcat.util.threads.TaskThread $ WrappingRunnable.run(TaskThread.java:61)at java.lang.Thread.run(Thread.java) :745)

使用JPQL查询时一切正常 . 但我有一个很大的原生查询,这是非常痛苦的转换为JPQL . 在这种情况下有谁知道解决方法?将不胜感激任何帮助 .