protected void updateJournalArticleLocalizedFields() throws Exception {
    StringBundler sb = new StringBundler(3);

    sb.append("insert into JournalArticleLocalization(");
    sb.append("articleLocalizationId, companyId, articlePK, title, ");
    sb.append("description, languageId) values(?, ?, ?, ?, ?, ?)");

    try (LoggingTimer loggingTimer = new LoggingTimer();
        PreparedStatement ps1 =
            connection.prepareStatement(
                "select id_, companyId, title, description from " + "JournalArticle");
        PreparedStatement ps2 =
            AutoBatchPreparedStatementUtil.concurrentAutoBatch(connection, sb.toString());
        ResultSet rs = ps1.executeQuery()) {

      while (rs.next()) {
        long articleId = rs.getLong(1);
        long companyId = rs.getLong(2);
        String title = rs.getString(3);
        String description = rs.getString(4);

        Map<Locale, String> titleMap = LocalizationUtil.getLocalizationMap(title);

        Map<Locale, String> descriptionMap = LocalizationUtil.getLocalizationMap(description);

        Set<Locale> localeSet = new HashSet<>();

        localeSet.addAll(titleMap.keySet());
        localeSet.addAll(descriptionMap.keySet());

        for (Locale locale : localeSet) {
          ps2.setLong(1, _increment());
          ps2.setLong(2, companyId);
          ps2.setLong(3, articleId);
          ps2.setString(4, titleMap.get(locale));
          ps2.setString(5, descriptionMap.get(locale));
          ps2.setString(6, LocaleUtil.toLanguageId(locale));

          ps2.addBatch();
        }
      }

      ps2.executeBatch();
    }
  }
  protected void updateJournalArticleDefaultLanguageId() throws Exception {
    try (LoggingTimer loggingTimer = new LoggingTimer();
        PreparedStatement ps1 =
            connection.prepareStatement("select id_, title from JournalArticle");
        PreparedStatement ps2 =
            AutoBatchPreparedStatementUtil.concurrentAutoBatch(
                connection, "update JournalArticle set defaultLanguageId = ? where " + "id_ = ?");
        ResultSet rs = ps1.executeQuery()) {

      Locale defaultLocale = LocaleUtil.getSiteDefault();

      while (rs.next()) {
        String defaultLanguageId =
            LocalizationUtil.getDefaultLanguageId(rs.getString(2), defaultLocale);

        ps2.setString(1, defaultLanguageId);
        ps2.setLong(2, rs.getLong(1));

        ps2.addBatch();
      }

      ps2.executeBatch();
    }
  }