Project

General

Profile

Revision 177

Added by Matt Jones over 20 years ago

finsihed basic functionality for structured queries based on the DBQuery and QuerySpecification classes

View differences:

src/xmltables.sql
102 102
 */
103 103
CREATE TABLE xml_index (
104 104
	nodeid		NUMBER(20),	-- the unique node id
105
	path		VARCHAR2(20),	-- precomputed path through tree
105
	path		VARCHAR2(200),	-- precomputed path through tree
106 106
   CONSTRAINT xml_index_pk PRIMARY KEY (nodeid,path),
107 107
   CONSTRAINT xml_nodes_fk FOREIGN KEY (nodeid) REFERENCES xml_nodes
108 108
);
109 109

  
110 110
/* 
111
 * Index of the paths in xml_index 
112
 */
113
CREATE INDEX xml_index_idx1 ON xml_index (path);
114

  
115
/* 
111 116
 * table to store unique Accession # for every document in 2 parts
112 117
 */
113 118
CREATE TABLE xml_acc_numbers (
src/edu/ucsb/nceas/metacat/DBSAXNode.java
101 101
      pstmt.execute();
102 102
      pstmt.close();
103 103
      
104
      // Record the node id that was generated fromthe database
105
      setNodeID(nid);
104
      if (nodetype.equals("DOCUMENT") || nodetype.equals("ELEMENT")) {
106 105

  
107
      // Record the node type that was passed in via the constructor
108
      setNodeType(nodetype);
106
        // Record the node id that was generated from the database
107
        setNodeID(nid);
109 108

  
109
        // Record the node type that was passed to the method
110
        setNodeType(nodetype);
111

  
112
      }
113

  
110 114
    } catch (SQLException e) {
111 115
      System.err.println("Error inserting node: (" + nodetype + ", " +
112 116
                                                     nodename + ", " + 
src/edu/ucsb/nceas/metacat/DBWriter.java
104 104
        conn.commit();
105 105
        conn.setAutoCommit(true);
106 106
      } catch (SAXParseException e) {
107
        conn.rollback();
107 108
        System.err.println(e.getMessage());
108 109
      } catch (SAXException e) {
110
        conn.rollback();
109 111
        System.err.println(e.getMessage());
110 112
      } catch (Exception e) {
113
        conn.rollback();
111 114
        System.err.println(e.toString());
112 115
      }
113 116
  }

Also available in: Unified diff