Metacat

    <FRAME SRC="contents.html" BORDER=0 NAME="left">

    </FRAMESET>

  </FRAMESET>

  <input type="radio" name="qformat" value="html" checked>HTML

  <br />

  Return:  

  <option value="-//NCEAS//eml-dataset//EN">eml-dataset

  <option value="any">Any

  </select>

  <input type="radio" name="qformat" value="html" checked>HTML

  <br />

  Return:  

  <option value="-//NCEAS//eml-dataset//EN">eml-dataset

  <option value="any">Any

  </select>

Please click 

<a href="http://dev.nceas.ucsb.edu@html-path@/servlet/marine?

returnfield=givenname&returnfield=organizationname">  

 here.</a> if you are not automatically redirected.

    <input type="hidden" name="operator" value="UNION" >

    <input type="hidden" name="returnfield" value="/download/date" >

    <input type="hidden" name="returnfield" value="/download/param" >

    <input type="text" name="anyfield">

    <input type="submit">

  </form>

saxparser=org.apache.xerces.parsers.SAXParser

servletpath=@servlet-path@

htmlpath=@html-path@

accessdoctype=-//NCEAS//eml-access//EN

server=@server@

authclass=edu.ucsb.nceas.metacat.AuthLdap

    <FRAME SRC="queform.html" BORDER=0 NAME="left">

    </FRAMESET>

  </FRAMESET>

<script language="JavaScript">

 window.location="http://@server@@servlet-path@?" +

  "returnfield=resource/dataset/originator/individualName/surName&" +

  "returnfield=resource/dataset/originator/individualName/givenName&" + 

  "returnfield=resource/dataset/originator/organizationName&" +

<noscript>

Please click 

<a href="http://@server@@servlet-path@?

returnfield=resource/dataset/originator/individualName/surName&

returnfield=resource/dataset/originator/individualName/givenName&

returnfield=resource/dataset/originator/organizationName&

Please click 

<a href="http://@server@@servlet-path@??

returnfield=resource/dataset/originator/individualName/surName&

returnfield=resource/dataset/originator/individualName/givenName&

returnfield=resource/dataset/originator/organizationName&

	relationid    INT8 default nextval('xml_relation_id_seq')  PRIMARY KEY, -- unique id

	docid         VARCHAR(250) ,         -- the docid of the package file

	                                      -- that this relation came from

	subject       VARCHAR(512) NOT NULL, -- the subject of the relation

	subdoctype    VARCHAR(128),         	-- the doctype of the subject

	relationship  VARCHAR(128)  NOT NULL,-- the relationship type

INSERT INTO xml_catalog (entry_type, public_id, system_id)

    VALUES ('DTD', '-//NCEAS//resource//EN',

            'http://dev.nceas.ucsb.edu/dtd/schemas/resource.dtd');

CREATE TABLE xml_relation (

	relationid    NUMBER(20) PRIMARY KEY, -- unique id

	                                      -- that this relation came from

	subject       VARCHAR2(512) NOT NULL, -- the subject of the relation

	relationship  VARCHAR2(128)  NOT NULL,-- the relationship type

	object        VARCHAR2(512) NOT NULL, -- the object of the relation

	objdoctype    VARCHAR2(128),          -- the doctype of the object

  // Query data structures

  private String meta_file_id;

  private Vector returnFieldList;

  private Vector ownerList;

  private Vector siteList;

    super();

    // Initialize the class variables

    elementStack = new Stack();

    queryStack   = new Stack();

    returnFieldList = new Vector();

    String currentTag = currentNode.getTagName();

    if (currentTag.equals("meta_file_id")) {

      meta_file_id = inputString;

    } else if (currentTag.equals("value")) {

      currentValue = inputString;

    } else if (currentTag.equals("pathexpr")) {

      currentPathexpr = inputString;

    } else if (currentTag.equals("returndoctype")) {

    } else if (currentTag.equals("returnfield")) {

      returnFieldList.add(inputString);

      containsExtendedSQL = true;

    } else if (currentTag.equals("owner")) {

      ownerList.add(inputString);

    } else if (currentTag.equals("site")) {

    }

  }

  /**

   * create a SQL serialization of the query that this instance represents

   */

    self.append(") ");

    // Add SQL to filter for doctypes requested in the query

      boolean firstdoctype = true;

      self.append(" AND ("); 

      while (en.hasMoreElements()) {

        String currentDoctype = (String)en.nextElement();

        if (firstdoctype) {

      }

      self.append(") ");

    }

    // Add SQL to filter for owners requested in the query

    // This is an implicit OR for the list of owners

    if (!ownerList.isEmpty()) {

    StringBuffer self = new StringBuffer();

    self.append("select subject, relationship, object, subdoctype, ");

    self.append("objdoctype from xml_relation ");

    return self.toString();

  }

    StringBuffer self = new StringBuffer();

    self.append("select z.nodedata, x.nodedata, y.nodedata from ");

    self.append("(select nodeid, parentnodeid from xml_index where path like ");

    self.append("from xml_index where path like ");

    self.append("(select nodeid, parentnodeid from xml_index where path like ");

    self.append("xml_nodes x, xml_nodes y, xml_nodes z ");

    self.append("where s.parentnodeid = rel.parentnodeid ");

    self.append("and rel.parentnodeid = o.parentnodeid ");

    StringBuffer self = new StringBuffer();

    self.append("select z.nodedata, x.nodedata, y.nodedata from ");

    self.append("(select nodeid, parentnodeid from xml_index where path like ");

    self.append("from xml_index where path like ");

    self.append("(select nodeid, parentnodeid from xml_index where path like ");

    self.append("xml_nodes x, xml_nodes y, xml_nodes z ");

    self.append("where s.parentnodeid = rel.parentnodeid ");

    self.append("and rel.parentnodeid = o.parentnodeid ");

    StringBuffer self = new StringBuffer();

    self.append("select z.nodedata, x.nodedata, y.nodedata from ");

    self.append("(select nodeid, parentnodeid from xml_index where path like ");

    self.append("from xml_index where path like ");

    self.append("(select nodeid, parentnodeid from xml_index where path like ");

    self.append("xml_nodes x, xml_nodes y, xml_nodes z ");

    self.append("where s.parentnodeid = rel.parentnodeid ");

    self.append("and rel.parentnodeid = o.parentnodeid ");

          result.append("<resultset>\n"); 

  // following line removed by Dan Higgins to avoid insertion of query XML inside returned XML doc

  //        result.append("  <query>" + xmlfile + "</query>\n"); 

          {

            Enumeration doclist = nodelist.keys();

            while (doclist.hasMoreElements()) {

          }

          //System.out.println(result);

          //write into a file "result.txt"

          {

            File f = new File("./result.txt");

            FileWriter fw = new FileWriter(f);

  public Hashtable findDocuments(Reader xmlquery, String user, String group,

                                 String[] returndoc, boolean useXMLIndex)

  {

      Hashtable   docListResult = new Hashtable();

      PreparedStatement pstmt = null;

      String docid = null;

      String docname = null;

      String doctype = null;

      String createDate = null;

      String updateDate = null;

      String fieldname = null;

      StringBuffer document = null; 

      Vector returndocVec = new Vector();

        for(int i=0; i<returndoc.length; i++)

        {

          returndocVec.add(new String((String)returndoc[i]));

      }

      try {

          dbconn = util.openDBConnection();

          dbconn = conn;

        }

        // Get the XML query and covert it into a SQL statment

        QuerySpecification qspec = new QuerySpecification(xmlquery, 

                                   parserName, 

                                   util.getOption("accNumSeparator"));

        pstmt = dbconn.prepareStatement( qspec.printSQL(useXMLIndex) );

        // Execute the SQL query using the JDBC connection

          }

          docname = rs.getString(2);

          doctype = rs.getString(3);

          createDate = rs.getString(4);

          updateDate = rs.getString(5);

          rev = rs.getInt(6);

            StringBuffer btBuf = new StringBuffer();

            //build the doctype list for the backtracking sql statement

            for(int i=0; i<returndocVec.size(); i++)

            {

              btBuf.append("'").append((String)returndocVec.get(i)).append("'");

              {

                btBuf.append(", ");

              } 

            }

            btBuf.append(") ");

            npstmt.execute();

            ResultSet btrs = npstmt.getResultSet();

            boolean hasBtRows = btrs.next();

            { //there was a backtrackable document found

              DocumentImpl xmldoc = null;

              try

              {

              }

              catch(Exception e)

              {

              docid   = xmldoc.getDocID();

              docname = xmldoc.getDocname();

              doctype = xmldoc.getDoctype();

              createDate = xmldoc.getCreateDate();

              updateDate = xmldoc.getUpdateDate();

            }

            npstmt.close();

            btrs.close();

            String completeDocid = docid + util.getOption("accNumSeparator");

            completeDocid += rev;

            document.append("<docid>").append(completeDocid).append("</docid>");

            if (doctype != null) {

              document.append("<doctype>" + doctype + "</doctype>");

            }

              document.append("<createdate>" + createDate + "</createdate>");

            }

              document.append("<updatedate>" + updateDate + "</updatedate>");

            }

            // Store the document id and the root node id

            docListResult.put(docid,(String)document.toString());

          }

          // Advance to the next record in the cursor

        rs.close();

        //pstmt.close();

        {

          Vector extendedFields = new Vector(qspec.getReturnFieldList());

          Vector results = new Vector();

            document.append("</param>");

            tableHasRows = rs.next();

            {

              String removedelement = (String)docListResult.remove(docid);

              docListResult.put(docid, removedelement + document.toString());

          //String connstring = "metacat://"+util.getOption("server")+"?docid=";

          String connstring = "%docid=";

          String docidkey = (String)docidkeys.nextElement();

          pstmt.close();

          pstmt.execute();

          rs = pstmt.getResultSet();

          tableHasRows = rs.next();

            String subDT = rs.getString(4);

            String objDT = rs.getString(5);

                document = new StringBuffer();

                String removedelement = (String)docListResult.remove(docidkey);

            tableHasRows = rs.next();

          }

          rs.close();

   * to the pathquery.dtd and is appropriate for submission to the DBQuery

   * structured query engine

   *

   */

  public static String createSQuery(Hashtable params)

  { 

    Enumeration elements;

    Enumeration keys;

    String doctype = null;

    String casesensitive = null;

    String searchmode = null;

    Object nextkey;

    Object nextelement;

    //add the xml headers

    query.append("<?xml version=\"1.0\"?>\n");

    {

      query.append( ((String[])params.get("meta_file_id"))[0]);

      query.append("</meta_file_id>");

    }

    {

    }

    else

    {

      doctype = "ANY";  

    }

    {

      String[] returnfield = ((String[])params.get("returnfield"));

      for(int i=0; i<returnfield.length; i++)

      }

    }

    {

      String[] owner = ((String[])params.get("owner"));

      for(int i=0; i<owner.length; i++)

      }

    }

    {

      String[] site = ((String[])params.get("site"));

      for(int i=0; i<site.length; i++)

      }

    }

    if (!doctype.equals("any") && 

        !doctype.equals("ANY") &&

        !doctype.equals("") ) 

       query.append("<returndoctype>");

       query.append(doctype).append("</returndoctype>");

    }

    //allows the dynamic switching of boolean operators

    {

      query.append("<querygroup operator=\"" + 

                ((String[])params.get("operator"))[0] + "\">");

      query.append("<querygroup operator=\"UNION\">"); 

    }

    {

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

    }

      casesensitive = "false"; 

    }

    {

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

    }

    //free text search.  It does not have a <pathexpr>

    //tag.  This allows for a free text search within the structured

    //query.  This is useful if the INTERSECT operator is used.

    {

       String[] anyfield = ((String[])params.get("anyfield"));

       //allow for more than one value for anyfield

       for(int i=0; i<anyfield.length; i++)

       {

         {

           query.append("<queryterm casesensitive=\"" + casesensitive + 

                        "\" " + "searchmode=\"" + searchmode + "\"><value>" +

      //make sure we aren't querying for any of these

      //parameters since the are already in the query

      //in one form or another.

         !nextkey.toString().equals("action")  &&

         !nextkey.toString().equals("qformat") && 

         !nextkey.toString().equals("anyfield") &&

        //allow for more than value per field name

        for(int i=0; i<((String[])nextelement).length; i++)

        {

          {

            query.append("<queryterm casesensitive=\"" + casesensitive +"\" " + 

                         "searchmode=\"" + searchmode + "\">" +

     StringBuffer xmlquery = new StringBuffer();

     xmlquery.append("<?xml version=\"1.0\"?>\n");

     xmlquery.append("<pathquery version=\"1.0\">");

     if (!doctype.equals("any") && !doctype.equals("ANY")) {

       xmlquery.append("<returndoctype>");

     //chad added - 8/14

     //the if statement allows a query to gracefully handle a null 

     //query.  Without this if a nullpointerException is thrown.

     {

       xmlquery.append("<queryterm casesensitive=\"false\" ");

       xmlquery.append("searchmode=\"contains\">");

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

    String resultdoc = null;

    String[] returndoc = null;

    {

    }

    Hashtable doclist = runQuery(xmlquery, user, group, returndoc);

  {

    //create the query and run it

    String[] returndoc = null;

    {

    }

    String xmlquery = DBQuery.createSQuery(params);

    Hashtable doclist = runQuery(xmlquery, user, group, returndoc);

    }

    catch(Exception e)

    {

                         "relationhandler: " + e.getMessage());

    }

    this.xmldoc = xmldoc;

   */ 

  public void run()

  {

    Connection dbconn = null;

    String docid = xmldoc.getDocID();

    // deletes all of the relations with a docid of @docid.

    deleteRelations(docid);

    //pseudo-code algorithm

    {

      dbconn = MetacatReplication.getDBConnection("RelationHandler." +

                                                  "run");

      PreparedStatement pstmt = dbconn.prepareStatement(

                                QuerySpecification.printPackageSQL(docid));

      pstmt.execute();

      while(hasmorerows)

      {

        String subject = rs.getString(1);

        String subjectDoctype = null;

        String paramDocid = null;

        URL subjectMurl = null;

        //get the current relations information

        String subDocid = null;

        String objDocid = null;

            subDocid = (String)subMurlParams.get("docid");

            if(subMurl.getProtocol().equals("metacat"))

            {

              subDoctype = subDoc.getDoctype();

            }

          }

        //now that the comparisons are done, the new relation can be put

        //into xml_relation

        StringBuffer insertStmt = new StringBuffer();

        insertStmt.append("relationship, object, objdoctype) values ('");

        insertStmt.append(docid).append("', '");

        insertStmt.append(subject).append("', '");

        insertStmt.append(subDoctype).append("', '");

        insertStmt.append(relationship).append("', '");

    } 

    catch(Exception e) 

    { 

      btThread = null;

      try 

      { 

    }

    catch(Exception ee)

    {

                          ee.getMessage());

    }

    }

    catch(Exception e)

    {

                          e.getMessage());

      try 

      { 

        dbconn.rollback();

      } 

      catch (SQLException sqle) {}

    }

  }

}

	relationid    NUMBER(20) PRIMARY KEY, -- unique id

	docid         VARCHAR2(250) ,         -- the docid of the package file

	                                      -- that this relation came from

	subject       VARCHAR2(512) NOT NULL, -- the subject of the relation

	subdoctype    VARCHAR2(128),         	-- the doctype of the subject

	relationship  VARCHAR2(128)  NOT NULL,-- the relationship type

# Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA

PARSER=/usr/local/devtools/xerces-1_1_3/xerces.jar

JDBC=${ORACLE_HOME}/jdbc/lib/classes111.zip

export CPATH=$PDIR/build/metacat.jar:$PARSER:$JDBC

# Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA

PARSER=/usr/local/devtools/xerces-1_1_3/xerces.jar

JDBC=${ORACLE_HOME}/jdbc/lib/classes111.zip

export CPATH=$PDIR/build/metacat.jar:$PARSER:$JDBC

# Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA

PARSER=/usr/local/devtools/xerces-1_1_3/xerces.jar

JDBC=${ORACLE_HOME}/jdbc/lib/classes111.zip

export CPATH=$PDIR/build/metacat.jar:$PARSER:$JDBC

# Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA

PARSER=/usr/local/devtools/xerces-1_1_3/xerces.jar

JDBC=${ORACLE_HOME}/jdbc/lib/classes111.zip

export CPATH=$PDIR/build/metacat.jar:$PARSER:$JDBC

# Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA

PARSER=/usr/local/devtools/xerces-1_1_3/xerces.jar

JDBC=${ORACLE_HOME}/jdbc/lib/classes111.zip

export CPATH=$PDIR/build/metacat.jar:$PARSER:$JDBC

# Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA

PARSER=/usr/local/devtools/xerces-1_1_3/xerces.jar

JDBC=${ORACLE_HOME}/jdbc/lib/classes111.zip

export CPATH=$PDIR/build/metacat.jar:$PARSER:$JDBC