1.

How can we connect Neo4j JDBC driver with DbVisualizer?

Answer»

We can try by doing the following steps:-

  • Step 1:-Download & install the DbVisualizer.
  • Step 2:-Now in the Driver Manager add the JDBC driver jar as a Neo4j driver.
  • Step 3:- Then add a connection to the database.
  • Step 4:- Now Under the "Connection properties" change the "SQL Statements" as written below:

              SELECT ALL: START n=node(0) match (n)-[:TYPE]->(type)<-[:IS_A]-(instance) return *

              SELECT COUNT: start n=node(0) match (n)-[:TYPE]->(type)<-[:IS_A]-(instance)return count(instance).

Now user can be able to browse the type nodes as the tables & the nodes of those types as the rows. Now user can USE the "SQL Commander" to for issuing an arbitrary Cypher query to the Neo4j SERVER.


Discussion

No Comment Found

Related InterviewSolutions