orientdb-jdbc
文件大小: unknow
源码售价: 5 个金币 积分规则     积分充值
资源说明:OrientDB JDBC Driver
*Project MOVED*

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
mvn install
*How to build a jar-with-dependencies* Do a
mvn assembly:assembly
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.

本源码包内暂不包含可直接显示的源代码文件,请下载源码包。