Metacat

import java.text.*;

      //update the last_update field for each server to the current date/time      

      SimpleDateFormat formatter = new SimpleDateFormat ("yy-MM-dd HH:mm:ss");

      java.util.Date newDate = new java.util.Date(System.currentTimeMillis());

      ParsePosition pos = new ParsePosition(0);

      String dateString = formatter.format(newDate);

      //System.out.println("dateString: " + dateString);

      StringBuffer sql = new StringBuffer();

      sql.append("update xml_replication set last_checked = to_date('");

      sql.append(dateString).append("', 'YY-MM-DD HH24:MI:SS')");

      System.out.println("sql: " + sql.toString());

      pstmt = conn.prepareStatement(sql.toString());

      pstmt.executeUpdate();

      //conn.commit();

      System.out.println("last_checked updated: " + dateString);