Cypher query with exclusion of IDs

[kiteflo]

Hi,

we have a couple of node IDs we wanna exclude from our search result,
we could do sth like this:

start similar=node:SKW_NAMEKEY_SEARCH({searchString}) WHERE node.id !=
"123" AND node.id != "234" AND node.id != "345"...

But I'm pretty sure there is a smarter way of excluding IDs from a
search result - any hint? Any example query around for this one?

Thanks a lot in advance!
Cheers, Florian...

[Peter Neubauer]

I think you could use

Id(x) not in [1, 5,9 ]

Send from mobile.

[kiteflo]

hmmm...

tried several things, but theses all result in the exception below
(the important part is the WHERE clause, if we leave out the AND
condition it works like charm so the query is basically 100% ok).
Maybe I should have mentioned we are passing in the IDs we want to
filter as a query param (List<Long> offerIds), just to make sure you
get the situation right I put down our Repo-Service right here:

@Query("start similarSpat=node:GEO_INDEX({withinDistanceParam}),
offer=node({offerId}) " +
"MATCH (offer) -[r:"+RelTypes.CATEGORY_LINK+"]-> (category) " +
"<-[r2:"+RelTypes.CATEGORY_LINK+"]- (similar) " +
"<-[r3:GEOFIES]-loc<-[r4:MANUAL_SPATIAL_CONNECT]-similarSpat " +
"WHERE (similar.__type__ = 'Offer' " +
"AND ID(similar) NOT IN [{offerIds}]) " +
"return distinct similar, sum(r2.emphasis) order by
sum(r2.emphasis) desc")
public Page<OfferRecommendation>
findRelatedOffersForOfferWithinRadiusExcluding(
@Param("offerId") long offerId,
@Param("withinDistanceParam") String withinDistanceParam,
@Param("offerIds") List<Long> offerIds,
Pageable page);

Any clue what should be changed?

Thanx, Florian...


Error executing statement start
similarSpat=node:GEO_INDEX({withinDistanceParam}),
offer=node({offerId}) MATCH (offer) -[r:CATEGORY_LINK]-> (category) <-
[r2:CATEGORY_LINK]- (similar) <-[r3:GEOFIES]-loc<-
[r4:MANUAL_SPATIAL_CONNECT]-similarSpat WHERE (similar.__type__ =
'Offer' AND ID(similar) NOT IN [{offerIds}]) return distinct similar,
sum(r2.emphasis) order by sum(r2.emphasis) desc skip 0 limit 6; nested
exception is
org.springframework.dao.InvalidDataAccessResourceUsageException: Error
executing statement start
similarSpat=node:GEO_INDEX({withinDistanceParam}),
offer=node({offerId}) MATCH (offer) -[r:CATEGORY_LINK]-> (category) <-
[r2:CATEGORY_LINK]- (similar) <-[r3:GEOFIES]-loc<-
[r4:MANUAL_SPATIAL_CONNECT]-similarSpat WHERE (similar.__type__ =
'Offer' AND ID(similar) NOT IN [{offerIds}]) return distinct similar,
sum(r2.emphasis) order by sum(r2.emphasis) desc skip 0 limit 6; nested
exception is `-' expected but `N' found
Unfortunately, you have run into a syntax error that we don't have a
nice message for.
By sending the query that produced this error to cyp...@neo4j.org,
you'll save the
puppies and get better error messages in our next release.

Thank you, the Neo4j Team.] with root cause
`-' expected but `N' found
Unfortunately, you have run into a syntax error that we don't have a
nice message for.
By sending the query that produced this error to cyp...@neo4j.org,
you'll save the
puppies and get better error messages in our next release.

Thank you, the Neo4j Team.
at
org.neo4j.cypher.internal.parser.v1_7.CypherParserImpl.parse(CypherParserImpl.scala:
68)
at org.neo4j.cypher.CypherParser.parse(CypherParser.scala:44)
at org.neo4j.cypher.ExecutionEngine$$anonfun$prepare
$1.apply(ExecutionEngine.scala:61)
at org.neo4j.cypher.ExecutionEngine$$anonfun$prepare
$1.apply(ExecutionEngine.scala:61)
at org.neo4j.cypher.internal.LRUCache.getOrElseUpdate(LRUCache.scala:
31)
at org.neo4j.cypher.ExecutionEngine.prepare(ExecutionEngine.scala:61)
at org.neo4j.cypher.ExecutionEngine.execute(ExecutionEngine.scala:55)
at org.neo4j.cypher.ExecutionEngine.execute(ExecutionEngine.scala:58)
at
org.neo4j.cypher.javacompat.ExecutionEngine.execute(ExecutionEngine.java:
86)
at
org.springframework.data.neo4j.support.query.CypherQueryEngine.parseAndExecuteQuery(CypherQueryEngine.java:
65)
at
org.springframework.data.neo4j.support.query.CypherQueryEngine.query(CypherQueryEngine.java:
53)
at
org.springframework.data.neo4j.repository.query.GraphRepositoryQuery.dispatchQuery(GraphRepositoryQuery.java:
87)
at
org.springframework.data.neo4j.repository.query.GraphRepositoryQuery.execute(GraphRepositoryQuery.java:
70)
at
org.springframework.data.repository.core.support.RepositoryFactorySupport
$QueryExecutorMethodInterceptor.invoke(RepositoryFactorySupport.java:
313)
at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:
171)
at
org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:
110)
at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:
171)
at
org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:
155)
at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:
171)
at
org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:
204)
at $Proxy83.findRelatedOffersForOfferWithinRadiusExcluding(Unknown
Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:
39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:
25)
at java.lang.reflect.Method.invoke(Method.java:597)
at
org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:
307)
at
org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:
198)
at $Proxy84.findRelatedOffersForOfferWithinRadiusExcluding(Unknown
Source)
at
com.helios.service.plain.OfferService.findOffersSimilarExceptVisited(OfferService.java:
665)
at
com.helios.web.controller.OfferController.detail(OfferController.java:
364)
at com.helios.web.controller.OfferController$$FastClassByCGLIB$
$a1c74a23.invoke(<generated>)
at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:191)
at org.springframework.aop.framework.Cglib2AopProxy
$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:628)
at com.helios.web.controller.OfferController$$EnhancerByCGLIB$
$fbb2a9df.detail(<generated>)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:
39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:
25)
at java.lang.reflect.Method.invoke(Method.java:597)
at
org.springframework.web.method.support.InvocableHandlerMethod.invoke(InvocableHandlerMethod.java:
212)
at
org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:
126)
at
org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:
96)
at
org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:
617)
at
org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:
578)
at
org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:
80)
at
org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:
900)
at
org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:
827)
at
org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:
882)
at
org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:
778)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:621)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:
305)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:
210)
at
net.bull.javamelody.MonitoringFilter.doFilter(MonitoringFilter.java:
155)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:
243)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:
210)
at
net.bull.javamelody.MonitoringFilter.doFilter(MonitoringFilter.java:
197)
at
net.bull.javamelody.MonitoringFilter.doFilter(MonitoringFilter.java:
171)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:
243)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:
210)
at org.springframework.security.web.FilterChainProxy
$VirtualFilterChain.doFilter(FilterChainProxy.java:311)
at
org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:
116)
at
org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:
83)
at org.springframework.security.web.FilterChainProxy
$VirtualFilterChain.doFilter(FilterChainProxy.java:323)
at
org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:
113)
at org.springframework.security.web.FilterChainProxy
$VirtualFilterChain.doFilter(FilterChainProxy.java:323)
at
org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:
101)
at org.springframework.security.web.FilterChainProxy
$VirtualFilterChain.doFilter(FilterChainProxy.java:323)
at
org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:
113)
at org.springframework.security.web.FilterChainProxy
$VirtualFilterChain.doFilter(FilterChainProxy.java:323)
at
org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:
54)
at org.springframework.security.web.FilterChainProxy
$VirtualFilterChain.doFilter(FilterChainProxy.java:323)
at
org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:
45)
at org.springframework.security.web.FilterChainProxy
$VirtualFilterChain.doFilter(FilterChainProxy.java:323)
at
org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:
182)
at org.springframework.security.web.FilterChainProxy
$VirtualFilterChain.doFilter(FilterChainProxy.java:323)
at
org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:
105)
at org.springframework.security.web.FilterChainProxy
$VirtualFilterChain.doFilter(FilterChainProxy.java:323)
at
org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:
87)
at org.springframework.security.web.FilterChainProxy
$VirtualFilterChain.doFilter(FilterChainProxy.java:323)
at
org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:
173)
at
org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:
346)
at
org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:
259)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:
243)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:
210)
at
org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:
88)
at
org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:
76)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:
243)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:
210)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:
224)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:
169)
at
org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:
472)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:
168)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:
98)
at
org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:
928)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:
118)
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:
407)
at
org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:
987)
at org.apache.coyote.AbstractProtocol
$AbstractConnectionHandler.process(AbstractProtocol.java:539)
at org.apache.tomcat.util.net.JIoEndpoint
$SocketProcessor.run(JIoEndpoint.java:300)
at java.util.concurrent.ThreadPoolExecutor
$Worker.runTask(ThreadPoolExecutor.java:886)
at java.util.concurrent.ThreadPoolExecutor
$Worker.run(ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:680)

On 20 Mai, 13:11, Peter Neubauer <neubauer.pe...@gmail.com> wrote:
> I think you could use
>
> Id(x) not in [1, 5,9 ]
>
> Send from mobile.

[Michael Hunger]

you should use:

> "AND ID(similar) NOT IN {offerIds} "

as the parameter is already a list/iterable.

Michael

[kiteflo]

hmmm..this one we've tried as well but it results in the same
exception...(see below)

any further hints?

20.05.2012 21:18:50 org.apache.catalina.core.StandardWrapperValve
invoke
SCHWERWIEGEND: Servlet.service() for servlet [dispatcher] in context
with path [/helios] threw exception [Request processing failed; nested

$354f1354.detail(<generated>)

On 20 Mai, 15:47, Michael Hunger <michael.hun...@neotechnology.com>
wrote:

> > org.springframework.web.method.support.InvocableHandlerMethod.invoke(Invoca bleHandlerMethod.java:
> > 212)
> >    at
> > org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequ est(InvocableHandlerMethod.java:
> > 126)
> >    at
> > org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandl erMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:
> > 96)
> >    at
> > org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandler Adapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:
> > 617)
> >    at
> > org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandler Adapter.handleInternal(RequestMappingHandlerAdapter.java:
> > 578)
> >    at
> > org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.han dle(AbstractHandlerMethodAdapter.java:
> > 80)
> >    at
> > org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServ let.java:
> > 900)
> >    at
> > org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServl et.java:
> > 827)
> >    at
> > org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkSe rvlet.java:
> > 882)
> >    at
> > org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.jav a:

> >    at...
>
> Erfahren Sie mehr »

[kiteflo]

Hi...

we've tried several things this morning, for example querying our own
ID (unique and string based), there seems to be a problem with the NOT
IN clause because as soon as we put in the NOT IN stuff (even if we do
not pass in parameters and insert the condition manuall, for example
"AND similar.id NOT IN ['1','2']") it keeps failing with the same
exception.

Any of the cracks out there got an idea on this issue? Is NOT In
100%ly supported in Neo 1.7/SDN 2.1.0.BUILD-SNAPSHOT?

Thanx in advance, Florian...

> $354f1354.detail(<generated>)
>         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>         at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:
> 39)
>         at

> org.springframework.security.web.authentication.AnonymousAuthenticationFilt er.doFilter(AnonymousAuthenticationFilter.java:

> 113)
>         at org.springframework.security.web.FilterChainProxy
> $VirtualFilterChain.doFilter(FilterChainProxy.java:323)
>         at

> org.springframework.security.web.servletapi.SecurityContextHolderAwareReque stFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:

> 54)
>         at org.springframework.security.web.FilterChainProxy
> $VirtualFilterChain.doFilter(FilterChainProxy.java:323)
>         at
> org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFil ter(RequestCacheAwareFilter.java:
> 45)
>         at org.springframework.security.web.FilterChainProxy
> $VirtualFilterChain.doFilter(FilterChainProxy.java:323)
>         at
> org.springframework.security.web.authentication.AbstractAuthenticationProce ssingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:
> 182)
>         at org.springframework.security.web.FilterChainProxy
> $VirtualFilterChain.doFilter(FilterChainProxy.java:323)
>         at
> org.springframework.security.web.authentication.logout.LogoutFilter.doFilte r(LogoutFilter.java:
> 105)
>         at org.springframework.security.web.FilterChainProxy
> $VirtualFilterChain.doFilter(FilterChainProxy.java:323)
>         at
> org.springframework.security.web.context.SecurityContextPersistenceFilter.d oFilter(SecurityContextPersistenceFilter.java:
> 87)

>         at org.springframework.security.web.FilterChainProxy...
>
> Erfahren Sie mehr »

[Peter Neubauer]

Hi there,
I am getting the right results on http://tinyurl.com/bn35krt with

start n=node(*) where NOT (id(n) IN [0, 1, 2]) return n

Does that work? This is on the current SNAPSHOT.

Cheers,

/peter neubauer

G:  neubauer.peter
S:  peter.neubauer
P:  +46 704 106975
L:   http://www.linkedin.com/in/neubauer
T:   @peterneubauer

If you can write, you can code - @coderdojomalmo
If you can sketch, you can use a graph database - @neo4j

[kiteflo]

Hi Peter,

this one we've tried tried as well and we are experiencing two
different behaviors (please consider: this only occurs if we pass in
the "IN-value" as a parameter, if we write these into the query in
terms of [1,2,3] it works:

1) WHERE NOT (ID(similar) IN [{offerIds}]) AND (similar.__type__ =
'Offer')
-> query is executed without errors but we never receive results even
there should be some results around

2) WHERE NOT (ID(similar) IN {offerIds}) AND (similar.__type__ =
'Offer') (without [] brackets)
-> an exception occurs, see below

Do you have any hints when passing in the IN-params as a List of Long
values? Here is the full query including the way we pass in the
params, or do we need to pass in the params as a map with a certain
field property?

Thanx in advance, Florian..

@Query("start similarSpat=node:GEO_INDEX({withinDistanceParam}),
offer=node({offerId}) " +
"MATCH offer-[r1:"+RelTypes.CATEGORY_LINK+"]->category " +
"<-[r2:"+RelTypes.CATEGORY_LINK+"]-similar " +
"<-[r3:GEOFIES]-loc<-[r4:MANUAL_SPATIAL_CONNECT]-similarSpat " +
"WHERE NOT (ID(similar) IN [{offerIds}]) AND (similar.__type__ =
'Offer') " +

"return distinct similar, sum(r2.emphasis) order by

sum(r2.emphasis) desc")
public Page<OfferRecommendation>
findRelatedOffersForOfferWithinRadiusExcluding(
@Param("offerId") long offerId,
@Param("withinDistanceParam") String withinDistanceParam,
@Param("offerIds") List<Long> offerIds,
Pageable page);

(Exception thrown when using no brackets)
21.05.2012 10:44:21 org.apache.catalina.core.StandardWrapperValve

invoke
SCHWERWIEGEND: Servlet.service() for servlet [dispatcher] in context
with path [/helios] threw exception [Request processing failed; nested

exception is scala.MatchError: [1275] (of class java.util.ArrayList)]
with root cause
scala.MatchError: [1275] (of class java.util.ArrayList)
at
org.neo4j.cypher.internal.commands.InIterable.isMatch(InIterable.scala:
30)
at org.neo4j.cypher.internal.commands.Not.isMatch(Predicate.scala:94)
at
org.neo4j.cypher.internal.pipes.matching.SimplePatternMatcherBuilder$
$anonfun$getMatches$1$$anonfun$apply
$3.apply(SimplePatternMatcherBuilder.scala:86)
at
org.neo4j.cypher.internal.pipes.matching.SimplePatternMatcherBuilder$
$anonfun$getMatches$1$$anonfun$apply
$3.apply(SimplePatternMatcherBuilder.scala:86)
at scala.collection.LinearSeqOptimized
$class.forall(LinearSeqOptimized.scala:69)
at scala.collection.immutable.List.forall(List.scala:45)
at
org.neo4j.cypher.internal.pipes.matching.SimplePatternMatcherBuilder$
$anonfun$getMatches$1.apply(SimplePatternMatcherBuilder.scala:86)
at
org.neo4j.cypher.internal.pipes.matching.SimplePatternMatcherBuilder$
$anonfun$getMatches$1.apply(SimplePatternMatcherBuilder.scala:78)
at scala.collection.TraversableLike$$anonfun$flatMap
$1.apply(TraversableLike.scala:200)
at scala.collection.TraversableLike$$anonfun$flatMap
$1.apply(TraversableLike.scala:200)
at scala.collection.Iterator$class.foreach(Iterator.scala:652)
at scala.collection.JavaConversions
$JIteratorWrapper.foreach(JavaConversions.scala:573)
at scala.collection.IterableLike$class.foreach(IterableLike.scala:73)
at scala.collection.JavaConversions
$JIterableWrapper.foreach(JavaConversions.scala:587)
at scala.collection.TraversableLike
$class.flatMap(TraversableLike.scala:200)
at scala.collection.JavaConversions
$JIterableWrapper.flatMap(JavaConversions.scala:587)
at
org.neo4j.cypher.internal.pipes.matching.SimplePatternMatcherBuilder.getMatches(SimplePatternMatcherBuilder.scala:
78)
at
org.neo4j.cypher.internal.pipes.matching.MatchingContext.getMatches(MatchingContext.scala:
52)
at org.neo4j.cypher.internal.pipes.MatchPipe$$anonfun$createResults
$1.apply(MatchPipe.scala:33)
at org.neo4j.cypher.internal.pipes.MatchPipe$$anonfun$createResults
$1.apply(MatchPipe.scala:32)
at scala.collection.TraversableLike$$anonfun$flatMap
$1.apply(TraversableLike.scala:200)
at scala.collection.TraversableLike$$anonfun$flatMap
$1.apply(TraversableLike.scala:200)
at scala.collection.LinearSeqOptimized
$class.foreach(LinearSeqOptimized.scala:59)
at scala.collection.immutable.List.foreach(List.scala:45)
at scala.collection.TraversableLike
$class.flatMap(TraversableLike.scala:200)
at scala.collection.immutable.List.flatMap(List.scala:45)
at
org.neo4j.cypher.internal.pipes.MatchPipe.createResults(MatchPipe.scala:
32)
at
org.neo4j.cypher.internal.pipes.FilterPipe.createResults(FilterPipe.scala:
30)
at
org.neo4j.cypher.internal.pipes.EagerAggregationPipe.createResults(EagerAggregationPipe.scala:
48)
at
org.neo4j.cypher.internal.pipes.ExtractPipe.createResults(ExtractPipe.scala:
38)
at
org.neo4j.cypher.internal.pipes.SortPipe.createResults(SortPipe.scala:
33)
at
org.neo4j.cypher.internal.pipes.SlicePipe.createResults(SlicePipe.scala:
32)
at
org.neo4j.cypher.internal.pipes.ColumnFilterPipe.createResults(ColumnFilterPipe.scala:
37)
at org.neo4j.cypher.internal.executionplan.ExecutionPlanImpl$$anonfun
$3$$anonfun$apply$1.apply(ExecutionPlanImpl.scala:62)
at org.neo4j.cypher.internal.executionplan.ExecutionPlanImpl$$anonfun
$3$$anonfun$apply$1.apply(ExecutionPlanImpl.scala:62)
at
org.neo4j.cypher.PipeExecutionResult.immutableResult(PipeExecutionResult.scala:
36)
at
org.neo4j.cypher.PipeExecutionResult.iterator(PipeExecutionResult.scala:
138)
at
org.neo4j.cypher.PipeExecutionResult.hasNext(PipeExecutionResult.scala:
140)
at scala.collection.Iterator$$anon$19.hasNext(Iterator.scala:334)
at scala.collection.JavaConversions
$IteratorWrapper.hasNext(JavaConversions.scala:562)
at
org.neo4j.helpers.collection.IteratorWrapper.hasNext(IteratorWrapper.java:
42)
at
org.neo4j.helpers.collection.IteratorUtil.addToCollection(IteratorUtil.java:
322)
at
org.neo4j.helpers.collection.IteratorUtil.addToCollection(IteratorUtil.java:
341)
at
org.springframework.data.neo4j.repository.query.GraphRepositoryQuery.createPage(GraphRepositoryQuery.java:
107)
at
org.springframework.data.neo4j.repository.query.GraphRepositoryQuery.dispatchQuery(GraphRepositoryQuery.java:
88)
at
org.springframework.data.neo4j.repository.query.GraphRepositoryQuery.execute(GraphRepositoryQuery.java:

70)
at
org.springframework.data.repository.core.support.RepositoryFactorySupport
$QueryExecutorMethodInterceptor.invoke(RepositoryFactorySupport.java:
313)
at

org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:
171)
at
org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:
110)
at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:
171)
at
org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:
155)
at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:
171)
at
org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:

$fa7a360a.detail(<generated>)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:
39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:

25)
at java.lang.reflect.Method.invoke(Method.java:597)
at

org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:

54)
at org.springframework.security.web.FilterChainProxy
$VirtualFilterChain.doFilter(FilterChainProxy.java:323)
at
org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:
45)
at org.springframework.security.web.FilterChainProxy
$VirtualFilterChain.doFilter(FilterChainProxy.java:323)
at
org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:
182)
at org.springframework.security.web.FilterChainProxy
$VirtualFilterChain.doFilter(FilterChainProxy.java:323)
at
org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:
105)
at org.springframework.security.web.FilterChainProxy
$VirtualFilterChain.doFilter(FilterChainProxy.java:323)
at
org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:
87)

at org.springframework.security.web.FilterChainProxy
$VirtualFilterChain.doFilter(FilterChainProxy.java:323)
at

On 21 Mai, 10:06, Peter Neubauer <peter.neuba...@neotechnology.com>
wrote:

> >>         at...
>
> Erfahren Sie mehr »

[kiteflo]

...I will close this one and open up a new one, the "initial" issue of
querying has been resolved - the issue we are fighting down here is
another one so I keep this new issue separated as a new thread...

> $fa7a360a.detail(<generated>)
>         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>         at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:
> 39)
>         at

>         at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)...
>
> Erfahren Sie mehr »

[Peter Neubauer]

OK,
Good call Florian.

Send from mobile.