Esempio n. 1
0
  private void execute(
      boolean script, boolean export, Writer fileOutput, Statement statement, final String sql)
      throws IOException, SQLException {
    final SqlExceptionHelper sqlExceptionHelper = new SqlExceptionHelper();

    String formatted = formatter.format(sql);
    if (delimiter != null) formatted += delimiter;
    if (script) System.out.println(formatted);
    LOG.debug(formatted);
    if (outputFile != null) {
      fileOutput.write(formatted + "\n");
    }
    if (export) {

      statement.executeUpdate(sql);
      try {
        SQLWarning warnings = statement.getWarnings();
        if (warnings != null) {
          sqlExceptionHelper.logAndClearWarnings(connectionHelper.getConnection());
        }
      } catch (SQLException sqle) {
        LOG.unableToLogSqlWarnings(sqle);
      }
    }
  }
Esempio n. 2
0
 @Override
 public void export(String string) throws Exception {
   statement.executeUpdate(string);
   try {
     SQLWarning warnings = statement.getWarnings();
     if (warnings != null) {
       sqlExceptionHelper.logAndClearWarnings(connection);
     }
   } catch (SQLException e) {
     LOG.unableToLogSqlWarnings(e);
   }
 }