Hi,
i want to use sql query too load the data from neo4j using bi connector.for that i'm using driver(neo4j-jdbc-driver-3.1.0).i am able to get the data for cipher query but not for sql query.
While running below exception is coming.please guide me so that i can achieve it.
"java.sql.SQLException: Some errors occurred :
[Neo.ClientError.Statement.SyntaxError]:Invalid input 'l': expected 't/T' (line 1, column 3 (offset: 2))"
my code:
public static void main(String[] args) {
JDBCTest test = new JDBCTest();
try {
Connection con = test.connectViaDMa();
String cypherQuery ="select * from person";
Statement stmt = (Statement) con.createStatement();
ResultSet rs = stmt.executeQuery(cypherQuery);
while (rs.next()) {
System.out.println(rs.getString("person"));
}
} catch (Exception e) {
e.printStackTrace();
}
}
private static Connection connectViaDMa() throws Exception {
Connection connection = null;
String CONNECTION_URL = "jdbc:neo4j:http://localhost:7474/neo4j";
Driver driver = new Driver();
DriverManager.registerDriver(driver);
connection = DriverManager.getConnection(CONNECTION_URL);
System.out.println(connection.toString());
return connection;
}
please let me know what i'm missing for this.
i am using neo database version About Neo4j Desktop
Version: 1.3.4
