DBSaxHandler


1   /*
2     Copyright (C) 2003  Know Gate S.L. All rights reserved.
3                         C/O�a, 107 1�2 28050 Madrid (Spain)
4   
5     Redistribution and use in source and binary forms, with or without
6     modification, are permitted provided that the following conditions
7     are met:
8   
9     1. Redistributions of source code must retain the above copyright
10       notice, this list of conditions and the following disclaimer.
11  
12    2. The end-user documentation included with the redistribution,
13       if any, must include the following acknowledgment:
14       "This product includes software parts from hipergate
15       (http://www.hipergate.org/)."
16       Alternately, this acknowledgment may appear in the software itself,
17       if and wherever such third-party acknowledgments normally appear.
18  
19    3. The name hipergate must not be used to endorse or promote products
20       derived from this software without prior written permission.
21       Products derived from this software may not be called hipergate,
22       nor may hipergate appear in their name, without prior written
23       permission.
24  
25    This library is distributed in the hope that it will be useful,
26    but WITHOUT ANY WARRANTY; without even the implied warranty of
27    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.
28  
29    You should have received a copy of hipergate License with this code;
30    if not, visit http://www.hipergate.org or mail to info@hipergate.org
31  */
32  
33  package com.knowgate.dataobjs;
34  
35  import java.io.FileNotFoundException  ;
36  
37  import java.util.LinkedList  ;
38  import java.util.ListIterator  ;
39  import java.io.IOException  ;
40  
41  import java.sql.SQLException  ;
42  
43  import java.lang.ClassNotFoundException  ;
44  
45  import org.xml.sax.Attributes  ;
46  import org.xml.sax.Parser  ;
47  import org.xml.sax.SAXException  ;
48  import org.xml.sax.SAXNotRecognizedException  ;
49  import org.xml.sax.SAXNotSupportedException  ;
50  import org.xml.sax.SAXParseException  ;
51  import org.xml.sax.XMLReader  ;
52  import org.xml.sax.helpers.XMLReaderFactory  ;
53  import org.xml.sax.helpers.DefaultHandler  ;
54  import org.xml.sax.helpers.ParserAdapter  ;
55  import org.xml.sax.helpers.ParserFactory  ;
56  
57  import com.knowgate.debug.DebugFile;
58  import com.knowgate.jdc.JDCConnection;
59  
60  /**
61   * <p>SAX Parser Event Handler for loading XML formated data into a DBPersist object.</p>
62   * @author Sergio Montoro Ten
63   * @version 1.0
64   */
65  
66  public class DBSaxHandler extends DefaultHandler   {
67  
68    /**
69     * Construct and set reference to DBPersist object that will hold the loaded data.
70     * @deprecated Use DBSaxHandler(DBPersist oPersist, JDCConnection) instead
71     */
72  
73      public DBSaxHandler(DBPersist oPersist) {
74          oTarget = oPersist;
75          oTable = oPersist.getTable();
76          oColList = oTable.getColumns();
77          oColIter = oColList.listIterator();
78      }
79  
80      public DBSaxHandler(DBPersist oPersist, JDCConnection oConn)
81        throws SQLException   {
82          oTarget = oPersist;
83          oTable = oPersist.getTable(oConn);
84          oColList = oTable.getColumns();
85          oColIter = oColList.listIterator();
86      }
87  
88      // Data
89  
90      /** Number of elements. */
91      protected long fElements;
92      /** Number of characters. */
93      protected long fCharacters;
94  
95      protected LinkedList   oColList;
96      protected ListIterator   oColIter;
97      protected DBColumn oColumn;
98      protected DBTable oTable;
99      protected DBPersist oTarget;
100 
101     // -------------------------------------------------------------------------
102 
103     // **********************
104     // ContentHandler methods
105     //
106 
107     /**
108      * Start document.
109      */
110     public void startDocument() throws SAXException   {
111 
112         fElements            = 0;
113         fCharacters          = 0;
114     } // startDocument()
115 
116     // -------------------------------------------------------------------------
117 
118     /**
119      * Start element.
120      */
121 
122     public void startElement(String   uri, String   local, String   raw,
123                              Attributes   attrs) throws SAXException   {
124         fElements++;
125 
126         if (null==oColumn) {
127           oColumn = oTable.getColumnByName(local);
128         }
129 
130     } // startElement(String,String,StringAttributes)
131 
132     // -------------------------------------------------------------------------
133 
134     /**
135      * Characters.
136      */
137 
138     public void characters(char ch[], int start, int length)
139         throws SAXException   {
140 
141         fCharacters += length;
142 
143         if (null!=oColumn) {
144 
145           if (DebugFile.trace)
146             DebugFile.writeln("DBSaxHendler.characters() parsing " + new String  (ch,start,length) +  " into " + oColumn.getName() + " as type " +  oColumn.getSqlTypeName() );
147 
148           try {
149             oTarget.put(oColumn.getName(), new String  (ch,start,length), oColumn.getSqlType());
150           }
151           catch (FileNotFoundException   fnfe) { /* never thrown */ }
152 
153         oColumn = null;
154         } // fi (oColumn)
155     } // characters(char[],int,int);
156 
157     // -------------------------------------------------------------------------
158 
159     // ********************
160     // ErrorHandler methods
161     //
162 
163     /**
164      * Warning.
165      */
166     public void warning(SAXParseException   ex) throws SAXException   {
167         if (DebugFile.trace) DebugFile.write(composeError("Warning", ex));
168     } // warning(SAXParseException)
169 
170     /**
171      * Error.
172      */
173     public void error(SAXParseException   ex) throws SAXException   {
174         if (DebugFile.trace) DebugFile.write(composeError("Error", ex));
175         throw ex;
176     } // error(SAXParseException)
177 
178     /**
179      * Fatal error.
180      * */
181     public void fatalError(SAXParseException   ex) throws SAXException   {
182       if (DebugFile.trace) DebugFile.write(composeError("Fatal Error", ex));
183       throw ex;
184     } // fatalError(SAXParseException)
185 
186     // -------------------------------------------------------------------------
187 
188     // *****************
189     // Protected methods
190     //
191 
192     /**
193      * Compose the error message.
194      */
195     protected String   composeError(String   type, SAXParseException   ex) {
196         String   sErrDesc = "";
197         String   systemId = null;
198         int index;
199 
200         sErrDesc += "[SAX " + type + "] ";
201 
202         if (ex==null)
203           sErrDesc += "!!!";
204         else
205           systemId = ex.getSystemId();
206 
207         if (systemId != null) {
208             index = systemId.lastIndexOf('/');
209             if (index != -1) systemId = systemId.substring(index + 1);
210             sErrDesc += systemId;
211         }
212 
213         sErrDesc += " Line:" + ex.getLineNumber();
214         sErrDesc += " Column:" + ex.getColumnNumber();
215         sErrDesc += " Cause: " + ex.getMessage();
216         sErrDesc += "\n";
217 
218         return sErrDesc;
219     } // composeError(String,SAXParseException)
220 
221     // -------------------------------------------------------------------------
222 
223     // **************
224     // Public methods
225     //
226 
227     /**
228      * Parses an XML document into a DBPersist instace
229      */
230 
231     public void parse(String   sXMLSource)
232         throws InstantiationException  ,IllegalAccessException  ,ClassNotFoundException  ,IOException  ,SAXException   {
233 
234         // local variables
235         XMLReader   parser;
236         Parser   sax1Parser;
237         long time, timeBefore=0, timeAfter=0, memory, memoryBefore=0, memoryAfter=0;
238 
239         if (DebugFile.trace) {
240           timeBefore = System.currentTimeMillis();
241           memoryBefore = Runtime.getRuntime().freeMemory();
242         }
243 
244         try {
245           if (DebugFile.trace)
246             DebugFile.writeln("XMLReaderFactory.createXMLReader(DEFAULT_PARSER_NAME)");
247 
248           parser = XMLReaderFactory.createXMLReader(DEFAULT_PARSER_NAME);
249         }
250         catch (Exception   e) {
251             sax1Parser = ParserFactory.makeParser(DEFAULT_PARSER_NAME);
252             parser = new ParserAdapter  (sax1Parser);
253             if (DebugFile.trace)
254               DebugFile.writeln("warning: Features and properties not supported on SAX1 parsers.");
255         }
256 
257       // parse file
258       parser.setContentHandler(this);
259       parser.setErrorHandler(this);
260 
261       if (DebugFile.trace)
262         DebugFile.writeln("XMLReader.parse(" + sXMLSource + ")");
263 
264       parser.parse(sXMLSource);
265 
266       if (DebugFile.trace) {
267         memoryAfter = Runtime.getRuntime().freeMemory();
268         timeAfter = System.currentTimeMillis();
269 
270         time = timeAfter - timeBefore;
271         memory = memoryBefore - memoryAfter;
272       }
273     } // parse
274 
275     // -------------------------------------------------------------------------
276 
277     // feature ids
278 
279     protected static final String   NAMESPACES_FEATURE_ID = "http://xml.org/sax/features/namespaces";
280     protected static final String   NAMESPACE_PREFIXES_FEATURE_ID = "http://xml.org/sax/features/namespace-prefixes";
281     protected static final String   VALIDATION_FEATURE_ID = "http://xml.org/sax/features/validation";
282     protected static final String   SCHEMA_VALIDATION_FEATURE_ID = "http://apache.org/xml/features/validation/schema";
283     protected static final String   SCHEMA_FULL_CHECKING_FEATURE_ID = "http://apache.org/xml/features/validation/schema-full-checking";
284     protected static final String   DYNAMIC_VALIDATION_FEATURE_ID = "http://apache.org/xml/features/validation/dynamic";
285 
286     // default settings
287 
288     protected static final String   DEFAULT_PARSER_NAME = "org.apache.xerces.parsers.SAXParser";
289     protected static final int DEFAULT_REPETITION = 1;
290     protected static final boolean DEFAULT_NAMESPACES = true;
291     protected static final boolean DEFAULT_NAMESPACE_PREFIXES = false;
292     protected static final boolean DEFAULT_VALIDATION = false;
293     protected static final boolean DEFAULT_SCHEMA_VALIDATION = false;
294     protected static final boolean DEFAULT_SCHEMA_FULL_CHECKING = false;
295     protected static final boolean DEFAULT_DYNAMIC_VALIDATION = false;
296     protected static final boolean DEFAULT_MEMORY_USAGE = false;
297     protected static final boolean DEFAULT_TAGGINESS = false;
298 }
A to Z: JavaDoc & Examples Daily Java News & Articles Open Source Projects Open Source Codes Free Computer Books Remove Frame
Free Books Free Magazines
Popular Tags