Project

General

Profile

1 15 jones
/**
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 35 jones
 *   Copyright: 2000 Regents of the University of California and the
6
 *              National Center for Ecological Analysis and Synthesis
7 15 jones
 *     Authors: Matt Jones
8
 *
9
 *     Version: '$Id$'
10
 */
11
12 74 jones
package edu.ucsb.nceas.metacat;
13 51 jones
14 15 jones
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 jones
/**
31
 * A Class that reads in an XML text document and
32
 * write its contents to a database connection using SAX
33
 */
34 15 jones
public class DBSAXWriter {
35
36 72 bojilova
  static  String 	defaultDB = "jdbc:oracle:thin:@penelope.nceas.ucsb.edu:1526:DEV8";
37 15 jones
  private Connection	conn = null;
38
39 31 jones
  /**
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 15 jones
  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 50 jones
          // 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 30 jones
          System.out.println("Document processing finished for: " + filename);
78
79 15 jones
        } 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 31 jones
  /**
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 50 jones
   * @param conn the database connection to which to write the XML file
92 31 jones
   */
93 55 jones
  public DBSAXWriter( Reader xml, Connection conn)
94
                  throws IOException,
95
                         SQLException,
96
                         ClassNotFoundException
97
  {
98
    this.conn = conn;
99
100 72 bojilova
    try {
101 55 jones
        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 72 bojilova
      } catch (Exception e) {
108
        System.err.println(e.toString());
109 55 jones
      }
110
  }
111
112 50 jones
  public DBSAXWriter( String filename, Connection conn)
113 15 jones
                  throws IOException,
114
                         SQLException,
115
                         ClassNotFoundException
116 55 jones
  {
117 50 jones
     this.conn = conn;
118 55 jones
     FileReader xmlfile = new FileReader(new File(filename).toString());
119 15 jones
     try {
120 55 jones
       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 72 bojilova
     } catch (Exception e) {
127
       System.err.println("here is the URL exception");
128
       System.err.println(e.toString());
129 55 jones
     }
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 72 bojilova
      EntityResolver xmlEntityResolver = new DBEntityResolver(conn);
142
      DTDHandler xmlDTDHandler         = new DBDTDHandler(conn);
143 15 jones
144 55 jones
      // For all the other interface use the default provided by
145
      // Handler base
146
      HandlerBase defHandler = new HandlerBase();
147 15 jones
148 55 jones
      // Get an instance of the parser
149
      parser = new SAXParser();
150 15 jones
151 55 jones
      // Set Handlers in the parser
152
      // Set the DocumentHandler to XMLDocumentHandler
153
      parser.setDocumentHandler(xmlDocHandler);
154 72 bojilova
      parser.setEntityResolver(xmlEntityResolver);
155
      parser.setDTDHandler(xmlDTDHandler);
156 15 jones
157 55 jones
      // Set the other Handler to the defHandler
158
      parser.setErrorHandler(defHandler);
159 15 jones
160 55 jones
    } catch (Exception e) {
161
       System.err.println(e.toString());
162
    }
163 15 jones
164 55 jones
    return parser;
165
  }
166 15 jones
167 55 jones
  /** Utility method to convert a file handle into a URL */
168
  static public URL fileToURL(File file)
169
  {
170 16 jones
     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 15 jones
  }
185
}