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 (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(TableRecordRepository.class).error("Error closing table_record 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) { } }
@Override public int executeStatement(String statementStr, int resultFlags) throws SQLException { if (proxy == null) { return 0; } else { return proxy.executeStatement(statementStr, resultFlags); } }
@Override public int executeStatement(String statementStr, int resultFlags) throws SQLException { if (proxy == null) { return 0; } else { return proxy.executeStatement(statementStr, resultFlags); } }
DatabaseConnection con = null; con = conSrc.getReadWriteConnection(); con.executeStatement("attach database '" + localDatabase.getAbsolutePath() + "' as '" + localDb + "'", DatabaseConnection.DEFAULT_RESULT_FLAGS); con.executeStatement("attach database '" + downloadedDatabase.getAbsolutePath() + "' as '" + remoteDb + "'", DatabaseConnection.DEFAULT_RESULT_FLAGS);
private int execute(String statement) throws SQLException { return mDc.executeStatement(statement, DatabaseConnection.DEFAULT_RESULT_FLAGS); }
/** * Return true if it worked else false. */ public int executeRawNoArgs(DatabaseConnection connection, String statement) throws SQLException { logger.debug("running raw execute statement: {}", statement); return connection.executeStatement(statement, DatabaseConnection.DEFAULT_RESULT_FLAGS); }
/** * Return true if it worked else false. */ public int executeRawNoArgs(DatabaseConnection connection, String statement) throws SQLException { logger.debug("running raw execute statement: {}", statement); return connection.executeStatement(statement, DatabaseConnection.DEFAULT_RESULT_FLAGS); }
@Test public void testExecuteStatement() throws Exception { DatabaseConnection conn = createMock(DatabaseConnection.class); String statement = "select foo from bar"; int result = 1312321; expect(conn.executeStatement(statement, 0)).andReturn(result); conn.close(); DatabaseConnectionProxy proxy = new DatabaseConnectionProxy(conn); replay(conn); assertEquals(result, proxy.executeStatement(statement, 0)); proxy.close(); verify(conn); }