Metacat

    } else if (action.equals("getlastdocid")) {

      PrintWriter out = response.getWriter();

      handleGetLastDocidAction(out, params, response);  

  /** 

   * Handle the "getlastdocid" action.

   * Get the latest docid with rev number from db connection in XML format

   */

  private void handleGetLastDocidAction(PrintWriter out, Hashtable params, 

                                        HttpServletResponse response) {

    Connection conn = null;

    String username = ((String[])params.get("username"))[0];

    try {

        // get connection from the pool

        conn = util.getConnection();

        DBUtil dbutil = new DBUtil(conn);

        String lastDocid = dbutil.getLastDocid(username);

        out.println("<?xml version=\"1.0\"?>");

        out.println("<lastDocid>");

        out.println("  <username>" + username + "</username>");

        out.println("  <docid>" + lastDocid + "</docid>");

        out.println("</lastDocid>");

    } catch (Exception e) {

      out.println("<?xml version=\"1.0\"?>");

      out.println("<error>");

      out.println(e.getMessage());

      out.println("</error>");

    } finally {

      util.returnConnection(conn);

    }  

  }

        "USAGE: java DBUtil <-dt | -ds [doctype] | -dg [doctype] | -dl user>");

          } else if ( args[0].equals("-dl") ) {

            String username = "";

            if ( args.length == 2 ) { username = args[1]; }

            String docid = dbutil.getLastDocid(username);

            System.out.println(docid);

  /**

   * get the lastest Accession Number used by user

   */

  public String getLastDocid(String user)

        throws SQLException  {

    String accnum = null;

    String sep = MetaCatUtil.getOption("accNumSeparator");

    try {

      PreparedStatement pstmt =

        conn.prepareStatement("SELECT docid, rev, date_updated " +

                              "FROM xml_documents " +

                              "WHERE user_owner = ? " +

                              "AND date_updated = (SELECT MAX(date_updated) " +

                                                   "FROM xml_documents " +

                                                   "WHERE user_owner = ?) " +

                              "UNION " + 

                              "SELECT docid, rev, date_updated " +

                              "FROM xml_revisions " +

                              "WHERE user_owner = ? " +

                              "AND date_updated = (SELECT MAX(date_updated) " +

                                                   "FROM xml_revisions " +

                                                   "WHERE user_owner = ?) " +

                              "ORDER BY date_updated");

      pstmt.setString(1,user);

      pstmt.setString(2,user);

      pstmt.setString(3,user);

      pstmt.setString(4,user);

      pstmt.execute();

      ResultSet rs = pstmt.getResultSet();

      boolean tableHasRows = rs.next(); //0, 1 or 2 possible num of rows

      // get the last one which is the latest accnum

      while (tableHasRows) {

        accnum = rs.getString(1) + sep + rs.getString(2);

        tableHasRows = rs.next();

      }

      pstmt.close();

    } catch (SQLException e) {

      throw new SQLException("DBUtil.readLastDocid(). " + e.getMessage());

    }

    return accnum;

  }