Project

General

Profile

1
/**
2
 *        Name: DBSAXWriter.java
3
 *     Purpose: A Class that reads in an XML text document and
4
 *              write its contents to a database connection using SAX
5
 *   Copyright: 2000 Regents of the University of California and the
6
 *              National Center for Ecological Analysis and Synthesis
7
 *     Authors: Matt Jones
8
 *
9
 *     Version: '$Id: DBSAXWriter.java 74 2000-05-05 00:37:58Z jones $'
10
 */
11

    
12
package edu.ucsb.nceas.metacat;
13

    
14
import org.xml.sax.*;
15

    
16
import java.io.*;
17
import java.net.URL;
18
import java.net.MalformedURLException;
19
import java.sql.*;
20
import java.util.Stack;
21

    
22
// Extensions to the SAX Interfaces for Namespace support.
23
import oracle.xml.parser.v2.XMLDocumentHandler;
24
import oracle.xml.parser.v2.DefaultXMLDocumentHandler;
25
import oracle.xml.parser.v2.NSName;
26
import oracle.xml.parser.v2.SAXAttrList;
27

    
28
import oracle.xml.parser.v2.SAXParser;
29

    
30
/**
31
 * A Class that reads in an XML text document and
32
 * write its contents to a database connection using SAX
33
 */
34
public class DBSAXWriter {
35

    
36
  static  String 	defaultDB = "jdbc:oracle:thin:@penelope.nceas.ucsb.edu:1526:DEV8";
37
  private Connection	conn = null;
38

    
39
  /**
40
   * the main routine used to test the DBSAXWriter utility.
41
   *
42
   * Usage: java DBSAXWriter <filename> <user> <password> [dbstring]
43
   *
44
   * @param filename the filename to be loaded into the database
45
   * @param user the username to use for the database connection
46
   * @param password the password to use for the database connection
47
   * @param dbstring the connection info to use for the database connection
48
   */
49
  static public void main(String[] args) {
50
     
51
     if (args.length < 3)
52
     {
53
        System.err.println("Wrong number of arguments!!!");
54
        System.err.println("USAGE: java DBSAXWriter " +
55
                           "<filename> <user> <password> [dbstring]");
56
        return;
57
     } else {
58
        try {
59
                    
60
          String filename = args[0];
61
          String user     = args[1];
62
          String password = args[2];
63
          String dbstring = null;
64

    
65
          if (args.length <= 3) {
66
            dbstring = defaultDB;
67
          } else {
68
            dbstring = args[3];
69
          }
70

    
71
          // Open a connection to the database
72
          Connection dbconn = MetaCatUtil.openDBConnection(
73
                "oracle.jdbc.driver.OracleDriver",
74
                dbstring, user, password);
75

    
76
          new DBSAXWriter(filename, dbconn);
77
          System.out.println("Document processing finished for: " + filename);
78

    
79
        } catch (Exception e) {
80
          System.err.println("EXCEPTION HANDLING REQUIRED");
81
          System.err.println(e.getMessage());
82
          e.printStackTrace(System.err);
83
        }
84
     }
85
  }
86
  
87
  /**
88
   * construct a new instance of the class to write an XML file to the database
89
   *
90
   * @param filename the filename to be loaded into the database
91
   * @param conn the database connection to which to write the XML file
92
   */
93
  public DBSAXWriter( Reader xml, Connection conn)
94
                  throws IOException, 
95
                         SQLException, 
96
                         ClassNotFoundException
97
  {
98
    this.conn = conn;
99

    
100
    try {
101
        SAXParser parser = initializeParser(conn);
102
        parser.parse(xml);
103
      } catch (SAXParseException e) {
104
        System.err.println(e.getMessage());
105
      } catch (SAXException e) {
106
        System.err.println(e.getMessage());
107
      } catch (Exception e) {
108
        System.err.println(e.toString());
109
      }
110
  }
111

    
112
  public DBSAXWriter( String filename, Connection conn)
113
                  throws IOException, 
114
                         SQLException, 
115
                         ClassNotFoundException
116
  {
117
     this.conn = conn;
118
     FileReader xmlfile = new FileReader(new File(filename).toString());
119
     try {
120
       SAXParser parser = initializeParser(conn);
121
       parser.parse(xmlfile);
122
     } catch (SAXParseException e) {
123
       System.err.println(e.getMessage());
124
     } catch (SAXException e) {
125
       System.err.println(e.getMessage());
126
     } catch (Exception e) {
127
       System.err.println("here is the URL exception");
128
       System.err.println(e.toString());
129
     }
130
  }
131
  
132
  private SAXParser initializeParser(Connection conn) {
133
    SAXParser parser = null;
134
    //
135
    // Set up the SAX document handlers for parsing
136
    //
137
    try {
138
      // Use the XMLDocumentHandler interface for namespace support
139
      // instead of org.xml.sax.DocumentHandler
140
      XMLDocumentHandler xmlDocHandler = new DBSAXHandler(conn);
141
      EntityResolver xmlEntityResolver = new DBEntityResolver(conn);
142
      DTDHandler xmlDTDHandler         = new DBDTDHandler(conn);
143

    
144
      // For all the other interface use the default provided by
145
      // Handler base
146
      HandlerBase defHandler = new HandlerBase();
147

    
148
      // Get an instance of the parser
149
      parser = new SAXParser();
150

    
151
      // Set Handlers in the parser
152
      // Set the DocumentHandler to XMLDocumentHandler
153
      parser.setDocumentHandler(xmlDocHandler);
154
      parser.setEntityResolver(xmlEntityResolver);
155
      parser.setDTDHandler(xmlDTDHandler);
156

    
157
      // Set the other Handler to the defHandler
158
      parser.setErrorHandler(defHandler);
159

    
160
    } catch (Exception e) {
161
       System.err.println(e.toString());
162
    }
163

    
164
    return parser;
165
  }
166

    
167
  /** Utility method to convert a file handle into a URL */
168
  static public URL fileToURL(File file) 
169
  {
170
     String path = file.getAbsolutePath();
171
     String fSep = System.getProperty("file.separator");
172
     if (fSep != null && fSep.length() == 1)
173
       path = path.replace(fSep.charAt(0), '/');
174
     if (path.length() > 0 && path.charAt(0) != '/')
175
       path = '/' + path;
176
     try {
177
       return new URL("file", null, path);
178
     }
179
     catch (java.net.MalformedURLException e) {
180
       /* According to the spec this could only happen if the file
181
	  protocol were not recognized. */
182
       throw new Error("unexpected MalformedURLException");
183
     }
184
  }
185
}
(10-10/29)