OrientDB JDBC driver has been moved to OrientDB core modules: https://github.com/orientechnologies/orientdb/tree/develop/jdbc
OrientDB JDBC Driver
OrientDB (http://code.google.com/p/orient/) is a NoSql DBMS that support a subset of SQL ad query languge.
This project is an effort to develop a JDBC driver for OrientDB
Include in your projects
Orient-jdbc are deployed on sonatype’s maven repository. At the moment only snapshots are available, so
com.orientechnologies orientdb-jdbc 1.0-SNAPSHOT
How to build
Orient-jdbc uses maven, so do a
How to build a jar-with-dependencies
to obtain a jar with dependency included under target directory.
Just copy orientdb-jdbc-1.0-SNAPSHOT-all.jar to your classpath.
It is very usefull to include under applications such as DBVisualizer.
How can be used in my code?
The driver is registerd to the Java sql DriverManager and can be used to work with all the OrientDB database types: memory, local or remote.
The driver’s class is com.orientechnologies.orient.jdbc.OrientJdbcDriver.
Use your knowledge of JDBC API to work against OrientDB.
First get a connection
Properties info = new Properties(); info.put("user", "admin"); info.put("password", "admin"); Connection conn = (OrientJdbcConnection) DriverManager.getConnection("jdbc:orient:remote:localhost/test", info);
Then execute a Statement and get the ResultSet
Statement stmt = conn.createStatement(); ResultSet rs = stmt.executeQuery("SELECT stringKey, intKey, text, length, date FROM Item"); rs.next(); rs.getInt("@version"); rs.getString("@class"); rs.getString("@rid"); rs.getString("stringKey"); rs.getInt("intKey"); rs.close(); stmt.close();
The driver retrieve Orient metadata (
rid,class and @version) only on direct queries.
Take a look at tests code to see more detailed examples.