com.orientechnologies.orient.jdbc.OrientJdbcConnection Maven / Gradle / Ivy
Show all versions of orientdb-jdbc Show documentation
/**
* Copyright 2010-2016 OrientDB LTD (http://orientdb.com)
*
* Licensed under the Apache License, Version 2.0 (the "License"); you may not use this file
* except in compliance with the License. You may obtain a copy of the License at
*
*
http://www.apache.org/licenses/LICENSE-2.0
*
*
Unless required by applicable law or agreed to in writing, software distributed under the
* License is distributed on an "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either
* express or implied. See the License for the specific language governing permissions and
* limitations under the License.
*
*
For more information: http://orientdb.com
*/
package com.orientechnologies.orient.jdbc;
import com.orientechnologies.orient.core.config.OGlobalConfiguration;
import com.orientechnologies.orient.core.db.ODatabaseDocumentInternal;
import com.orientechnologies.orient.core.db.ODatabaseSession;
import com.orientechnologies.orient.core.db.ODatabaseType;
import com.orientechnologies.orient.core.db.OrientDB;
import com.orientechnologies.orient.core.db.OrientDBConfig;
import com.orientechnologies.orient.core.db.document.ODatabaseDocument;
import com.orientechnologies.orient.core.util.OURLConnection;
import com.orientechnologies.orient.core.util.OURLHelper;
import java.sql.Array;
import java.sql.Blob;
import java.sql.CallableStatement;
import java.sql.Clob;
import java.sql.Connection;
import java.sql.DatabaseMetaData;
import java.sql.NClob;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLClientInfoException;
import java.sql.SQLException;
import java.sql.SQLFeatureNotSupportedException;
import java.sql.SQLWarning;
import java.sql.SQLXML;
import java.sql.Savepoint;
import java.sql.Statement;
import java.sql.Struct;
import java.util.Map;
import java.util.Properties;
import java.util.concurrent.Executor;
/**
* @author Roberto Franchini (CELI Srl - [email protected])
* @author Salvatore Piccione (TXT e-solutions SpA - [email protected])
*/
public class OrientJdbcConnection implements Connection {
private ODatabaseDocument database;
private String dbUrl;
private Properties info;
private OrientDB orientDB;
private boolean readOnly;
private boolean autoCommit;
private ODatabaseSession.STATUS status;
private boolean orientDBisPrivate;
public OrientJdbcConnection(final String jdbcdDUrl, final Properties info) {
this.dbUrl = jdbcdDUrl.replace("jdbc:orient:", "");
this.info = info;
readOnly = false;
final String username = info.getProperty("user", "admin");
final String password = info.getProperty("password", "admin");
final String serverUsername = info.getProperty("serverUser", "");
final String serverPassword = info.getProperty("serverPassword", "");
OURLConnection connUrl = OURLHelper.parseNew(dbUrl);
orientDB =
new OrientDB(
connUrl.getType() + ":" + connUrl.getPath(),
serverUsername,
serverPassword,
OrientDBConfig.defaultConfig());
if (!serverUsername.isEmpty() && !serverPassword.isEmpty()) {
orientDB.execute(
"create database ? "
+ connUrl.getDbType().orElse(ODatabaseType.MEMORY)
+ " if not exists users (? identified by ? role admin)",
connUrl.getDbName(),
username,
password);
}
database = orientDB.open(connUrl.getDbName(), username, password);
orientDBisPrivate = true;
status = ODatabaseSession.STATUS.OPEN;
}
public OrientJdbcConnection(ODatabaseDocument database, OrientDB orientDB, Properties info) {
this.database = database;
this.orientDB = orientDB;
this.info = info;
orientDBisPrivate = false;
status = ODatabaseSession.STATUS.OPEN;
}
protected OrientDB getOrientDB() {
return orientDB;
}
public Statement createStatement() throws SQLException {
return new OrientJdbcStatement(this);
}
public PreparedStatement prepareStatement(String sql) throws SQLException {
return new OrientJdbcPreparedStatement(this, sql);
}
public CallableStatement prepareCall(String sql) throws SQLException {
throw new SQLFeatureNotSupportedException();
}
public String nativeSQL(String sql) throws SQLException {
throw new SQLFeatureNotSupportedException();
}
public void clearWarnings() throws SQLException {}
public T unwrap(Class iface) throws SQLException {
throw new SQLFeatureNotSupportedException();
}
public boolean isWrapperFor(Class iface) throws SQLException {
throw new SQLFeatureNotSupportedException();
}
public String getUrl() {
return dbUrl;
}
public void close() throws SQLException {
status = ODatabaseSession.STATUS.CLOSED;
if (database != null) {
database.activateOnCurrentThread();
database.close();
database = null;
}
if (orientDBisPrivate) {
orientDB.close();
}
}
public void commit() throws SQLException {
database.commit();
}
public void rollback() throws SQLException {
database.rollback();
}
public boolean isClosed() throws SQLException {
return status == ODatabaseSession.STATUS.CLOSED;
}
public boolean isReadOnly() throws SQLException {
return readOnly;
}
public void setReadOnly(boolean iReadOnly) throws SQLException {
readOnly = iReadOnly;
}
public boolean isValid(int timeout) throws SQLException {
return true;
}
public Array createArrayOf(String typeName, Object[] elements) throws SQLException {
return null;
}
public Blob createBlob() throws SQLException {
return null;
}
public Clob createClob() throws SQLException {
return null;
}
public NClob createNClob() throws SQLException {
return null;
}
public SQLXML createSQLXML() throws SQLException {
return null;
}
public Statement createStatement(int resultSetType, int resultSetConcurrency)
throws SQLException {
return new OrientJdbcStatement(this);
}
public Statement createStatement(
int resultSetType, int resultSetConcurrency, int resultSetHoldability) throws SQLException {
return new OrientJdbcStatement(this);
}
public Struct createStruct(String typeName, Object[] attributes) throws SQLException {
return null;
}
public boolean getAutoCommit() throws SQLException {
return autoCommit;
}
public void setAutoCommit(boolean autoCommit) throws SQLException {
this.autoCommit = autoCommit;
}
public String getCatalog() throws SQLException {
return database.getName();
}
public void setCatalog(String catalog) throws SQLException {}
public Properties getClientInfo() throws SQLException {
return null;
}
public void setClientInfo(Properties properties) throws SQLClientInfoException {
// noop
}
public String getClientInfo(String name) throws SQLException {
return null;
}
public int getHoldability() throws SQLException {
return ResultSet.CLOSE_CURSORS_AT_COMMIT;
}
public void setHoldability(int holdability) throws SQLException {}
public DatabaseMetaData getMetaData() throws SQLException {
return new OrientJdbcDatabaseMetaData(this, (ODatabaseDocumentInternal) getDatabase());
}
public int getTransactionIsolation() throws SQLException {
return Connection.TRANSACTION_SERIALIZABLE;
}
public void setTransactionIsolation(int level) throws SQLException {}
public Map> getTypeMap() throws SQLException {
return null;
}
public void setTypeMap(Map> map) throws SQLException {}
public SQLWarning getWarnings() throws SQLException {
return null;
}
public CallableStatement prepareCall(String sql, int resultSetType, int resultSetConcurrency)
throws SQLException {
throw new SQLFeatureNotSupportedException();
}
public CallableStatement prepareCall(
String sql, int resultSetType, int resultSetConcurrency, int resultSetHoldability)
throws SQLException {
throw new SQLFeatureNotSupportedException();
}
public PreparedStatement prepareStatement(String sql, int autoGeneratedKeys) throws SQLException {
return new OrientJdbcPreparedStatement(this, sql);
}
public PreparedStatement prepareStatement(String sql, int[] columnIndexes) throws SQLException {
return new OrientJdbcPreparedStatement(this, sql);
}
public PreparedStatement prepareStatement(String sql, String[] columnNames) throws SQLException {
return new OrientJdbcPreparedStatement(this, sql);
}
public PreparedStatement prepareStatement(String sql, int resultSetType, int resultSetConcurrency)
throws SQLException {
return new OrientJdbcPreparedStatement(this, resultSetType, resultSetConcurrency, sql);
}
public PreparedStatement prepareStatement(
String sql, int resultSetType, int resultSetConcurrency, int resultSetHoldability)
throws SQLException {
return new OrientJdbcPreparedStatement(
this, resultSetType, resultSetConcurrency, resultSetHoldability, sql);
}
public void releaseSavepoint(Savepoint savepoint) throws SQLException {
throw new SQLFeatureNotSupportedException();
}
public void rollback(Savepoint savepoint) throws SQLException {
throw new SQLFeatureNotSupportedException();
}
public void setClientInfo(String name, String value) throws SQLClientInfoException {
// noop
}
public Savepoint setSavepoint() throws SQLException {
return null;
}
public Savepoint setSavepoint(String name) throws SQLException {
return null;
}
public ODatabaseDocument getDatabase() {
return database;
}
public void abort(Executor arg0) throws SQLException {}
public int getNetworkTimeout() throws SQLException {
return OGlobalConfiguration.NETWORK_SOCKET_TIMEOUT.getValueAsInteger();
}
/** No schema is supported. */
public String getSchema() throws SQLException {
return null;
}
public void setSchema(String arg0) throws SQLException {}
public void setNetworkTimeout(Executor arg0, int arg1) throws SQLException {
OGlobalConfiguration.NETWORK_SOCKET_TIMEOUT.setValue(arg1);
}
public Properties getInfo() {
return info;
}
}