/ - Diff - Metacat - Ecoinformatics Redmine

          * @param conn the JDBC Connection to which all information is written
          * @param rootnodeid - sequence id of the root node in the document
          * @param docname - the name of DTD, i.e. the name immediately following
          *        the DOCTYPE keyword - should be the root element name.
          *        the DOCTYPE keyword ( should be the root element name ) or
          *        the root element name if no DOCTYPE declaration provided
          *        (Oracle's and IBM parsers are not aware if it is not the
          *        root element name)
          * @param doctype - Public ID of the DTD, i.e. the name immediately
          *                  following the PUBLIC keyword in DOCTYPE declaration.
          *                  following the PUBLIC keyword in DOCTYPE declaration or
          *                  the docname if no Public ID provided or
          *                  null if no DOCTYPE declaration provided
+         *
          */
         public DBSAXDocument (Connection conn, long rootnodeid, String docname,
-...
         /** creates SQL code and inserts new document into DB connection */
         private void writeDocumentToDB() {
             try {
               conn.setAutoCommit(false);
               PreparedStatement pstmt;
               pstmt = conn.prepareStatement(
                     "INSERT INTO xml_documents " +
-...
+              }
               stmt.close();
               conn.commit();
               conn.setAutoCommit(true);
             } catch (SQLException e) {
               System.out.println(e.getMessage());
+            }

                          (new URL(systemId)).openConnection();
                 urlConn.connect();
             } catch (java.io.IOException e) {
                 System.out.println("IOException: " + e.getMessage());
                 System.out.println(e.getMessage());
                 return;
+            }
             try {
               conn.setAutoCommit(false);
               PreparedStatement pstmt;
               pstmt = conn.prepareStatement(
                     "INSERT INTO xml_catalog " +
-...
               // Do the insertion
               pstmt.execute();
               pstmt.close();
               conn.commit();
               conn.setAutoCommit(true);
             } catch (SQLException e) {
               System.out.println(e.getMessage());
+            }
-...
         * Look at db XML Catalog to get System ID (if any) for that Public ID
         * and doctype. Return empty string if there are not
         */
     /*
        private String getEntitySystemID (Connection conn, String doctype,
                                          String publicId)
+       {
-...
             // return the selected System ID number
             return system_id;
+       }
     */
        /**
         * Register Public ID in db XML Catalog
         */
     /*
        private void registerEntityPublicID (Connection conn, String doctype,
                                             String publicId, String systemId)
+       {
             try {
               conn.setAutoCommit(false);
               PreparedStatement pstmt;
               pstmt = conn.prepareStatement(
                     "INSERT INTO xml_catalog (catalog_id, entry_type, " +
-...
               // Do the insertion
               pstmt.execute();
               pstmt.close();
               conn.commit();
               conn.setAutoCommit(true);
             } catch (SQLException e) {
               System.out.println(e.getMessage());
+            }
+       }
     */
+    }

                                             String publicId, String systemId)
+       {
             try {
               conn.setAutoCommit(false);
               PreparedStatement pstmt;
               pstmt = conn.prepareStatement(
                     "INSERT INTO xml_catalog (entity_id, entity_name, " +
-...
               // Do the insertion
               pstmt.execute();
               pstmt.close();
               conn.commit();
               conn.setAutoCommit(true);
             } catch (SQLException e) {
               System.out.println(e.getMessage());
+            }

         try {
             SAXParser parser = initializeParser(conn);
             conn.setAutoCommit(false);
             parser.parse(xml);
             conn.commit();
             conn.setAutoCommit(true);
           } catch (SAXParseException e) {
             System.err.println(e.getMessage());
           } catch (SAXException e) {
-...
          FileReader xmlfile = new FileReader(new File(filename).toString());
          try {
            SAXParser parser = initializeParser(conn);
            conn.setAutoCommit(false);
            parser.parse(xmlfile);
            conn.commit();
            conn.setAutoCommit(true);
          } catch (SAXParseException e) {
            System.err.println(e.getMessage());
          } catch (SAXException e) {
            System.err.println(e.getMessage());
          } catch (Exception e) {
            System.err.println(e.toString());
            System.err.println("from DBWriter:" + e.toString());
+         }
+      }

Project

General

Profile

Metacat

Revision 148

Added by bojilova over 24 years ago