Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $
You can buy this project and download/modify it how often you want.
org.sqlite.jdbc3.JDBC3Connection Maven / Gradle / Ivy
package org.sqlite.jdbc3;
import java.sql.CallableStatement;
import java.sql.DatabaseMetaData;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.SQLWarning;
import java.sql.Savepoint;
import java.sql.Statement;
import java.sql.Struct;
import java.util.Map;
import java.util.Properties;
import java.util.concurrent.atomic.AtomicInteger;
import org.sqlite.SQLiteOpenMode;
import org.sqlite.core.CoreConnection;
public abstract class JDBC3Connection extends CoreConnection {
private final AtomicInteger savePoint = new AtomicInteger(0);
protected JDBC3Connection(String url, String fileName, Properties prop) throws SQLException {
super(url, fileName, prop);
}
/**
* @see java.sql.Connection#getCatalog()
*/
public String getCatalog() throws SQLException {
checkOpen();
return null;
}
/**
* @see java.sql.Connection#setCatalog(java.lang.String)
*/
public void setCatalog(String catalog) throws SQLException {
checkOpen();
}
/**
* @see java.sql.Connection#getHoldability()
*/
public int getHoldability() throws SQLException {
checkOpen();
return ResultSet.CLOSE_CURSORS_AT_COMMIT;
}
/**
* @see java.sql.Connection#setHoldability(int)
*/
public void setHoldability(int h) throws SQLException {
checkOpen();
if (h != ResultSet.CLOSE_CURSORS_AT_COMMIT)
throw new SQLException("SQLite only supports CLOSE_CURSORS_AT_COMMIT");
}
/**
* @see java.sql.Connection#getTransactionIsolation()
*/
public int getTransactionIsolation() {
return transactionIsolation;
}
/**
* @see java.sql.Connection#setTransactionIsolation(int)
*/
public void setTransactionIsolation(int level) throws SQLException {
checkOpen();
switch (level) {
case java.sql.Connection.TRANSACTION_SERIALIZABLE:
db.exec("PRAGMA read_uncommitted = false;");
break;
case java.sql.Connection.TRANSACTION_READ_UNCOMMITTED:
db.exec("PRAGMA read_uncommitted = true;");
break;
default:
throw new SQLException("SQLite supports only TRANSACTION_SERIALIZABLE and TRANSACTION_READ_UNCOMMITTED.");
}
transactionIsolation = level;
}
/**
* @see java.sql.Connection#getTypeMap()
*/
public Map> getTypeMap() throws SQLException {
throw new SQLException("not yet implemented");
}
/**
* @see java.sql.Connection#setTypeMap(java.util.Map)
*/
@SuppressWarnings("rawtypes")
public void setTypeMap(Map map) throws SQLException {
throw new SQLException("not yet implemented");
}
/**
* @see java.sql.Connection#isReadOnly()
*/
public boolean isReadOnly() throws SQLException {
return (openModeFlags & SQLiteOpenMode.READONLY.flag) != 0;
}
/**
* @see java.sql.Connection#setReadOnly(boolean)
*/
public void setReadOnly(boolean ro) throws SQLException {
// trying to change read-only flag
if (ro != isReadOnly()) {
throw new SQLException(
"Cannot change read-only flag after establishing a connection." +
" Use SQLiteConfig#setReadOnly and SQLiteConfig.createConnection().");
}
}
public abstract DatabaseMetaData getMetaData() throws SQLException;
/**
* @see java.sql.Connection#nativeSQL(java.lang.String)
*/
public String nativeSQL(String sql) {
return sql;
}
/**
* @see java.sql.Connection#clearWarnings()
*/
public void clearWarnings() throws SQLException {}
/**
* @see java.sql.Connection#getWarnings()
*/
public SQLWarning getWarnings() throws SQLException {
return null;
}
/**
* @see java.sql.Connection#getAutoCommit()
*/
public boolean getAutoCommit() throws SQLException {
checkOpen();
return autoCommit;
}
/**
* @see java.sql.Connection#setAutoCommit(boolean)
*/
public void setAutoCommit(boolean ac) throws SQLException {
checkOpen();
if (autoCommit == ac)
return;
autoCommit = ac;
db.exec(autoCommit ? "commit;" : beginCommandMap.get(transactionMode));
}
/**
* @see java.sql.Connection#commit()
*/
public void commit() throws SQLException {
checkOpen();
if (autoCommit)
throw new SQLException("database in auto-commit mode");
db.exec("commit;");
db.exec(beginCommandMap.get(transactionMode));
}
/**
* @see java.sql.Connection#rollback()
*/
public void rollback() throws SQLException {
checkOpen();
if (autoCommit)
throw new SQLException("database in auto-commit mode");
db.exec("rollback;");
db.exec(beginCommandMap.get(transactionMode));
}
/**
* @see java.sql.Connection#createStatement()
*/
public Statement createStatement() throws SQLException {
return createStatement(ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_READ_ONLY,
ResultSet.CLOSE_CURSORS_AT_COMMIT);
}
/**
* @see java.sql.Connection#createStatement(int, int)
*/
public Statement createStatement(int rsType, int rsConcurr) throws SQLException {
return createStatement(rsType, rsConcurr, ResultSet.CLOSE_CURSORS_AT_COMMIT);
}
/**
* @see java.sql.Connection#createStatement(int, int, int)
*/
public abstract Statement createStatement(int rst, int rsc, int rsh) throws SQLException;
/**
* @see java.sql.Connection#prepareCall(java.lang.String)
*/
public CallableStatement prepareCall(String sql) throws SQLException {
return prepareCall(sql, ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_READ_ONLY,
ResultSet.CLOSE_CURSORS_AT_COMMIT);
}
/**
* @see java.sql.Connection#prepareCall(java.lang.String, int, int)
*/
public CallableStatement prepareCall(String sql, int rst, int rsc) throws SQLException {
return prepareCall(sql, rst, rsc, ResultSet.CLOSE_CURSORS_AT_COMMIT);
}
/**
* @see java.sql.Connection#prepareCall(java.lang.String, int, int, int)
*/
public CallableStatement prepareCall(String sql, int rst, int rsc, int rsh) throws SQLException {
throw new SQLException("SQLite does not support Stored Procedures");
}
/**
* @see java.sql.Connection#prepareStatement(java.lang.String)
*/
public PreparedStatement prepareStatement(String sql) throws SQLException {
return prepareStatement(sql, ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_READ_ONLY);
}
/**
* @see java.sql.Connection#prepareStatement(java.lang.String, int)
*/
public PreparedStatement prepareStatement(String sql, int autoC) throws SQLException {
return prepareStatement(sql);
}
/**
* @see java.sql.Connection#prepareStatement(java.lang.String, int[])
*/
public PreparedStatement prepareStatement(String sql, int[] colInds) throws SQLException {
return prepareStatement(sql);
}
/**
* @see java.sql.Connection#prepareStatement(java.lang.String, java.lang.String[])
*/
public PreparedStatement prepareStatement(String sql, String[] colNames) throws SQLException {
return prepareStatement(sql);
}
/**
* @see java.sql.Connection#prepareStatement(java.lang.String, int, int)
*/
public PreparedStatement prepareStatement(String sql, int rst, int rsc) throws SQLException {
return prepareStatement(sql, rst, rsc, ResultSet.CLOSE_CURSORS_AT_COMMIT);
}
/**
* @see java.sql.Connection#prepareStatement(java.lang.String, int, int, int)
*/
public abstract PreparedStatement prepareStatement(String sql, int rst, int rsc, int rsh) throws SQLException;
/**
* @see java.sql.Connection#setSavepoint()
*/
public Savepoint setSavepoint() throws SQLException {
checkOpen();
if (autoCommit)
// when a SAVEPOINT is the outermost savepoint and not
// with a BEGIN...COMMIT then the behavior is the same
// as BEGIN DEFERRED TRANSACTION
// http://www.sqlite.org/lang_savepoint.html
autoCommit = false;
Savepoint sp = new JDBC3Savepoint(savePoint.incrementAndGet());
db.exec(String.format("SAVEPOINT %s", sp.getSavepointName()));
return sp;
}
/**
* @see java.sql.Connection#setSavepoint(java.lang.String)
*/
public Savepoint setSavepoint(String name) throws SQLException {
checkOpen();
if (autoCommit)
// when a SAVEPOINT is the outermost savepoint and not
// with a BEGIN...COMMIT then the behavior is the same
// as BEGIN DEFERRED TRANSACTION
// http://www.sqlite.org/lang_savepoint.html
autoCommit = false;
Savepoint sp = new JDBC3Savepoint(savePoint.incrementAndGet(), name);
db.exec(String.format("SAVEPOINT %s", sp.getSavepointName()));
return sp;
}
/**
* @see java.sql.Connection#releaseSavepoint(java.sql.Savepoint)
*/
public void releaseSavepoint(Savepoint savepoint) throws SQLException {
checkOpen();
if (autoCommit)
throw new SQLException("database in auto-commit mode");
db.exec(String.format("RELEASE SAVEPOINT %s", savepoint.getSavepointName()));
}
/**
* @see java.sql.Connection#rollback(java.sql.Savepoint)
*/
public void rollback(Savepoint savepoint) throws SQLException {
checkOpen();
if (autoCommit)
throw new SQLException("database in auto-commit mode");
db.exec(String.format("ROLLBACK TO SAVEPOINT %s", savepoint.getSavepointName()));
}
// UNUSED FUNCTIONS /////////////////////////////////////////////
public Struct createStruct(String t, Object[] attr) throws SQLException {
throw new SQLException("unsupported by SQLite");
}
}
