Hi Daniel, seems to depend on the escaping of the quotes but definitely
weird.
It's afaik not related to Cypher but the streaming JSON parser before it. I
think it somehow concludes that it parsed the input correctly but without
any output
e.g. here I get the same as you
curl -XPOST -i -H accept:application/json -H content-type:application/json
-d '{"statements":[{"statement":"LOAD CSV WITH HEADERS F\"xx
file://C:/countries.csvxxx\\" as csvLine MERGE (c:Country { Code:
csvLine.Code })"}]}' http://localhost:7474/db/data/transaction/commit
HTTP/1.1 200 OK
Content-Type: application/json
Access-Control-Allow-Origin: *
Transfer-Encoding: chunked
Server: Jetty(9.0.5.v20130815)
{"results":[],"errors":[]}
and here it fails correctly
curl -XPOST -i -H accept:application/json -H content-type:application/json
-d '{"statements":[{"statement":"LOAD CSV WITH HEADERS FROM \"xx
file://C:/countries.csvxxx\" as csvLine MERGE (c:Country { Code:
csvLine.Code })"}]}' http://localhost:7474/db/data/transaction/commit
HTTP/1.1 200 OK
Content-Type: application/json
Access-Control-Allow-Origin: *
Transfer-Encoding: chunked
Server: Jetty(9.0.5.v20130815)
{"results":[],"errors":[{"code":"Neo.TransientError.Statement.ExternalResourceFailure","message":"Invalid
URL specified (no protocol: xx
file://C:/countries.csvxxx)","stackTrace":"org.neo4j.cypher.LoadExternalResourceException:
Invalid URL specified (no protocol: xx file://C:/countries.csvxxx)\n\tat
org.neo4j.cypher.internal.compiler.v2_1.pipes.LoadCSVPipe.checkURL(LoadCSVPipe.scala:50)\n\tat
org.neo4j.cypher.internal.compiler.v2_1.pipes.LoadCSVPipe$$anonfun$internalCreateResults$1.apply(LoadCSVPipe.scala:66)\n\tat
org.neo4j.cypher.internal.compiler.v2_1.pipes.LoadCSVPipe$$anonfun$internalCreateResults$1.apply(LoadCSVPipe.scala:64)\n\tat
scala.collection.Iterator$$anon$13.hasNext(Iterator.scala:371)\n\tat
scala.collection.Iterator$$anon$13.hasNext(Iterator.scala:371)\n\tat
org.neo4j.cypher.internal.compiler.v2_1.pipes.EmptyResultPipe.internalCreateResults(EmptyResultPipe.scala:29)\n\tat
org.neo4j.cypher.internal.compiler.v2_1.pipes.PipeWithSource.createResults(Pipe.scala:105)\n\tat
org.neo4j.cypher.internal.compiler.v2_1.executionplan.ExecutionPlanBuilder$$anonfun$getExecutionPlanFunction$1$$anonfun$apply$2.apply(ExecutionPlanBuilder.scala:120)\n\tat
org.neo4j.cypher.internal.compiler.v2_1.executionplan.ExecutionPlanBuilder$$anonfun$getExecutionPlanFunction$1$$anonfun$apply$2.apply(ExecutionPlanBuilder.scala:119)\n\tat
org.neo4j.cypher.internal.compiler.v2_1.executionplan.ExecutionWorkflowBuilder.runWithQueryState(ExecutionPlanBuilder.scala:168)\n\tat
org.neo4j.cypher.internal.compiler.v2_1.executionplan.ExecutionPlanBuilder$$anonfun$getExecutionPlanFunction$1.apply(ExecutionPlanBuilder.scala:118)\n\tat
org.neo4j.cypher.internal.compiler.v2_1.executionplan.ExecutionPlanBuilder$$anonfun$getExecutionPlanFunction$1.apply(ExecutionPlanBuilder.scala:103)\n\tat
org.neo4j.cypher.internal.compiler.v2_1.executionplan.ExecutionPlanBuilder$$anon$1.execute(ExecutionPlanBuilder.scala:68)\n\tat
org.neo4j.cypher.internal.compiler.v2_1.executionplan.ExecutionPlanBuilder$$anon$1.execute(ExecutionPlanBuilder.scala:67)\n\tat
org.neo4j.cypher.internal.ExecutionPlanWrapperForV2_1.execute(CypherCompiler.scala:159)\n\tat
org.neo4j.cypher.ExecutionEngine.execute(ExecutionEngine.scala:76)\n\tat
org.neo4j.cypher.ExecutionEngine.execute(ExecutionEngine.scala:71)\n\tat
org.neo4j.cypher.javacompat.ExecutionEngine.execute(ExecutionEngine.java:84)\n\tat
org.neo4j.server.rest.transactional.TransactionHandle.executeStatements(TransactionHandle.java:277)\n\tat
org.neo4j.server.rest.transactional.TransactionHandle.commit(TransactionHandle.java:139)\n\tat
org.neo4j.server.rest.web.TransactionalService$2.write(TransactionalService.java:194)\n\tat
com.sun.jersey.core.impl.provider.entity.StreamingOutputProvider.writeTo(StreamingOutputProvider.java:71)\n\tat
com.sun.jersey.core.impl.provider.entity.StreamingOutputProvider.writeTo(StreamingOutputProvider.java:57)\n\tat
com.sun.jersey.spi.container.ContainerResponse.write(ContainerResponse.java:306)\n\tat
com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1437)\n\tat
com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1349)\n\tat
com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1339)\n\tat
com.sun.jersey.spi.container.servlet.WebComponent.service(WebComponent.java:416)\n\tat
com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:537)\n\tat
com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:699)\n\tat
javax.servlet.http.HttpServlet.service(HttpServlet.java:848)\n\tat
org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:698)\n\tat
org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:505)\n\tat
org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:211)\n\tat
org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1096)\n\tat
org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:432)\n\tat
org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:175)\n\tat
org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1030)\n\tat
org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:136)\n\tat
org.eclipse.jetty.server.handler.HandlerList.handle(HandlerList.java:52)\n\tat
org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:97)\n\tat
org.eclipse.jetty.server.Server.handle(Server.java:445)\n\tat
org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:268)\n\tat
org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:229)\n\tat
org.eclipse.jetty.io.AbstractConnection$ReadCallback.run(AbstractConnection.java:358)\n\tat
org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:601)\n\tat
org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:532)\n\tat
java.lang.Thread.run(Thread.java:744)\n"}]}
On Fri, Sep 19, 2014 at 4:14 PM, Daniel Corbett <daniel...@gmail.com> wrote:
> Continuing to try things... I am now using "Advanced REST Client" - a
> chrome application. I am using the example from the LOAD CSV
> Documentation, along with the REST transaction commit example.
>
> Here is a screen shot, showing my settings for the REST call, along with
> the payload and the result:
>
>
> https://drive.google.com/file/d/0ByBuUHqfY0BSTnFkZmdSYlp4NFU/edit?usp=sharing
>
> Here is a screen shot of me using the same tool & settings with a simple
> Cypher script that works:
>
>
> https://drive.google.com/file/d/0ByBuUHqfY0BSRDNJRWpvUW56UnM/edit?usp=sharing
>
> I've tried so many things... this seems to be a bug.
>
> Help please!
>
> Thanks,
>
> - Daniel
>
> --
> You received this message because you are subscribed to the Google Groups
> "Neo4j" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to neo4j+unsubscr...@googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.
>
--
You received this message because you are subscribed to the Google Groups
"Neo4j" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to neo4j+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
