public void closeDB() { try { if (dao != null && dao.getConnectionSource() != null) { DatabaseConnection conn = dao.getConnectionSource().getReadWriteConnection(); conn.executeStatement("shutdown compact", 0); } } catch (SQLException ex) { Logger.getLogger(TableRecordRepository.class).error("Error closing table_record repository - ", ex); } } }
public void closeDB() { try { if (dao != null && dao.getConnectionSource() != null) { DatabaseConnection conn = dao.getConnectionSource().getReadWriteConnection(); conn.executeStatement("shutdown compact", 0); } } catch (SQLException ex) { Logger.getLogger(UserStatsRepository.class).error("Error closing user_stats repository - ", ex); } } }
public void closeDB() { try { if (dao != null && dao.getConnectionSource() != null) { DatabaseConnection conn = dao.getConnectionSource().getReadWriteConnection(); conn.executeStatement("shutdown compact", 0); } } catch (SQLException ex) { Logger.getLogger(AuthorizedUserRepository.class).error("Error closing authorized_user repository - ", ex); } }
public void closeDB() { try { if (cardDao != null && cardDao.getConnectionSource() != null) { DatabaseConnection conn = cardDao.getConnectionSource().getReadWriteConnection(); conn.executeStatement("shutdown compact", 0); } } catch (SQLException ex) { } }
public DatabaseUpgrader(SQLiteDatabase db, ConnectionSource cs) throws SQLException { mDb = db; mCs = cs; mDc = cs.getReadWriteConnection(); }
@Override public DatabaseConnection startThreadConnection() throws SQLException { DatabaseConnection connection = connectionSource.getReadWriteConnection(tableInfo.getTableName()); connectionSource.saveSpecialConnection(connection); return connection; }
@Override public DatabaseConnection startThreadConnection() throws SQLException { DatabaseConnection connection = connectionSource.getReadWriteConnection(tableInfo.getTableName()); connectionSource.saveSpecialConnection(connection); return connection; }
@Override public DatabaseConnection getReadWriteConnection(String tableName) throws SQLException { DatabaseConnection conn = getSavedConnection(); if (conn == null) { return connectionSource.getReadWriteConnection(tableName); } else { return conn; } }
@Override public DatabaseConnection getReadWriteConnection(String tableName) throws SQLException { DatabaseConnection connection = cs.getReadWriteConnection(tableName); connectionCount.incrementAndGet(); WrappedConnection wrapped = wrapConnection(connection); connection = wrapped.getDatabaseConnectionProxy(); wrappedConnections.put(connection, wrapped); // System.err.println("got wrapped " + wrapped.hashCode() + ", count = " + getReleaseCount); // new RuntimeException().printStackTrace(); return connection; }
@Override public int update(PreparedUpdate<T> preparedUpdate) throws SQLException { checkForInitialized(); DatabaseConnection connection = connectionSource.getReadWriteConnection(tableInfo.getTableName()); try { return statementExecutor.update(connection, preparedUpdate); } finally { connectionSource.releaseConnection(connection); } }
@Override public int update(PreparedUpdate<T> preparedUpdate) throws SQLException { checkForInitialized(); DatabaseConnection connection = connectionSource.getReadWriteConnection(tableInfo.getTableName()); try { return statementExecutor.update(connection, preparedUpdate); } finally { connectionSource.releaseConnection(connection); } }
@Override public int delete(PreparedDelete<T> preparedDelete) throws SQLException { checkForInitialized(); DatabaseConnection connection = connectionSource.getReadWriteConnection(tableInfo.getTableName()); try { return statementExecutor.delete(connection, preparedDelete); } finally { connectionSource.releaseConnection(connection); } }
@Override public int delete(PreparedDelete<T> preparedDelete) throws SQLException { checkForInitialized(); DatabaseConnection connection = connectionSource.getReadWriteConnection(tableInfo.getTableName()); try { return statementExecutor.delete(connection, preparedDelete); } finally { connectionSource.releaseConnection(connection); } }
private static <T, ID> int doDropTable(DatabaseType databaseType, ConnectionSource connectionSource, TableInfo<T, ID> tableInfo, boolean ignoreErrors) throws SQLException { List<String> statements = new ArrayList<String>(); addDropIndexStatements(databaseType, tableInfo, statements, true); addDropTableStatements(databaseType, tableInfo, statements, true); DatabaseConnection connection = connectionSource.getReadWriteConnection(tableInfo.getTableName()); try { return doStatements(connection, "drop", statements, ignoreErrors, databaseType.isCreateTableReturnsNegative(), false); } finally { connectionSource.releaseConnection(connection); } }
@Override public int executeRaw(String statement, String... arguments) throws SQLException { checkForInitialized(); DatabaseConnection connection = connectionSource.getReadWriteConnection(tableInfo.getTableName()); try { return statementExecutor.executeRaw(connection, statement, arguments); } catch (SQLException e) { throw SqlExceptionUtil.create("Could not run raw execute statement " + statement, e); } finally { connectionSource.releaseConnection(connection); } }
@Override public int updateRaw(String statement, String... arguments) throws SQLException { checkForInitialized(); DatabaseConnection connection = connectionSource.getReadWriteConnection(tableInfo.getTableName()); try { return statementExecutor.updateRaw(connection, statement, arguments); } catch (SQLException e) { throw SqlExceptionUtil.create("Could not run raw update statement " + statement, e); } finally { connectionSource.releaseConnection(connection); } }
@Override public int executeRawNoArgs(String statement) throws SQLException { checkForInitialized(); DatabaseConnection connection = connectionSource.getReadWriteConnection(tableInfo.getTableName()); try { return statementExecutor.executeRawNoArgs(connection, statement); } catch (SQLException e) { throw SqlExceptionUtil.create("Could not run raw execute statement " + statement, e); } finally { connectionSource.releaseConnection(connection); } }
@Override public int executeRawNoArgs(String statement) throws SQLException { checkForInitialized(); DatabaseConnection connection = connectionSource.getReadWriteConnection(tableInfo.getTableName()); try { return statementExecutor.executeRawNoArgs(connection, statement); } catch (SQLException e) { throw SqlExceptionUtil.create("Could not run raw execute statement " + statement, e); } finally { connectionSource.releaseConnection(connection); } }
@Override public int executeRaw(String statement, String... arguments) throws SQLException { checkForInitialized(); DatabaseConnection connection = connectionSource.getReadWriteConnection(tableInfo.getTableName()); try { return statementExecutor.executeRaw(connection, statement, arguments); } catch (SQLException e) { throw SqlExceptionUtil.create("Could not run raw execute statement " + statement, e); } finally { connectionSource.releaseConnection(connection); } }
@Override public int updateRaw(String statement, String... arguments) throws SQLException { checkForInitialized(); DatabaseConnection connection = connectionSource.getReadWriteConnection(tableInfo.getTableName()); try { return statementExecutor.updateRaw(connection, statement, arguments); } catch (SQLException e) { throw SqlExceptionUtil.create("Could not run raw update statement " + statement, e); } finally { connectionSource.releaseConnection(connection); } }