DatabaseConnection conn = dao.startThreadConnection(); Savepoint savePoint = null; try { savePoint = conn.setSavePoint(null); doInserts(dao); } finally { // commit at the end conn.commit(savePoint); dao.endThreadConnection(conn); }
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 void close() throws Exception { try { if (autoCommitAtStart) { connection.setAutoCommit(true); } } finally { connectionSource.clearSpecialConnection(connection); connectionSource.releaseConnection(connection); } } }
@Override public String[] mapRow(DatabaseResults results) throws SQLException { int columnN = results.getColumnCount(); String[] result = new String[columnN]; for (int colC = 0; colC < columnN; colC++) { result[colC] = results.getString(colC); } return result; }
@Override public int executeStatement(String statementStr, int resultFlags) throws SQLException { if (proxy == null) { return 0; } else { return proxy.executeStatement(statementStr, resultFlags); } }
@Override public void close() throws IOException { if (proxy != null) { proxy.close(); } }
@Override public void commit(Savepoint savePoint) throws SQLException { if (proxy != null) { proxy.commit(savePoint); } }
@Override public Object resultToSqlArg(FieldType fieldType, DatabaseResults results, int columnPos) throws SQLException { return results.getString(columnPos); } @Override
@Override public void rollback(Savepoint savePoint) throws SQLException { if (proxy != null) { proxy.rollback(savePoint); } }
@Override public int insert(String statement, Object[] args, FieldType[] argfieldTypes, GeneratedKeyHolder keyHolder) throws SQLException { if (proxy == null) { return 0; } else { return proxy.insert(statement, args, argfieldTypes, keyHolder); } }
private String[] getColumnNames(DatabaseResults results) throws SQLException { if (columnNames != null) { return columnNames; } columnNames = results.getColumnNames(); return columnNames; } }
@Override public int update(String statement, Object[] args, FieldType[] argfieldTypes) throws SQLException { if (proxy == null) { return 0; } else { return proxy.update(statement, args, argfieldTypes); } }
@Override public boolean isTableExists(String tableName) throws SQLException { if (proxy == null) { return false; } else { return proxy.isTableExists(tableName); } } }
private void assignStatementArguments(CompiledStatement compiledStatement, String[] arguments) throws SQLException { for (int i = 0; i < arguments.length; i++) { compiledStatement.setObject(i, arguments[i], SqlType.STRING); } }
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); } } }
@Override public String[] mapRow(DatabaseResults results) throws SQLException { int columnN = results.getColumnCount(); String[] result = new String[columnN]; for (int colC = 0; colC < columnN; colC++) { result[colC] = results.getString(colC); } return result; }
@Override public void close() throws IOException { if (connection != null) { connection.close(); connection = null; } }
private String[] getColumnNames(DatabaseResults results) throws SQLException { if (columnNames != null) { return columnNames; } columnNames = results.getColumnNames(); return columnNames; } }
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); } } }