private void enableReferentialIntegrity(Connection connection) throws SQLException { String sql = enableReferentialIntegritySql(); execute(connection, sql); }
private void enableReferentialIntegrity(Connection connection) throws SQLException { String sql = enableReferentialIntegritySql(); execute(connection, sql); }
private void disableReferentialIntegrity(Connection connection) throws SQLException { String sql = disableReferentialIntegritySql(); execute(connection, sql); }
private void disableReferentialIntegrity(Connection connection) throws SQLException { String sql = disableReferentialIntegritySql(); execute(connection, sql); }
private void enableReferentialIntegrity(Connection connection) throws SQLException { String sql = enableReferentialIntegritySql(); execute(connection, sql); }
private void disableReferentialIntegrity(Connection connection) throws SQLException { String sql = disableReferentialIntegritySql(); execute(connection, sql); }
private void restoreSqlList(ConnectionProvider connectionProvider, Iterable<String> sqlList) { Connection connection = null; String currentSql = null; try { connection = connectionProvider.get(); connection.setAutoCommit(false); disableReferentialIntegrity(connection); for (String sql : sqlList) { currentSql = sql; execute(connection, sql); } enableReferentialIntegrity(connection); connection.commit(); } catch (SQLException e) { throw new SQLRuntimeException(currentSql, e); } finally { Jdbc.close(connection); } }
private void restoreSqlList(ConnectionProvider connectionProvider, Iterable<String> sqlList) { Connection connection = null; String currentSql = null; try { connection = connectionProvider.get(); connection.setAutoCommit(false); disableReferentialIntegrity(connection); for (String sql : sqlList) { currentSql = sql; execute(connection, sql); } enableReferentialIntegrity(connection); connection.commit(); } catch (SQLException e) { throw new SQLRuntimeException(currentSql, e); } finally { Jdbc.close(connection); } }
private void restoreSqlList(ConnectionProvider connectionProvider, Iterable<String> sqlList) { Connection connection = null; String currentSql = null; try { connection = connectionProvider.get(); connection.setAutoCommit(false); disableReferentialIntegrity(connection); for (String sql : sqlList) { currentSql = sql; execute(connection, sql); } enableReferentialIntegrity(connection); connection.commit(); } catch (SQLException e) { throw new SQLRuntimeException(currentSql, e); } finally { Jdbc.close(connection); } }