Try moving the findShortestPathsCypher call inside the try-block that contains the transaction.
-- Chris Vest System Engineer, Neo Technology [ skype: mr.chrisvest, twitter: chvest ] > On 24 Nov 2015, at 08:32, Fry <[email protected]> wrote: > > > Hi All, > > for the code below it works on one system and not another. The differences > are: > Working system: OS X - neo4j-community-2.2.5 > Broken system: Ubuntu - neo4j-communty-2.3.0 > The code in red return returns an exception > "org.neo4j.grapg.db.NotInTransactionException: The statement has been closed." > > Has any one any experience with this of can offer advice/clues? > > Many thanks, John. > > > > Iterator<Path> paths; > > paths = findShortestPathsCypher(db, icString[i], icString[j]); > > try ( Transaction tx = db.beginTx() ) { > > while (paths.hasNext()){ > > Path path = (Path) paths.next(); > > Iterable<Node> nodes = path.nodes(); > > java.util.Iterator<Node> nodeIterator = nodes.iterator(); > > ShortestPath.clear(); > > System.out.println(" "); > > boolean first = true; > > while (nodeIterator.hasNext()){ > > Node n = nodeIterator.next(); > > String nodeName = (String) n.getProperty("title"); > > ShortestPath.add(nodeName); > > if (first) { > > System.out.print("Path: " + nodeName); > > first = false; > > } else > > System.out.print(" ->- " + nodeName); > > } > > AllShortestPaths.add((ArrayList<String>)ShortestPath.clone()); > > } > > } catch (Exception e) { > > System.out.println("Exception on path expansion: " + e.toString()); > > e.printStackTrace(); > > } > > > > > > -- > 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 [email protected] > <mailto:[email protected]>. > For more options, visit https://groups.google.com/d/optout > <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 [email protected]. For more options, visit https://groups.google.com/d/optout.
