コード例 #1
0
ファイル: SocialEvent.java プロジェクト: rshariffdeen/olio
  /**
   * For tags, we won't know the refcount till all the data is loaded. So we update the table at
   * postload.
   */
  public void postLoad() {
    ThreadConnection c = ThreadConnection.getInstance();
    try {
      // update id
      logger.fine("before updating socialEventID");

      c.prepareStatement(
          "INSERT INTO ID_GEN "
              + "(GEN_KEY, GEN_VALUE) "
              + "VALUES ('SOCIAL_EVENT_ID', "
              + ScaleFactors.events
              + 1
              + ")");
      c.executeUpdate();

      /*
      c.prepareStatement("update ID_GEN set GEN_VALUE = " +
             "(select count(*) +1 from SOCIALEVENT) " +
             "where GEN_KEY='SOCIAL_EVENT_ID'");
      c.executeUpdate();
      */
      logger.fine("after updating socialEventID");
    } catch (SQLException e) {
      logger.log(Level.SEVERE, e.getMessage(), e);
      // LoadController.increaseErrorCount();
    }
  }
コード例 #2
0
ファイル: SocialEvent.java プロジェクト: rshariffdeen/olio
 public void load() {
   ThreadConnection c = ThreadConnection.getInstance();
   try {
     PreparedStatement s = c.prepareStatement(STATEMENT);
     for (int i = 0; i < fields.length; i++)
       if (fields[i] != null) s.setString(i + 1, fields[i]);
       else s.setNull(i + 1, Types.VARCHAR);
     s.setDate(10, createdTimestamp);
     for (int i = 0; i < ifields.length; i++) s.setInt(11 + i, ifields[i]);
     c.addBatch();
   } catch (SQLException e) {
     logger.log(Level.SEVERE, e.getMessage(), e);
   }
 }