问题描述
我正在将 SpringDataNeo4J 3.0.0-M1 与 Neo4J 2.00-M0.6 一起使用.
I'm using SpringDataNeo4J 3.0.0-M1 with Neo4J 2.00-M0.6.
我有BetDAO节点，链接到具有BET_ANSWER关系的BetAnswerDAO节点集合.
I have BetDAO nodes, linked to a collection of BetAnswerDAO nodes with BET_ANSWER relationship.
我正尝试在同一请求上检索一个赌注及其所有答案.我有一个带有以下请求的BetRepository:
I'm trying to retrieve a bet and all its answers on the same request. I have a BetRepository with the following request :
@Query("start bet=node:BetDAO(id = {betId}) "
+ "match (bet)-[:BET_ANSWER]->(betAnswer) "
+ "return bet, collect(betAnswer) as betAnswers")
BetWithInfo getByIdWithInfo(@Param("betId") String id);
我的BetWithInfo对象:
My BetWithInfo object :
import org.springframework.data.neo4j.annotation.QueryResult;
import org.springframework.data.neo4j.annotation.ResultColumn;
import fr.project.commons.data.graph.neo4j.beans.nodes.BetAnswerDAO;
import fr.project.commons.data.graph.neo4j.beans.nodes.BetDAO;
@QueryResult
public interface BetWithInfo {
@ResultColumn("bet")
BetDAO getBet();
@ResultColumn("betAnswers")
Iterable<BetAnswerDAO> getBetAnswers();
}
该请求的执行没有错误，但是当我尝试访问下注答案集合时，出现以下错误:
The request is executed without errors, but when I try to access the bet answers collections, I get the following error :
Caused by: java.lang.RuntimeException: Cannot extract single value from Iterable with more than one elements.
at org.springframework.data.neo4j.conversion.DefaultConverter.extractSingle(DefaultConverter.java:60)
at org.springframework.data.neo4j.conversion.DefaultConverter.extractValue(DefaultConverter.java:51)
at org.springframework.data.neo4j.conversion.DefaultConverter.convert(DefaultConverter.java:40)
at org.springframework.data.neo4j.support.conversion.EntityResultConverter.convert(EntityResultConverter.java:165)
at org.springframework.data.neo4j.conversion.QueryResultBuilder$1.convert(QueryResultBuilder.java:103)
at org.springframework.data.neo4j.conversion.QueryResultBuilder$1.access$300(QueryResultBuilder.java:81)
at org.springframework.data.neo4j.conversion.QueryResultBuilder$1$1.underlyingObjectToObject(QueryResultBuilder.java:121)
at org.neo4j.helpers.collection.IteratorWrapper.next(IteratorWrapper.java:47)
at org.neo4j.helpers.collection.IteratorUtil.addToCollection(IteratorUtil.java:403)
at org.neo4j.helpers.collection.IteratorUtil.addToCollection(IteratorUtil.java:482)
at org.neo4j.helpers.collection.IteratorUtil.asCollection(IteratorUtil.java:581)
at org.springframework.data.neo4j.support.conversion.EntityResultConverter.extractAndSetValueOfField(EntityResultConverter.java:129)
at org.springframework.data.neo4j.support.conversion.EntityResultConverter.extractPOJOResult(EntityResultConverter.java:102)
at org.springframework.data.neo4j.support.conversion.EntityResultConverter.convert(EntityResultConverter.java:163)
at org.springframework.data.neo4j.conversion.DefaultConverter.convert(DefaultConverter.java:36)
at org.springframework.data.neo4j.rest.SpringRestGraphDatabase$SpringResultConverter.convert(SpringRestGraphDatabase.java:148)
at org.neo4j.rest.graphdb.util.QueryResultBuilder$1$1.underlyingObjectToObject(QueryResultBuilder.java:98)
at org.neo4j.helpers.collection.IteratorWrapper.next(IteratorWrapper.java:47)
at org.neo4j.helpers.collection.IteratorUtil.single(IteratorUtil.java:334)
at org.neo4j.helpers.collection.IteratorUtil.singleOrNull(IteratorUtil.java:130)
at org.neo4j.helpers.collection.IteratorUtil.singleOrNull(IteratorUtil.java:287)
at org.springframework.data.neo4j.rest.SpringEndResult.singleOrNull(SpringEndResult.java:39)
at org.springframework.data.neo4j.repository.query.GraphRepositoryQuery.dispatchQuery(GraphRepositoryQuery.java:115)
at org.springframework.data.neo4j.repository.query.GraphRepositoryQuery$1.doWithGraph(GraphRepositoryQuery.java:86)
at org.springframework.data.neo4j.support.Neo4jTemplate.doExecute(Neo4jTemplate.java:408)
at org.springframework.data.neo4j.support.Neo4jTemplate.access$000(Neo4jTemplate.java:85)
at org.springframework.data.neo4j.support.Neo4jTemplate$2.doInTransaction(Neo4jTemplate.java:422)
at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:130)
at org.springframework.data.neo4j.support.Neo4jTemplate.exec(Neo4jTemplate.java:419)
at org.springframework.data.neo4j.repository.query.GraphRepositoryQuery.execute(GraphRepositoryQuery.java:80)
at org.springframework.data.repository.core.support.RepositoryFactorySupport$QueryExecutorMethodInterceptor.invoke(RepositoryFactorySupport.java:337)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:155)
... 59 more
在我看来，我所做的确实与弹簧数据文档.我在做什么错了?
It seems to me that what I've done is really close from the example in spring-data documentation. What am I doing wrong ?
我在代码中犯了一个错误.当getBetAnswers()函数返回Iterable时，出现此错误.使用Collection时，出现以下错误:
EDIT : I made a mistake in my code. I get this error when the getBetAnswers() function returns an Iterable. With a Collection, I get the following error :
java.lang.ClassCastException: org.springframework.data.neo4j.conversion.QueryResultBuilder$1 cannot be cast to java.util.Collection
推荐答案
您确定
@Query("start bet=node:BetDAO(id = {betId}) "
+ "match (bet)-[:BET_ANSWER]->(betAnswer) "
+ "return bet, collect(betAnswer) as betAnswers")
BetWithInfo getByIdWithInfo(@Param("betId") String id);
仅返回1个结果?
据我了解，此查询在运行时返回几行，但告诉Spring Data仅返回1个BetWithInfo.
From what I understand, this query returns several rows at runtime but Spring Data is told to return only 1 BetWithInfo.
要么再次检查您的查询，以确保它仅返回1行，要么将您的方法返回类型从BetWithInfo迁移到Iterable<BetWithInfo>(或Collection<BetWithInfo>).
Either double-check your query thus making sure it returns only 1 row, or migrate your method return type from BetWithInfo to Iterable<BetWithInfo> (or Collection<BetWithInfo>).
这篇关于“无法从Iterable提取单个值"与自定义查询结果对象的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！