> Hi,
> The following cypher query which runs successfully on web console, throws
> error when i run it through SDN, Could you please let me know what could be
> the error here?
> START category=node:productline("productline:WOMENS_RTW") WITH
> collect(category) as categories START user=node:search("username:*a* OR
> name:*a*") WHERE ALL( c in categories WHERE user-[:has_category]->c) RETURN
> user
> Here is my query on repository,
> @Query( "START category=node:productline({0}) WITH collect(category) as
> categories" +
> "START user=node:search({1}) +
> "WHERE ALL( c in categories WHERE user-[:has_category]->c) RETURN user")
> Iterable<User> doAdvancedSearch(String Categories, String search);
> Here are the parameters those are passed,
> username:*a* OR name:*a*
> productline:*
> These are versions i have included in pom,
> <spring-data-neo4j.version>2.1.0.RC4</spring-data-neo4j.version>
> <org.jackson-version>1.9.7</org.jackson-version>
> <neo4j.version>1.8.RC1</neo4j.version>
> Here is the exception,
> Oct 6, 2012 3:22:22 PM org.apache.catalina.core.StandardWrapperValve invoke
> SEVERE: Servlet.service() for servlet [dispatcher] in context with path []
> threw exception [Request processing failed; nested exception is
> org.neo4j.rest.graphdb.RestResultException: Expected a parameter named 1 at
> BadInputException
> org.neo4j.server.rest.repr.RepresentationExceptionHandlingIterable.exceptio nOnHasNext(RepresentationExceptionHandlingIterable.java:51)
> org.neo4j.helpers.collection.ExceptionHandlingIterable$1.hasNext(ExceptionH andlingIterable.java:61)
> org.neo4j.helpers.collection.IteratorWrapper.hasNext(IteratorWrapper.java:4 2)
> org.neo4j.server.rest.repr.ListRepresentation.serialize(ListRepresentation. java:58)
> org.neo4j.server.rest.repr.Serializer.serialize(Serializer.java:75)
> org.neo4j.server.rest.repr.MappingSerializer.putList(MappingSerializer.java :61)
> org.neo4j.server.rest.repr.CypherResultRepresentation.serialize(CypherResul tRepresentation.java:50)
> org.neo4j.server.rest.repr.MappingRepresentation.serialize(MappingRepresent ation.java:42)
> org.neo4j.server.rest.repr.OutputFormat$1.write(OutputFormat.java:133)
> ] with root cause
> org.neo4j.rest.graphdb.RestResultException: Expected a parameter named 1 at
> BadInputException
> org.neo4j.server.rest.repr.RepresentationExceptionHandlingIterable.exceptio nOnHasNext(RepresentationExceptionHandlingIterable.java:51)
> org.neo4j.helpers.collection.ExceptionHandlingIterable$1.hasNext(ExceptionH andlingIterable.java:61)
> org.neo4j.helpers.collection.IteratorWrapper.hasNext(IteratorWrapper.java:4 2)
> org.neo4j.server.rest.repr.ListRepresentation.serialize(ListRepresentation. java:58)
> org.neo4j.server.rest.repr.Serializer.serialize(Serializer.java:75)
> org.neo4j.server.rest.repr.MappingSerializer.putList(MappingSerializer.java :61)
> org.neo4j.server.rest.repr.CypherResultRepresentation.serialize(CypherResul tRepresentation.java:50)
> org.neo4j.server.rest.repr.MappingRepresentation.serialize(MappingRepresent ation.java:42)
> org.neo4j.server.rest.repr.OutputFormat$1.write(OutputFormat.java:133)
> at org.neo4j.rest.graphdb.ExecutingRestAPI.query(ExecutingRestAPI.java:488)
> at org.neo4j.rest.graphdb.RestAPIFacade.query(RestAPIFacade.java:233)
> at
> org.neo4j.rest.graphdb.query.RestCypherQueryEngine.query(RestCypherQueryEng ine.java:50)
> at
> org.springframework.data.neo4j.rest.SpringRestCypherQueryEngine.query(Sprin gRestCypherQueryEngine.java:41)
> at
> org.springframework.data.neo4j.rest.SpringRestCypherQueryEngine.query(Sprin gRestCypherQueryEngine.java:27)
> at
> org.springframework.data.neo4j.repository.query.GraphRepositoryQuery.dispat chQuery(GraphRepositoryQuery.java:101)
> at
> org.springframework.data.neo4j.repository.query.GraphRepositoryQuery.execut e(GraphRepositoryQuery.java:80)
> at
> org.springframework.data.repository.core.support.RepositoryFactorySupport$Q ueryExecutorMethodInterceptor.invoke(RepositoryFactorySupport.java:313)
> at
> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(Reflec tiveMethodInvocation.java:172)
> at
> org.springframework.transaction.interceptor.TransactionInterceptor.invoke(T ransactionInterceptor.java:110)
> at
> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(Reflec tiveMethodInvocation.java:172)
> at
> org.springframework.dao.support.PersistenceExceptionTranslationInterceptor. invoke(PersistenceExceptionTranslationInterceptor.java:155)
> at
> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(Reflec tiveMethodInvocation.java:172)
> at
> org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopPr oxy.java:202)
> at $Proxy36.doAdvancedSearch(Unknown Source)
> at
> org.netvogue.server.neo4japi.service.UserServiceImpl.doAdvancedSearch(UserS erviceImpl.java:86)
> at
> org.netvogue.server.webmvc.controllers.SearchController.doAdvancedSearch(Se archController.java:84)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:3 9)
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImp l.java:25)
> at java.lang.reflect.Method.invoke(Method.java:597)
> at
> org.springframework.web.method.support.InvocableHandlerMethod.invoke(Invoca bleHandlerMethod.java:213)
> 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:923)
> at
> org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServl et.java:852)
> at
> org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkSe rvlet.java:882)
> at
> org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.jav a: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(Applicatio nFilterChain.java:304)
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterC hain.java:210)
> at
> org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilt er(FilterChainProxy.java:330)
> at
> org.springframework.security.web.access.intercept.FilterSecurityInterceptor .invoke(FilterSecurityInterceptor.java:118)
> at
> org.springframework.security.web.access.intercept.FilterSecurityInterceptor .doFilter(FilterSecurityInterceptor.java:84)
> at
> org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilt er(FilterChainProxy.java:342)
> at
> org.springframework.security.web.access.ExceptionTranslationFilter.doFilter (ExceptionTranslationFilter.java:113)
> at
> org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilt er(FilterChainProxy.java:342)
> at
> org.springframework.security.web.session.SessionManagementFilter.doFilter(S essionManagementFilter.java:103)
> at
> org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilt er(FilterChainProxy.java:342)
> at
> org.springframework.security.web.authentication.AnonymousAuthenticationFilt er.doFilter(AnonymousAuthenticationFilter.java:113)
> at
> org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilt er(FilterChainProxy.java:342)
> at
> org.springframework.security.web.servletapi.SecurityContextHolderAwareReque stFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:54)
> at
> org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilt er(FilterChainProxy.java:342)
> at
> org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFil ter(RequestCacheAwareFilter.java:45)
> at
> org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilt er(FilterChainProxy.java:342)
> at
> org.springframework.security.web.authentication.www.BasicAuthenticationFilter.doFilter(BasicAuthenticationFilter.java...)
> at
> org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilt er(FilterChainProxy.java:342)
> at
> org.netvogue.server.webmvc.filter.CaptchaVerifierFilter.doFilterInternal(Ca ptchaVerifierFilter.java:97)
> at
> org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequest Filter.java:76)
> at
> org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilt er(FilterChainProxy.java:342)
> at
> org.springframework.security.web.authentication.AbstractAuthenticationProce ssingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:183)
> at
> org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilt er(FilterChainProxy.java:342)
> at
> org.netvogue.server.webmvc.filter.CaptchaCaptureFilter.doFilterInternal(Cap tchaCaptureFilter.java:43)
> at
> org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequest Filter.java:76)
> at
> org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilt er(FilterChainProxy.java:342)
> at
> org.springframework.security.web.authentication.logout.LogoutFilter.doFilte r(LogoutFilter.java:105)
> at
> org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilt er(FilterChainProxy.java:342)
> at
> org.springframework.security.web.context.SecurityContextPersistenceFilter.d oFilter(SecurityContextPersistenceFilter.java:87)
> at
> org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilt er(FilterChainProxy.java:342)
> at
> org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterCh ainProxy.java:192)
> at
> org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy .java:160)
> at
> org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(Delegat ingFilterProxy.java:346)
> at
> org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFil terProxy.java:259)
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applicatio nFilterChain.java:243)
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterC hain.java:210)
> at
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.j ava:224)
> at
> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.j ava:169)
> at
> org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBas e.java:472)
> at
> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:16 8)
> at
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:10 0)
> at
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.jav a:118)
> at
> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:405)
> at
> org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Proc essor.java:964)
> at
> org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(Abstra ctProtocol.java:515)
> at
> org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java :302)
> at
> java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.j ava:886)
> at
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java: 908)
> at java.lang.Thread.run(Thread.java:680)