Metacat

    /** look up the assigned doc id from DB connection */

      long doc_id=0;

      Statement stmt;

      try {

        stmt = conn.createStatement();

        stmt.execute("SELECT xml_documents_id_seq.currval FROM dual");

        ResultSet rs = stmt.getResultSet();

        boolean tableHasRows = rs.next();

        if (tableHasRows) {

          doc_id = rs.getLong(1);

        }

        stmt.close();

      } catch (SQLException e) {

        System.out.println("Error getting id: " + e.getMessage());

      }

      // assign the new ID number

      return doc_id;