org.springframework.dao.InvalidDataAccessResourceUsageException: Error executing statement start n=node({0}) match (n)-[r]->(inbox) where r.relation in {%strings} return inbox ; nested exception is org.springframework.dao.InvalidDataAccessResourceUsageException: Error executing statement start n=node({0}) match (n)-[r]->(inbox) where r.relation in {%strings} return inbox ; nested exception is expected return clause "start n=node({0}) match (n)-[r]->(inbox) where r.relation in {%strings} return inbox " ^

coderanch.com | 4 months ago
  1. 0

    using In clause in @query spring neo4j (Neo4j forum at Coderanch)

    coderanch.com | 4 months ago
    org.springframework.dao.InvalidDataAccessResourceUsageException: Error executing statement start n=node({0}) match (n)-[r]->(inbox) where r.relation in {%strings} return inbox ; nested exception is org.springframework.dao.InvalidDataAccessResourceUsageException: Error executing statement start n=node({0}) match (n)-[r]->(inbox) where r.relation in {%strings} return inbox ; nested exception is expected return clause "start n=node({0}) match (n)-[r]->(inbox) where r.relation in {%strings} return inbox " ^
  2. 0

    problem using @query in spring neo4j

    GitHub | 3 years ago | Amitosh1
    org.springframework.dao.InvalidDataAccessResourceUsageException: Error executing statement start n=node({0}) match (n)-[r]->(inbox) where r.relation in {1} return inbox ; nested exception is org.springframework.dao.InvalidDataAccessResourceUsageException: Error executing statement start n=node({0}) match (n)-[r]->(inbox) where r.relation in {1} return inbox ; nested exception is expected return clause "start n=node({0}) match (n)-[r]->(inbox) where r.relation in {1} return inbox " ^
  3. 0

    Errors of simple customized queries in Spring Data Neo4j

    Stack Overflow | 3 years ago | LoveTW
    org.springframework.dao.InvalidDataAccessResourceUsageException: Error executing statement Match user-[:HAS_ROLE]-role where user.lastName = 'Lin' return user; nested exception is org.springframework.dao.InvalidDataAccessResourceUsageException: Error executing statement Match user-[:HAS_ROLE]-role where user.lastName = 'Lin' return user; nested exception is expected 'START' "Match user-[:HAS_ROLE]-role where user.lastName = 'Lin' return user" ^
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    [Neo4j] [SDN] [Gremlin] Trying to return relationships from a Gremlin query with SDN

    Google Groups | 5 years ago | Marc de Verdelhan
    org.springframework.dao.InvalidDataAccessResourceUsageException: Error executing statement g.v(project).in('CREATED').outE('PARTICIPATES').filter{it.metaProjectId == g.v(project).objectId}; nested exception is java.lang.RuntimeException: Error executing statement g.v(project).in('CREATED').outE('PARTICIPATES').filter{it.metaProjectId == g.v(project).objectId}
  6. 0

    Spring-Data-Neo4j annotated Cypher Query, match paramter

    Stack Overflow | 2 years ago
    org.springframework.dao.InvalidDataAccessResourceUsageException: Error executing statement START n=node(*) MATCH (n:{0}) RETURN n; nested exception is Invalid input '{': expected whitespace or a label name (line 1, column 26) "START n=node(*) MATCH (n:{0}) RETURN n"

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. org.springframework.dao.InvalidDataAccessResourceUsageException

      Error executing statement start n=node({0}) match (n)-[r]->(inbox) where r.relation in {%strings} return inbox ; nested exception is expected return clause "start n=node({0}) match (n)-[r]->(inbox) where r.relation in {%strings} return inbox " ^

      at org.springframework.data.neo4j.support.query.CypherQueryEngine.parseAndExecuteQuery()
    2. Spring Data Neo4j
      GraphRepositoryQuery.execute
      1. org.springframework.data.neo4j.support.query.CypherQueryEngine.parseAndExecuteQuery(CypherQueryEngine.java:67)
      2. org.springframework.data.neo4j.support.query.CypherQueryEngine.query(CypherQueryEngine.java:53)
      3. org.springframework.data.neo4j.repository.query.GraphRepositoryQuery.dispatchQuery(GraphRepositoryQuery.java:91)
      4. org.springframework.data.neo4j.repository.query.GraphRepositoryQuery.execute(GraphRepositoryQuery.java:70)
      4 frames
    3. Spring Data Core
      RepositoryFactorySupport$QueryExecutorMethodInterceptor.invoke
      1. org.springframework.data.repository.core.support.RepositoryFactorySupport$QueryExecutorMethodInterceptor.invoke(RepositoryFactorySupport.java:302)
      1 frame
    4. Spring AOP
      ReflectiveMethodInvocation.proceed
      1. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
      1 frame
    5. Spring Tx
      TransactionInterceptor.invoke
      1. org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
      1 frame
    6. Spring AOP
      ReflectiveMethodInvocation.proceed
      1. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
      1 frame
    7. Spring Tx
      PersistenceExceptionTranslationInterceptor.invoke
      1. org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:155)
      1 frame
    8. Spring AOP
      JdkDynamicAopProxy.invoke
      1. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
      2. org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
      2 frames
    9. com.sun.proxy
      $Proxy21.getFolderMails
      1. com.sun.proxy.$Proxy21.getFolderMails(Unknown Source)
      1 frame
    10. org.test.spring
      PersonController$$FastClassByCGLIB$$8631769e.invoke
      1. org.test.spring.neo.controller.PersonController.getPersonInBox(PersonController.java:80)
      2. org.test.spring.neo.controller.PersonController$$FastClassByCGLIB$$8631769e.invoke(<generated>)
      2 frames
    11. Spring Core
      MethodProxy.invoke
      1. org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)
      1 frame
    12. Spring AOP
      CglibAopProxy$DynamicAdvisedInterceptor.intercept
      1. org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:698)
      2. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
      3. org.springframework.aop.interceptor.CustomizableTraceInterceptor.invokeUnderTrace(CustomizableTraceInterceptor.java:257)
      4. org.springframework.aop.interceptor.AbstractTraceInterceptor.invoke(AbstractTraceInterceptor.java:111)
      5. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
      6. org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:91)
      7. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
      8. org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:631)
      8 frames
    13. org.test.spring
      PersonController$$EnhancerByCGLIB$$b720895b.getPersonInBox
      1. org.test.spring.neo.controller.PersonController$$EnhancerByCGLIB$$b720895b.getPersonInBox(<generated>)
      1 frame
    14. Java RT
      Method.invoke
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
      3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      4. java.lang.reflect.Method.invoke(Method.java:601)
      4 frames
    15. Spring
      InvocableHandlerMethod.invokeForRequest
      1. org.springframework.web.method.support.InvocableHandlerMethod.invoke(InvocableHandlerMethod.java:219)
      2. org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:132)
      2 frames
    16. Spring MVC
      FrameworkServlet.doGet
      1. org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:104)
      2. org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandleMethod(RequestMappingHandlerAdapter.java:745)
      3. org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:686)
      4. org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:80)
      5. org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:925)
      6. org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:856)
      7. org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:920)
      8. org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:816)
      8 frames
    17. JavaServlet
      HttpServlet.service
      1. javax.servlet.http.HttpServlet.service(HttpServlet.java:621)
      1 frame
    18. Spring MVC
      FrameworkServlet.service
      1. org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:801)
      1 frame
    19. JavaServlet
      HttpServlet.service
      1. javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
      1 frame
    20. Glassfish Core
      CoyoteAdapter.service
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
      3. org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)
      4. org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)
      5. org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)
      6. org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
      7. org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99)
      8. org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:936)
      9. org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
      10. org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407)
      10 frames
    21. Grizzly HTTP
      JIoEndpoint$SocketProcessor.run
      1. org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1004)
      2. org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:589)
      3. org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:310)
      3 frames
    22. Java RT
      Thread.run
      1. java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
      2. java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
      3. java.lang.Thread.run(Thread.java:722)
      3 frames