Revision 72
Added by bojilova about 24 years ago
| DBSAXWriter.java | ||
|---|---|---|
| 9 | 9 |
* Version: '$Id$' |
| 10 | 10 |
*/ |
| 11 | 11 |
|
| 12 |
package edu.ucsb.nceas.metacat; |
|
| 12 |
//package edu.ucsb.nceas.metacat;
|
|
| 13 | 13 |
|
| 14 | 14 |
import org.xml.sax.*; |
| 15 | 15 |
|
| ... | ... | |
| 33 | 33 |
*/ |
| 34 | 34 |
public class DBSAXWriter {
|
| 35 | 35 |
|
| 36 |
static String defaultDB = "jdbc:oracle:thin:@localhost:1521:test";
|
|
| 36 |
static String defaultDB = "jdbc:oracle:thin:@penelope.nceas.ucsb.edu:1526:DEV8";
|
|
| 37 | 37 |
private Connection conn = null; |
| 38 | 38 |
|
| 39 | 39 |
/** |
| ... | ... | |
| 97 | 97 |
{
|
| 98 | 98 |
this.conn = conn; |
| 99 | 99 |
|
| 100 |
//try {
|
|
| 101 |
|
|
| 102 |
try {
|
|
| 100 |
try {
|
|
| 103 | 101 |
SAXParser parser = initializeParser(conn); |
| 104 | 102 |
parser.parse(xml); |
| 105 | 103 |
} catch (SAXParseException e) {
|
| 106 | 104 |
System.err.println(e.getMessage()); |
| 107 | 105 |
} catch (SAXException e) {
|
| 108 | 106 |
System.err.println(e.getMessage()); |
| 107 |
} catch (Exception e) {
|
|
| 108 |
System.err.println(e.toString()); |
|
| 109 | 109 |
} |
| 110 |
//} catch (Exception e) {
|
|
| 111 |
//System.err.println(e.toString()); |
|
| 112 |
//} |
|
| 113 | 110 |
} |
| 114 | 111 |
|
| 115 | 112 |
public DBSAXWriter( String filename, Connection conn) |
| ... | ... | |
| 126 | 123 |
System.err.println(e.getMessage()); |
| 127 | 124 |
} catch (SAXException e) {
|
| 128 | 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 | 129 |
} |
| 130 | 130 |
} |
| 131 | 131 |
|
| ... | ... | |
| 138 | 138 |
// Use the XMLDocumentHandler interface for namespace support |
| 139 | 139 |
// instead of org.xml.sax.DocumentHandler |
| 140 | 140 |
XMLDocumentHandler xmlDocHandler = new DBSAXHandler(conn); |
| 141 |
EntityResolver xmlEntityResolver = new DBEntityResolver(conn); |
|
| 142 |
DTDHandler xmlDTDHandler = new DBDTDHandler(conn); |
|
| 141 | 143 |
|
| 142 | 144 |
// For all the other interface use the default provided by |
| 143 | 145 |
// Handler base |
| ... | ... | |
| 149 | 151 |
// Set Handlers in the parser |
| 150 | 152 |
// Set the DocumentHandler to XMLDocumentHandler |
| 151 | 153 |
parser.setDocumentHandler(xmlDocHandler); |
| 154 |
parser.setEntityResolver(xmlEntityResolver); |
|
| 155 |
parser.setDTDHandler(xmlDTDHandler); |
|
| 152 | 156 |
|
| 153 | 157 |
// Set the other Handler to the defHandler |
| 154 | 158 |
parser.setErrorHandler(defHandler); |
| 155 |
parser.setEntityResolver(defHandler); |
|
| 156 |
parser.setDTDHandler(defHandler); |
|
| 157 | 159 |
|
| 158 | 160 |
} catch (Exception e) {
|
| 159 | 161 |
System.err.println(e.toString()); |
Also available in: Unified diff
Included new features about writing XML documents into db
This includes writing data into db XML Catalog, document data into xml_documents,
comments into xml_nodes, added nodeindex for the order of elements by given parent element.