neo4j-java连接
本例使用neo4j3.0.1架包
使用maven下载架包
<!-- https://mvnrepository.com/artifact/org.neo4j/neo4j-jdbc-driver --> <dependency> <groupId>org.neo4j</groupId> <artifactId>neo4j-jdbc-driver</artifactId> <version>3.0.1</version> </dependency> <!-- https://mvnrepository.com/artifact/org.neo4j/neo4j --> <dependency> <groupId>org.neo4j</groupId> <artifactId>neo4j</artifactId> <version>3.0.1</version> </dependency>
在如下设置未开启权限认证时,
# Disable authorization dbms.security.auth_enabled=false
java程序
import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; public class TestNeo4jJdbc { public static void main(String[] args) throws SQLException { Connection con = DriverManager.getConnection("jdbc:neo4j:http://xxxxx:7474", "neo4j", "xxxx"); // Querying try (Statement stmt = con.createStatement()) { ResultSet rs = stmt.executeQuery("MATCH (n) RETURN n"); while (rs.next()) { System.out.println(rs.getString("n")); } } } }
打印
如开启权限认真时,发现上面已经无法访问
提示错误
[Neo.ClientError.Security.AuthorizationFailed]:No authorization header suppl
...
错误分析请看这里:
http://stackoverflow.com/questions/32505398/neo-clienterror-security-authorizationfailed-for-unmanaged-extension
但是看玩还是未解决需要的答案,
另一种解决方案,不使用jdbc原生连接,使用neo4j-ogm-http-driver.jar中的org.neo4j.ogm.config.configuration去间接创建sessionFactory和session
这里我使用的是
neo4j-ogm-http-driver-2.0.3.jar
具体代码
Configuration config = new Configuration(); config.driverConfiguration().setDriverClassName("org.neo4j.ogm.drivers.http.driver.HttpDriver").setURI("http://neo4j:a123456@xxx.xx.xx.xxx:7474"); SessionFactory sessionFactory = new SessionFactory(config, "xxx.model"); Session session = sessionFactory.openSession(); Result result = session.query("MATCH (n) RETURN count(n)",new HashMap<String, String>() ); Iterable<Map<String, Object>> iterator = result.queryResults(); for (Map<String, Object> map : result) { System.out.println(map); }
打印了结果
初次学校使用neo4j问题真不小
知识只有共享才能传播,才能推崇出新的知识,才能学到更多,这里写的每一篇文字/博客,基本都是从网上查询了一下资料然后记录下来,也有些是原滋原味搬了过来,也有时加了一些自己的想法