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")
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.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
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
...
> 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")
> 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.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
> 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
Does it also fail when you execute it with curl on the commandline or the http console?
Could you please check the server logs ind data/log for exceptions too?
Thanks a lot
Seems a bit like a problem between cypher parameters and batch rest params. Or something with the parameter generation in SDN. would it be possible to generate a unit test that exposes that behavior.
Michael
Sent from mobile device
Am 06.10.2012 um 12:32 schrieb Abdul Azeez Shaik <azeeztechni...@gmail.com>:
> 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
Thanks for the response.
Yes, below query worked pretty well on web console of Neo4j,
START category=node:productline("productline:DENIM") WITH collect(category)
as categories START user=node:search("name:*") WHERE ALL( c in categories
WHERE user-[:has_category]-c) RETURN user;
and SDN fails for the below one,
@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")
PFA, the neo4j.0.0.log which i found in data directory. Kindly let me know
if there are any other logs which i can send,
Coming to unit testing, am pretty new to java, so not sure on how to write,
if you can provide me link/code for any other cypher query and i could
replicate and give it to you immediately.
Another issue is, following query doesn't return any rows, Whereas they
return rows when i give ONLY denim or ...
START category=node:productline("productline:MENS_BAGS OR DENIM")
RETURN category;
Is there any other way of achieving this?
michael.hun...@neopersistence.com> wrote:
> Does it also fail when you execute it with curl on the commandline or the
> http console?
> Could you please check the server logs ind data/log for exceptions too?
> Thanks a lot
> Seems a bit like a problem between cypher parameters and batch rest
> params. Or something with the parameter generation in SDN.
> would it be possible to generate a unit test that exposes that behavior.
> Michael
> Sent from mobile device
> Am 06.10.2012 um 12:32 schrieb Abdul Azeez Shaik <azeeztechni...@gmail.com
> >:
> 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")
> 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.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
> 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
> Thanks for the response.
> Yes, below query worked pretty well on web console of Neo4j,
> START category=node:productline("productline:DENIM") WITH collect(category) as categories START user=node:search("name:*") WHERE ALL( c in categories WHERE user-[:has_category]-c) RETURN user;
> and SDN fails for the below one,
> @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")
> PFA, the neo4j.0.0.log which i found in data directory. Kindly let me know if there are any other logs which i can send,
> Coming to unit testing, am pretty new to java, so not sure on how to write, if you can provide me link/code for any other cypher query and i could replicate and give it to you immediately.
> Another issue is, following query doesn't return any rows, Whereas they return rows when i give ONLY denim or ...
> START category=node:productline("productline:MENS_BAGS OR DENIM") RETURN category;
> Is there any other way of achieving this?
> Thanks,
> Abdul
> On Sat, Oct 6, 2012 at 9:43 PM, Michael Hunger <michael.hun...@neopersistence.com> wrote:
>> Does it also fail when you execute it with curl on the commandline or the http console?
>> Could you please check the server logs ind data/log for exceptions too?
>> Thanks a lot
>> Seems a bit like a problem between cypher parameters and batch rest params. Or something with the parameter generation in SDN. >> would it be possible to generate a unit test that exposes that behavior.
>> Michael
>> Sent from mobile device
>> Am 06.10.2012 um 12:32 schrieb Abdul Azeez Shaik <azeeztechni...@gmail.com>:
>>> 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
michael.hun...@neopersistence.com> wrote:
> I meant the HTTP console where you can issue http requests directly.
> Sent from mobile device
> Am 06.10.2012 um 19:30 schrieb Abdul Azeez Shaik <azeeztechni...@gmail.com
> >:
> Hi Michael,
> Thanks for the response.
> Yes, below query worked pretty well on web console of Neo4j,
> START category=node:productline("productline:DENIM") WITH
> collect(category) as categories START user=node:search("name:*") WHERE ALL(
> c in categories WHERE user-[:has_category]-c) RETURN user;
> and SDN fails for the below one,
> @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")
> PFA, the neo4j.0.0.log which i found in data directory. Kindly let me know
> if there are any other logs which i can send,
> Coming to unit testing, am pretty new to java, so not sure on how to
> write, if you can provide me link/code for any other cypher query and i
> could replicate and give it to you immediately.
> Another issue is, following query doesn't return any rows, Whereas they
> return rows when i give ONLY denim or ...
> START category=node:productline("productline:MENS_BAGS OR DENIM") RETURN category;
> Is there any other way of achieving this?
> Thanks,
> Abdul
> On Sat, Oct 6, 2012 at 9:43 PM, Michael Hunger <
> michael.hun...@neopersistence.com> wrote:
>> Does it also fail when you execute it with curl on the commandline or the
>> http console?
>> Could you please check the server logs ind data/log for exceptions too?
>> Thanks a lot
>> Seems a bit like a problem between cypher parameters and batch rest
>> params. Or something with the parameter generation in SDN.
>> would it be possible to generate a unit test that exposes that behavior.
>> Michael
>> Sent from mobile device
>> Am 06.10.2012 um 12:32 schrieb Abdul Azeez Shaik <
>> azeeztechni...@gmail.com>:
>> 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")
>> 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.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
>> 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
> Here is the reply for curl command, i just tried one parameter,
> curl -H "accept:application/json" -H "content-type:application/json" -d'{"query":"START category=node:productline(\"productline:DENIM\") WITH collect(category) as categories START user=node:search({param1}) WHERE ALL( c in categories WHERE user-[:has_category]-c) RETURN user", "params": {"param1":"name:*"}}' http://localhost:7474/db/data/cypher > {
> "message" : "Expected a parameter named param1",
> "exception" : "BadInputException",
> "stacktrace" : [ "org.neo4j.server.rest.repr.RepresentationExceptionHandlingIterable.excepti onOnHasNext(RepresentationExceptionHandlingIterable.java:51)", "org.neo4j.helpers.collection.ExceptionHandlingIterable$1.hasNext(Exception HandlingIterable.java:61)", "org.neo4j.helpers.collection.IteratorWrapper.hasNext(IteratorWrapper.java: 42)", "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.jav a:61)", "org.neo4j.server.rest.repr.CypherResultRepresentation.serialize(CypherResu ltRepresentation.java:50)", "org.neo4j.server.rest.repr.MappingRepresentation.serialize(MappingRepresen tation.java:42)", "org.neo4j.server.rest.repr.OutputFormat.format(OutputFormat.java:170)", "org.neo4j.server.rest.repr.OutputFormat.formatRepresentation(OutputFormat. java:120)", "org.neo4j.server.rest.repr.OutputFormat.response(OutputFormat.java:107)", "org.neo4j.server.rest.repr.OutputFormat.ok(OutputFormat.java:55)", "org.neo4j.server.rest.web.CypherService.cypher(CypherService.java:80)", "java.lang.reflect.Method.invoke(Method.java:597)" ]
> On Sat, Oct 6, 2012 at 11:11 PM, Michael Hunger <michael.hun...@neopersistence.com> wrote:
>> I meant the HTTP console where you can issue http requests directly.
>> Sent from mobile device
>> Am 06.10.2012 um 19:30 schrieb Abdul Azeez Shaik <azeeztechni...@gmail.com>:
>>> Hi Michael,
>>> Thanks for the response.
>>> Yes, below query worked pretty well on web console of Neo4j,
>>> START category=node:productline("productline:DENIM") WITH collect(category) as categories START user=node:search("name:*") WHERE ALL( c in categories WHERE user-[:has_category]-c) RETURN user;
>>> and SDN fails for the below one,
>>> @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")
>>> PFA, the neo4j.0.0.log which i found in data directory. Kindly let me know if there are any other logs which i can send,
>>> Coming to unit testing, am pretty new to java, so not sure on how to write, if you can provide me link/code for any other cypher query and i could replicate and give it to you immediately.
>>> Another issue is, following query doesn't return any rows, Whereas they return rows when i give ONLY denim or ...
>>> START category=node:productline("productline:MENS_BAGS OR DENIM") RETURN category;
>>> Is there any other way of achieving this?
>>> Thanks,
>>> Abdul
>>> On Sat, Oct 6, 2012 at 9:43 PM, Michael Hunger <michael.hun...@neopersistence.com> wrote:
>>>> Does it also fail when you execute it with curl on the commandline or the http console?
>>>> Could you please check the server logs ind data/log for exceptions too?
>>>> Thanks a lot
>>>> Seems a bit like a problem between cypher parameters and batch rest params. Or something with the parameter generation in SDN. >>>> would it be possible to generate a unit test that exposes that behavior.
>>>> Michael
>>>> Sent from mobile device
>>>> Am 06.10.2012 um 12:32 schrieb Abdul Azeez Shaik <azeeztechni...@gmail.com>:
>>>>> 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
> On Sat, Oct 6, 2012 at 11:11 PM, Michael Hunger <
> michael.hun...@neopersistence.com> wrote:
>> I meant the HTTP console where you can issue http requests directly.
>> Sent from mobile device
>> Am 06.10.2012 um 19:30 schrieb Abdul Azeez Shaik <
>> azeeztechni...@gmail.com>:
>> Hi Michael,
>> Thanks for the response.
>> Yes, below query worked pretty well on web console of Neo4j,
>> START category=node:productline("productline:DENIM") WITH
>> collect(category) as categories START user=node:search("name:*") WHERE ALL(
>> c in categories WHERE user-[:has_category]-c) RETURN user;
>> and SDN fails for the below one,
>> @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")
>> PFA, the neo4j.0.0.log which i found in data directory. Kindly let me
>> know if there are any other logs which i can send,
>> Coming to unit testing, am pretty new to java, so not sure on how to
>> write, if you can provide me link/code for any other cypher query and i
>> could replicate and give it to you immediately.
>> Another issue is, following query doesn't return any rows, Whereas they
>> return rows when i give ONLY denim or ...
>> START category=node:productline("productline:MENS_BAGS OR DENIM") RETURN category;
>> Is there any other way of achieving this?
>> Thanks,
>> Abdul
>> On Sat, Oct 6, 2012 at 9:43 PM, Michael Hunger <
>> michael.hun...@neopersistence.com> wrote:
>>> Does it also fail when you execute it with curl on the commandline or
>>> the http console?
>>> Could you please check the server logs ind data/log for exceptions too?
>>> Thanks a lot
>>> Seems a bit like a problem between cypher parameters and batch rest
>>> params. Or something with the parameter generation in SDN.
>>> would it be possible to generate a unit test that exposes that behavior.
>>> Michael
>>> Sent from mobile device
>>> Am 06.10.2012 um 12:32 schrieb Abdul Azeez Shaik <
>>> azeeztechni...@gmail.com>:
>>> 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")
>>> 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.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
>>> 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
>> On Sat, Oct 6, 2012 at 11:11 PM, Michael Hunger <
>> michael.hun...@neopersistence.com> wrote:
>>> I meant the HTTP console where you can issue http requests directly.
>>> Sent from mobile device
>>> Am 06.10.2012 um 19:30 schrieb Abdul Azeez Shaik <
>>> azeeztechni...@gmail.com>:
>>> Hi Michael,
>>> Thanks for the response.
>>> Yes, below query worked pretty well on web console of Neo4j,
>>> START category=node:productline("productline:DENIM") WITH
>>> collect(category) as categories START user=node:search("name:*") WHERE ALL(
>>> c in categories WHERE user-[:has_category]-c) RETURN user;
>>> and SDN fails for the below one,
>>> @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")
>>> PFA, the neo4j.0.0.log which i found in data directory. Kindly let me
>>> know if there are any other logs which i can send,
>>> Coming to unit testing, am pretty new to java, so not sure on how to
>>> write, if you can provide me link/code for any other cypher query and i
>>> could replicate and give it to you immediately.
>>> Another issue is, following query doesn't return any rows, Whereas they
>>> return rows when i give ONLY denim or ...
>>> START category=node:productline("productline:MENS_BAGS OR DENIM") RETURN category;
>>> Is there any other way of achieving this?
>>> Thanks,
>>> Abdul
>>> On Sat, Oct 6, 2012 at 9:43 PM, Michael Hunger <
>>> michael.hun...@neopersistence.com> wrote:
>>>> Does it also fail when you execute it with curl on the commandline or
>>>> the http console?
>>>> Could you please check the server logs ind data/log for exceptions too?
>>>> Thanks a lot
>>>> Seems a bit like a problem between cypher parameters and batch rest
>>>> params. Or something with the parameter generation in SDN.
>>>> would it be possible to generate a unit test that exposes that behavior.
>>>> Michael
>>>> Sent from mobile device
>>>> Am 06.10.2012 um 12:32 schrieb Abdul Azeez Shaik <
>>>> azeeztechni...@gmail.com>:
>>>> 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"
>>>> )
>>>> 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.OutputFormat$1.write(OutputFormat.java:133)
>>>> ] with root cause
>>>> org.neo4j.rest.graphdb.RestResultException: Expected a parameter named
>>>> 1 at
>>>> BadInputException
> On Sun, Oct 7, 2012 at 8:26 AM, Abdul Azeez Shaik <azeeztechni...@gmail.com> wrote:
> Hi Micheal,
> I tried it on 1.8GA, it throws same error,
> curl -H "accept:application/json" -H "content-type:application/json" -d'{"query":"START category=node:productline(\"productline:DENIM\") WITH collect(category) as categories START user=node:search({param1}) RETURN user", "params": {"param1":"name:*"}}' http://localhost:7474/db/data/cypher > {
> "message" : "Expected a parameter named param1",
> "exception" : "BadInputException",
> "stacktrace" : [ "org.neo4j.server.rest.repr.RepresentationExceptionHandlingIterable.excepti onOnHasNext(RepresentationExceptionHandlingIterable.java:51)", "org.neo4j.helpers.collection.ExceptionHandlingIterable$1.hasNext(Exception HandlingIterable.java:61)", "org.neo4j.helpers.collection.IteratorWrapper.hasNext(IteratorWrapper.java: 42)", "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.jav a:61)", "org.neo4j.server.rest.repr.CypherResultRepresentation.serialize(CypherResu ltRepresentation.java:50)", "org.neo4j.server.rest.repr.MappingRepresentation.serialize(MappingRepresen tation.java:42)", "org.neo4j.server.rest.repr.OutputFormat.format(OutputFormat.java:170)", "org.neo4j.server.rest.repr.OutputFormat.formatRepresentation(OutputFormat. java:120)", "org.neo4j.server.rest.repr.OutputFormat.response(OutputFormat.java:107)", "org.neo4j.server.rest.repr.OutputFormat.ok(OutputFormat.java:55)", "org.neo4j.server.rest.web.CypherService.cypher(CypherService.java:80)", "java.lang.reflect.Method.invoke(Method.java:597)" ]
> I copied graph.db folder from data folder of RC1 to data folder of GA to get the old data(Kindly let me know if am missing anything here).
> Kindly let me know how to move forward on this issue. I would try debugging into Neo4j code today.
> Thanks,
> Abdul
> On Sun, Oct 7, 2012 at 12:10 AM, Michael Hunger <michael.hun...@neopersistence.com> wrote:
> Can you try to use neo4j 1.8 ga
> There was one issue regarding params resolved
> Not sure if before or after 1.8.rc1
> Michael
> Sent from mobile device
> Am 06.10.2012 um 20:12 schrieb Abdul Azeez Shaik <azeeztechni...@gmail.com>:
>> Hi Michael,
>> Here is the reply for curl command, i just tried one parameter,
>> curl -H "accept:application/json" -H "content-type:application/json" -d'{"query":"START category=node:productline(\"productline:DENIM\") WITH collect(category) as categories START user=node:search({param1}) WHERE ALL( c in categories WHERE user-[:has_category]-c) RETURN user", "params": {"param1":"name:*"}}' http://localhost:7474/db/data/cypher >> {
>> "message" : "Expected a parameter named param1",
>> "exception" : "BadInputException",
>> "stacktrace" : [ "org.neo4j.server.rest.repr.RepresentationExceptionHandlingIterable.excepti onOnHasNext(RepresentationExceptionHandlingIterable.java:51)", "org.neo4j.helpers.collection.ExceptionHandlingIterable$1.hasNext(Exception HandlingIterable.java:61)", "org.neo4j.helpers.collection.IteratorWrapper.hasNext(IteratorWrapper.java: 42)", "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.jav a:61)", "org.neo4j.server.rest.repr.CypherResultRepresentation.serialize(CypherResu ltRepresentation.java:50)", "org.neo4j.server.rest.repr.MappingRepresentation.serialize(MappingRepresen tation.java:42)", "org.neo4j.server.rest.repr.OutputFormat.format(OutputFormat.java:170)", "org.neo4j.server.rest.repr.OutputFormat.formatRepresentation(OutputFormat. java:120)", "org.neo4j.server.rest.repr.OutputFormat.response(OutputFormat.java:107)", "org.neo4j.server.rest.repr.OutputFormat.ok(OutputFormat.java:55)", "org.neo4j.server.rest.web.CypherService.cypher(CypherService.java:80)", "java.lang.reflect.Method.invoke(Method.java:597)" ]
>> On Sat, Oct 6, 2012 at 11:11 PM, Michael Hunger <michael.hun...@neopersistence.com> wrote:
>> I meant the HTTP console where you can issue http requests directly.
>> Sent from mobile device
>> Am 06.10.2012 um 19:30 schrieb Abdul Azeez Shaik <azeeztechni...@gmail.com>:
>>> Hi Michael,
>>> Thanks for the response.
>>> Yes, below query worked pretty well on web console of Neo4j,
>>> START category=node:productline("productline:DENIM") WITH collect(category) as categories START user=node:search("name:*") WHERE ALL( c in categories WHERE user-[:has_category]-c) RETURN user;
>>> and SDN fails for the below one,
>>> @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")
>>> PFA, the neo4j.0.0.log which i found in data directory. Kindly let me know if there are any other logs which i can send,
>>> Coming to unit testing, am pretty new to java, so not sure on how to write, if you can provide me link/code for any other cypher query and i could replicate and give it to you immediately.
>>> Another issue is, following query doesn't return any rows, Whereas they return rows when i give ONLY denim or ...
>>> START category=node:productline("productline:MENS_BAGS OR DENIM") RETURN category;
>>> Is there any other way of achieving this?
>>> Thanks,
>>> Abdul
>>> On Sat, Oct 6, 2012 at 9:43 PM, Michael Hunger <michael.hun...@neopersistence.com> wrote:
>>> Does it also fail when you execute it with curl on the commandline or the http console?
>>> Could you please check the server logs ind data/log for exceptions too?
>>> Thanks a lot
>>> Seems a bit like a problem between cypher parameters and batch rest params. Or something with the parameter generation in SDN. >>> would it be possible to generate a unit test that exposes that behavior.
>>> Michael
>>> Sent from mobile device
>>> Am 06.10.2012 um 12:32 schrieb Abdul Azeez Shaik <azeeztechni...@gmail.com>:
>>>> 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)
>>> On Sat, Oct 6, 2012 at 11:11 PM, Michael Hunger <
>>> michael.hun...@neopersistence.com> wrote:
>>>> I meant the HTTP console where you can issue http requests directly.
>>>> Sent from mobile device
>>>> Am 06.10.2012 um 19:30 schrieb Abdul Azeez Shaik <
>>>> azeeztechni...@gmail.com>:
>>>> Hi Michael,
>>>> Thanks for the response.
>>>> Yes, below query worked pretty well on web console of Neo4j,
>>>> START category=node:productline("productline:DENIM") WITH
>>>> collect(category) as categories START user=node:search("name:*") WHERE ALL(
>>>> c in categories WHERE user-[:has_category]-c) RETURN user;
>>>> and SDN fails for the below one,
>>>> @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")
>>>> PFA, the neo4j.0.0.log which i found in data directory. Kindly let me
>>>> know if there are any other logs which i can send,
>>>> Coming to unit testing, am pretty new to java, so not sure on how to
>>>> write, if you can provide me link/code for any other cypher query and i
>>>> could replicate and give it to you immediately.
>>>> Another issue is, following query doesn't return any rows, Whereas they
>>>> return rows when i give ONLY denim or ...
>>>> START category=node:productline("productline:MENS_BAGS OR DENIM") RETURN category;
>>>> Is there any other way of achieving this?
>>>> Thanks,
>>>> Abdul
>>>> On Sat, Oct 6, 2012 at 9:43 PM, Michael Hunger <
>>>> michael.hun...@neopersistence.com> wrote:
>>>>> Does it also fail when you execute it with curl on the commandline or
>>>>> the http console?
>>>>> Could you please check the server logs ind data/log for exceptions too?
>>>>> Thanks a lot
>>>>> Seems a bit like a problem between cypher parameters and batch rest
>>>>> params. Or something with the parameter generation in SDN.
>>>>> would it be possible to generate a unit test that exposes that
>>>>> behavior.
>>>>> Michael
>>>>> Sent from mobile device
>>>>> Am 06.10.2012 um 12:32 schrieb Abdul Azeez Shaik <
>>>>> azeeztechni...@gmail.com>:
>>>>> 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.OutputFormat$1.write(OutputFormat.java:133)
>>>>> ] with root cause
>>>>> org.neo4j.rest.graphdb.RestResultException: Expected a parameter named
>>>>> 1 at
>>>>> BadInputException
>>>> On Sat, Oct 6, 2012 at 11:11 PM, Michael Hunger
>>>> <michael.hun...@neopersistence.com> wrote:
>>>>> I meant the HTTP console where you can issue http requests directly.
>>>>> Sent from mobile device
>>>>> Am 06.10.2012 um 19:30 schrieb Abdul Azeez Shaik
>>>>> <azeeztechni...@gmail.com>:
>>>>> Hi Michael,
>>>>> Thanks for the response.
>>>>> Yes, below query worked pretty well on web console of Neo4j,
>>>>> START category=node:productline("productline:DENIM") WITH
>>>>> collect(category) as categories START user=node:search("name:*") WHERE ALL(
>>>>> c in categories WHERE user-[:has_category]-c) RETURN user;
>>>>> and SDN fails for the below one,
>>>>> @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")
>>>>> PFA, the neo4j.0.0.log which i found in data directory. Kindly let me
>>>>> know if there are any other logs which i can send,
>>>>> Coming to unit testing, am pretty new to java, so not sure on how to
>>>>> write, if you can provide me link/code for any other cypher query and i
>>>>> could replicate and give it to you immediately.
>>>>> Another issue is, following query doesn't return any rows, Whereas they
>>>>> return rows when i give ONLY denim or ...
>>>>> START category=node:productline("productline:MENS_BAGS OR DENIM")
>>>>> RETURN category;
>>>>> Is there any other way of achieving this?
>>>>> Thanks,
>>>>> Abdul
>>>>> On Sat, Oct 6, 2012 at 9:43 PM, Michael Hunger
>>>>> <michael.hun...@neopersistence.com> wrote:
>>>>>> Does it also fail when you execute it with curl on the commandline or
>>>>>> the http console?
>>>>>> Could you please check the server logs ind data/log for exceptions
>>>>>> too?
>>>>>> Thanks a lot
>>>>>> Seems a bit like a problem between cypher parameters and batch rest
>>>>>> params. Or something with the parameter generation in SDN.
>>>>>> would it be possible to generate a unit test that exposes that
>>>>>> behavior.
>>>>>> Michael
>>>>>> Sent from mobile device
>>>>>> Am 06.10.2012 um 12:32 schrieb Abdul Azeez Shaik
>>>>>> <azeeztechni...@gmail.com>:
>>>>>> 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
> >>> I copied graph.db folder from data folder of RC1 to data folder of GA
> to
> >>> get the old data(Kindly let me know if am missing anything here).
> >>> Kindly let me know how to move forward on this issue. I would try
> >>> debugging into Neo4j code today.
> >>> Thanks,
> >>> Abdul
> >>> On Sun, Oct 7, 2012 at 12:10 AM, Michael Hunger
> >>> <michael.hun...@neopersistence.com> wrote:
> >>>> Can you try to use neo4j 1.8 ga
> >>>> There was one issue regarding params resolved
> >>>> Not sure if before or after 1.8.rc1
> >>>> Michael
> >>>> Sent from mobile device
> >>>> Am 06.10.2012 um 20:12 schrieb Abdul Azeez Shaik
> >>>> <azeeztechni...@gmail.com>:
> >>>> Hi Michael,
> >>>> Here is the reply for curl command, i just tried one parameter,
> >>>> curl -H "accept:application/json" -H "content-type:application/json"
> >>>> -d'{"query":"START category=node:productline(\"productline:DENIM\")
> WITH
> >>>> collect(category) as categories START user=node:search({param1})
> WHERE ALL(
> >>>> c in categories WHERE user-[:has_category]-c) RETURN user", "params":
> >>>> {"param1":"name:*"}}' http://localhost:7474/db/data/cypher > >>>> {
> >>>> "message" : "Expected a parameter named param1",
> >>>> "exception" : "BadInputException",
> >>>> "stacktrace" : [
> >>>> On Sat, Oct 6, 2012 at 11:11 PM, Michael Hunger
> >>>> <michael.hun...@neopersistence.com> wrote:
> >>>>> I meant the HTTP console where you can issue http requests directly.
> >>>>> Sent from mobile device
> >>>>> Am 06.10.2012 um 19:30 schrieb Abdul Azeez Shaik
> >>>>> <azeeztechni...@gmail.com>:
> >>>>> Hi Michael,
> >>>>> Thanks for the response.
> >>>>> Yes, below query worked pretty well on web console of Neo4j,
> >>>>> START category=node:productline("productline:DENIM") WITH
> >>>>> collect(category) as categories START user=node:search("name:*")
> WHERE ALL(
> >>>>> c in categories WHERE user-[:has_category]-c) RETURN user;
> >>>>> and SDN fails for the below one,
> >>>>> @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")
> >>>>> PFA, the neo4j.0.0.log which i found in data directory. Kindly let me
> >>>>> know if there are any other logs which i can send,
> >>>>> Coming to unit testing, am pretty new to java, so not sure on how to
> >>>>> write, if you can provide me link/code for any other cypher query
> and i
> >>>>> could replicate and give it to you immediately.
> >>>>> Another issue is, following query doesn't return any rows, Whereas
> they
> >>>>> return rows when i give ONLY denim or ...
> >>>>> START category=node:productline("productline:MENS_BAGS OR DENIM")
> >>>>> RETURN category;
> >>>>> Is there any other way of achieving this?
> >>>>> Thanks,
> >>>>> Abdul
> >>>>> On Sat, Oct 6, 2012 at 9:43 PM, Michael Hunger
> >>>>> <michael.hun...@neopersistence.com> wrote:
> >>>>>> Does it also fail when you execute it with curl on the commandline
> or
> >>>>>> the http console?
> >>>>>> Could you please check the server logs ind data/log for exceptions
> >>>>>> too?
> >>>>>> Thanks a lot
> >>>>>> Seems a bit like a problem between cypher parameters and batch rest
> >>>>>> params. Or something with the parameter generation in SDN.
> >>>>>> would it be possible to generate a unit test that exposes that
> >>>>>> behavior.
> >>>>>> Michael
> >>>>>> Sent from mobile device
> >>>>>> Am 06.10.2012 um 12:32 schrieb Abdul Azeez Shaik
> >>>>>> <azeeztechni...@gmail.com>:
> >>>>>> 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,
<azeeztechni...@gmail.com> wrote:
> Thanks for the prompt response on the issue.
> Would this available as part of next 1.8 snapshot? or do i need to get
> latest 1.9?
> Regards,
> Abdul
> On Tue, Oct 16, 2012 at 2:58 PM, Peter Neubauer
> <peter.neuba...@neotechnology.com> wrote:
>> >>> I copied graph.db folder from data folder of RC1 to data folder of GA
>> >>> to
>> >>> get the old data(Kindly let me know if am missing anything here).
>> >>> Kindly let me know how to move forward on this issue. I would try
>> >>> debugging into Neo4j code today.
>> >>> Thanks,
>> >>> Abdul
>> >>> On Sun, Oct 7, 2012 at 12:10 AM, Michael Hunger
>> >>> <michael.hun...@neopersistence.com> wrote:
>> >>>> Can you try to use neo4j 1.8 ga
>> >>>> There was one issue regarding params resolved
>> >>>> Not sure if before or after 1.8.rc1
>> >>>> Michael
>> >>>> Sent from mobile device
>> >>>> Am 06.10.2012 um 20:12 schrieb Abdul Azeez Shaik
>> >>>> <azeeztechni...@gmail.com>:
>> >>>> Hi Michael,
>> >>>> Here is the reply for curl command, i just tried one parameter,
>> >>>> curl -H "accept:application/json" -H
>> >>>> "content-type:application/json"
>> >>>> -d'{"query":"START category=node:productline(\"productline:DENIM\")
>> >>>> WITH
>> >>>> collect(category) as categories START user=node:search({param1})
>> >>>> WHERE ALL(
>> >>>> c in categories WHERE user-[:has_category]-c) RETURN user", "params":
>> >>>> {"param1":"name:*"}}' http://localhost:7474/db/data/cypher >> >>>> {
>> >>>> "message" : "Expected a parameter named param1",
>> >>>> "exception" : "BadInputException",
>> >>>> "stacktrace" : [
>> >>>> On Sat, Oct 6, 2012 at 11:11 PM, Michael Hunger
>> >>>> <michael.hun...@neopersistence.com> wrote:
>> >>>>> I meant the HTTP console where you can issue http requests directly.
>> >>>>> Sent from mobile device
>> >>>>> Am 06.10.2012 um 19:30 schrieb Abdul Azeez Shaik
>> >>>>> <azeeztechni...@gmail.com>:
>> >>>>> Hi Michael,
>> >>>>> Thanks for the response.
>> >>>>> Yes, below query worked pretty well on web console of Neo4j,
>> >>>>> START category=node:productline("productline:DENIM") WITH
>> >>>>> collect(category) as categories START user=node:search("name:*")
>> >>>>> WHERE ALL(
>> >>>>> c in categories WHERE user-[:has_category]-c) RETURN user;
>> >>>>> and SDN fails for the below one,
>> >>>>> @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")
>> >>>>> PFA, the neo4j.0.0.log which i found in data directory. Kindly let
>> >>>>> me
>> >>>>> know if there are any other logs which i can send,
>> >>>>> Coming to unit testing, am pretty new to java, so not sure on how to
>> >>>>> write, if you can provide me link/code for any other cypher query
>> >>>>> and i
>> >>>>> could replicate and give it to you immediately.
>> >>>>> Another issue is, following query doesn't return any rows, Whereas
>> >>>>> they
>> >>>>> return rows when i give ONLY denim or ...
>> >>>>> START category=node:productline("productline:MENS_BAGS OR DENIM")
>> >>>>> RETURN category;
>> >>>>> Is there any other way of achieving this?
>> >>>>> Thanks,
>> >>>>> Abdul
>> >>>>> On Sat, Oct 6, 2012 at 9:43 PM, Michael Hunger
>> >>>>> <michael.hun...@neopersistence.com> wrote:
>> >>>>>> Does it also fail when you execute it with curl on the commandline
>> >>>>>> or
>> >>>>>> the http console?
>> >>>>>> Could you please check the server logs ind data/log for exceptions
>> >>>>>> too?
>> >>>>>> Thanks a lot
>> >>>>>> Seems a bit like a problem between cypher parameters and batch rest
>> >>>>>> params. Or something with the parameter generation in SDN.
>> >>>>>> would it be possible to generate a unit test that exposes that
>> >>>>>> behavior.
>> >>>>>> Michael
>> >>>>>> Sent from mobile device
>> >>>>>> Am 06.10.2012 um 12:32 schrieb Abdul Azeez Shaik
>> >>>>>> <azeeztechni...@gmail.com>:
>> >>>>>> 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