Re: XML JDOM

Hi all,

 I have some problem in one of my xml file which value "&" in it.

 I am using JDOM API to extract xml data to database below is code:
 the error line is in SAXBuilder builder = new SAXBuilder(); code.

 Any one have any suggestion or ideas how to solve it ?

Thanks

  protected int process(HttpServletRequest request,
HttpServletResponse response) {
        int dispatchState = 0;
        try {
            // Build the document with SAX and Xerces, no validation
            SAXBuilder builder = new SAXBuilder();
            File file = new File(xmlDir);
            File [] files = file.listFiles();

            // list of files in directory
            Map <String,ModelBean>model_map = new
HashMap<String,ModelBean>();
            Map <String,String>orig_series_map = new
HashMap<String,String>();
            Map <String,String>orig_category_map = new
HashMap<String,String>();

            XmlAction xmlAction = ActionManager.getXmlAction();

            for(int i=0;i<files.length;i++){

                String filename = files[i].getAbsolutePath();
                logger.log(this.getClass().getName(), "XmlServlet
process() filename" ,filename);

                // Create the document
                Document doc = builder.build(new File(filename));
                Element root_element = doc.getRootElement();
                // Get a List of all direct children as Element
objects

                // content data

                List allroot_attributes =
root_element.getAttributes();
                Attribute attribute = root_element.getAttribute("id");
                String content_id = attribute.getValue();
                attribute = root_element.getAttribute("revision");
                int revision = attribute.getIntValue();
                attribute = root_element.getAttribute("lang");
                String lang = attribute.getValue();
                attribute = root_element.getAttribute("type");
                String type = attribute.getValue();
                attribute = root_element.getAttribute("ts-type");
                String ts_type = attribute.getValue();
                String xmlfile = files[i].getName();
                logger.log(this.getClass().getName(), "XmlServlet
process() ts_type" ,ts_type);
                logger.log(this.getClass().getName(), "XmlServlet
process() xmlfile" ,xmlfile);
                String title = "";

                if(ts_type.equalsIgnoreCase("Type-A"))
                 title = root_element.getChild("main-
text").getChild("content-title").getText();
                if(ts_type.equalsIgnoreCase("Type-B"))
                 title = root_element.getChild("main-
text").getChild("content-title").getText();
                if(ts_type.equalsIgnoreCase("Type-C"))
                 title = root_element.getChild("main-
text").getChild("content-title").getText();
                if(ts_type.equalsIgnoreCase("Type-D"))
                 title = root_element.getChild("download-
page").getChild("content-title").getText();

                logger.log(this.getClass().getName(), "XmlServlet
process() title" ,title);

                boolean in_queue =
xmlAction.getContentInQueue(content_id,revision,lang);
                logger.log(this.getClass().getName(), "XmlServlet
process() in_queue" ,String.valueOf(in_queue));

                if(!in_queue){
                    logger.log(this.getClass().getName(), "XmlServlet
process() content_id" ,content_id);
                    logger.log(this.getClass().getName(), "XmlServlet
process() revision" , String.valueOf(revision));
                    logger.log(this.getClass().getName(), "XmlServlet
process() lang" , lang);
                    // add new content

xmlAction.addNewContent(content_id,revision,lang,ts_type,xmlfile,title);
                    // add new content reference

xmlAction.addNewContentReference(content_id,revision,lang,"");
                    // get all root child elements
                    List allChildren = root_element.getChildren();
                    // list all child elements
                    for (Iterator iter = allChildren.iterator();
iter.hasNext(); ){
                        Element element = (Element)iter.next();

                        // get product-information child elements
                        if(element.getName().equalsIgnoreCase("product-
information")){
                            List allProductInfo_Children =
element.getChildren();
                            for (Iterator product_info_iter =
allProductInfo_Children.iterator(); product_info_iter.hasNext(); ){
                                Element product_info_element =
(Element)product_info_iter.next();

                                // get model-information child
elements

if(product_info_element.getName().equalsIgnoreCase("model-
information")){
                                    List allmodel_info_Children =
product_info_element.getChildren();
                                    for (Iterator model_info_iter =
allmodel_info_Children.iterator(); model_info_iter.hasNext(); ){
                                        Element model_info_element =
(Element)model_info_iter.next();
                                        // get category child elements

if(model_info_element.getName().equalsIgnoreCase("category")){
                                            String category_code=
model_info_element.getChild("category-code").getText();
                                            String category_name=
model_info_element.getChild("category-name").getText();

orig_category_map.put(category_code,category_name);
                                            List allcategory_Children
= model_info_element.getChildren();
                                            for (Iterator
category_iter = allcategory_Children.iterator();
category_iter.hasNext(); ){
                                                Element
category_element = (Element)category_iter.next();

if(category_element.getName().equalsIgnoreCase("series")){
                                                    String series_code
= category_element.getChild("series-code").getText();
                                                    String series_name
= category_element.getChild("series-name").getText();

orig_series_map.put(series_code,series_name);
                                                    List model_list =
category_element.getChildren("model");
                                                    for(Iterator
model_iter = model_list.iterator(); model_iter.hasNext(); ){
                                                        Element
model_element = (Element)model_iter.next();
                                                        ModelBean
modelBean = new ModelBean();
                                                        String
model_code = model_element.getChild("model-code").getText();
                                                        String
model_name = model_element.getChild("model-name").getText();

modelBean.setCategory_code(category_code);

modelBean.setCategory_name(category_name);

modelBean.setSeries_code(series_code);

modelBean.setSeries_name(series_name);

modelBean.setModel_name(model_name);

model_map.put(model_code,modelBean);
                                                        // add new
content models

xmlAction.addNewContentModels(content_id,revision,lang,model_code);

                                                    }

                                                }

                                            }

                                        }

                                    }
                                }
                            }
                        }

                    }

                    // move xml files to staging folder
                    files[i].renameTo(new File(stagingDir + "/" +
files[i].getName()));
                }else{
                    // delete xml file if content still in queue
                    files[i].delete();
                }

                if(!in_queue){
                    Set model_set = model_map.entrySet();

                    for (Iterator model_map_iter =
model_set.iterator(); model_map_iter.hasNext(); ) {
                        Map.Entry entry =
(Map.Entry)model_map_iter.next();
                        String model_code = (String)entry.getKey();
                        ModelBean modelBean =
(ModelBean)entry.getValue();
                        String model_name =modelBean.getModel_name();
                        String series_code
=modelBean.getSeries_code();
                        String series_name
=modelBean.getSeries_name();
                        String category_code
=modelBean.getCategory_code();
                        String category_name
=modelBean.getCategory_name();
                        // add new model

xmlAction.addNewModel(model_code,model_name,category_code,series_code);

xmlAction.addNewModelOwner(model_code,category_code,series_code);

                    }

                    Set orig_series_set = orig_series_map.entrySet();
                    for (Iterator orig_series_iter =
orig_series_set.iterator(); orig_series_iter.hasNext(); ) {
                        Map.Entry entry =
(Map.Entry)orig_series_iter.next();
                        String series_code = (String)entry.getKey();
                        String series_name = (String)entry.getValue();
                        // add new orig series
                        if(!
StringCommon.check_string_empty(series_code))

xmlAction.addNewOrigSeries(series_code,series_name);

                    }

                    Set orig_category_set =
orig_category_map.entrySet();
                    for (Iterator orig_category_iter =
orig_category_set.iterator(); orig_category_iter.hasNext(); ) {
                        Map.Entry entry =
(Map.Entry)orig_category_iter.next();
                        String category_code = (String)entry.getKey();
                        String category_name =
(String)entry.getValue();
                        // add new orig category
                        if(!
StringCommon.check_string_empty(category_code))

xmlAction.addNewOrigCategories(category_code,category_name);

                    }
                    logger.log(this.getClass().getName(), "XmlServlet
process()" , "upload xml data to database ok");
                }
            }

        } catch (Exception ex) {
            logger.log(this.getClass().getName(), "XmlServlet
process()" , ex.getMessage(),ex);
        }

        return dispatchState;
    }