how to insert xml file data into mongodb database using java?

Question

how can i insert xml file data/contents (which is already exist in a disk) into MongoDB database using java?

please any one can resolve it.

//Edited code

XmlMapper xmlMapper = new XmlMapper();
        List entries = xmlMapper.readValue(new File("C:/Users/manish/Desktop/BaseX65/xml/books.xml"),List.class);

        ObjectMapper jsonMapper = new ObjectMapper();
        String json = jsonMapper.writeValueAsString(entries);

        try
         {

                Mongo mongo = new Mongo("localhost", 27017);
                DB db = mongo.getDB("newdb");

                DBCollection collection = db.getCollection("dummyColl");


                DBObject dbObject = (DBObject)JSON.parse(json);

                collection.insert(dbObject);

                DBCursor cursorDocJSON = collection.find();
                while (cursorDocJSON.hasNext()) {
                    System.out.println(cursorDocJSON.next());
                  }         
         }

I'm currently going the way of xml -JAXB-> Java -Jackson-> json -> DBObject -> mongodb might try that or any other way you can use to read an xml file to java and then to produce an DBObject out of — Trudbert
– Trudbert, Commented Aug 21, 2014 at 10:50
Why using json and dbobject? Wouldn't it be much simpler if you just did an sql insert after parsing the xml? — Michael Kleimann
– Michael Kleimann, Commented Aug 21, 2014 at 10:56
@mk2301 mongodb is nosql and stores bson (binary json) documents and I also use the json stuff for other things too so jackson annotations are there anyway. The mongo driver provides a method to transform json to a dbobject which can then be inserted. — Trudbert
– Trudbert, Commented Aug 21, 2014 at 11:11

Michael Kleimann · Accepted Answer · 2014-08-21 11:23:47Z

2

Read the file (FileInputStream)
Parse the file (using DOM, JAXB, etc.)
Bring the contents into the right format (json, DBobject)
Insert the parsed information into db (using the appropriate db drivers)

edited Aug 21, 2014 at 11:23

answered Aug 21, 2014 at 10:52

Michael Kleimann

5123 silver badges10 bronze badges

Sign up to request clarification or add additional context in comments.

9 Comments

manish payasi Over a year ago

could you provide me a sample application to store xml data into MongoDB because i tried it but i didn't able to resolve it. I'll be thankful to you.

Trudbert Over a year ago

@manishpayasi see this question for xml to json and this question to insert json into mongodb

manish payasi Over a year ago

@mk2301 see the above code which i have edited, but it throw the exception "java.lang.ClassCastException: com.mongodb.BasicDBList cannot be cast to [Lcom.mongodb.DBObject" So please provide some sample applications which can help something to me.

manish payasi Over a year ago

@Trudbert how to convert xml to json and then store that json into mongodb

Trudbert Over a year ago

No JSON.parse is ok that's from the mongo driver my guess would be the array thing. But without any information on what goes wrong there is no way of telling why it goes wrong...

|

manish payasi · Accepted Answer · 2014-08-22 06:33:22Z

0

List<DBObject> dbObject =(List<DBObject>) JSON.parse(json)

edited Aug 22, 2014 at 6:33

answered Aug 22, 2014 at 6:27

manish payasi

872 silver badges10 bronze badges

Collectives™ on Stack Overflow

how to insert xml file data into mongodb database using java?

2 Answers 2

9 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

9 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related