Search code examples
jdbcneo4jcyphersql-workbench-j

Neo4j JDBC driver error "setEscapeProcessing is not supported by Neo4jStatement" in SQL Workbench/J


I want to execute multiple semi-colon delimited Cypher statements in SQL Workbench/J the same way I can run multiple selected SQL statements with the Ctrl+E shortcut.

Here is a small example (modified from the movies dataset):

CREATE (TheMatrix:Movie {title:'The Matrix', released:1999, tagline:'Welcome to the Real World'});
CREATE (Keanu:Person {name:'Keanu Reeves', born:1964});
CREATE (Carrie:Person {name:'Carrie-Anne Moss', born:1967});
CREATE (Laurence:Person {name:'Laurence Fishburne', born:1961});
CREATE (Hugo:Person {name:'Hugo Weaving', born:1960});
CREATE (AndyW:Person {name:'Andy Wachowski', born:1967});
CREATE (LanaW:Person {name:'Lana Wachowski', born:1965});
CREATE (JoelS:Person {name:'Joel Silver', born:1952});
CREATE
  (Keanu)-[:ACTED_IN {roles:['Neo']}]->(TheMatrix),
  (Carrie)-[:ACTED_IN {roles:['Trinity']}]->(TheMatrix),
  (Laurence)-[:ACTED_IN {roles:['Morpheus']}]->(TheMatrix),
  (Hugo)-[:ACTED_IN {roles:['Agent Smith']}]->(TheMatrix),
  (AndyW)-[:DIRECTED]->(TheMatrix),
  (LanaW)-[:DIRECTED]->(TheMatrix),
  (JoelS)-[:PRODUCED]->(TheMatrix);

I get the error "setEscapeProcessing is not supported by Neo4jStatement." How to fix this?

I'm running my local Neo4j instance using Neo4j JDBC driver version 2.3.2.

These are my connection settings.

I'm using Ubuntu 14.04 LTS and Java 1.8.0_72-b15, SQL Workbench/J Build 119 (2016-01-31)


Solution

  • This question has already been answered in the SQL Workbench/J forum

    Yes, you can set the property workbench.db.[dbid].ddl.disable.escapeprocessing to false, e.g. by using the following SQL statement

    WbSetConfig workbench.db.[dbid].ddl.disable.escapeprocessing=false;

    you need to replace [dbid] with the DBID that is generated for Hive. For details on the DBID please see here:

    http://www.sql-workbench.net/manual/settings.html#dbid

    Obviously in this case the DBID for Neo4J must be used, not for Hive (as stated in the forum answer because that question was initially for Hive)