Reading XML database column in java

Question

I have DB2 database with XML column. I would like to read data from it and save each XML to separate file.

Here is a part of my code:

final List<Map<String, Object>> myList = dbcManager.createQuery(query).getResultList();
    int i=0;
    for (final Map<String, Object> element : myList) {
        i++;
        String filePath = "C://elements//elem_" + i + ".xml";
        File file = new File(filePath);
        if(!file.exists()){
            file.createNewFile();
        }

        BufferedWriter out = new BufferedWriter(new FileWriter(filePath));
        out.write(element.get("columnId"));
        out.close();
    }

Now, I have error in line out.write(element.get("columnId"));, because element.get("columnId") is an object type and it should be for example string.

And my question is: To which type should I convert (cast) element.get("columnId") to save it in xml file?

amolnpujari.wordpress.com/2008/04/12/db2-native-xml might help — Amol Pujari
– Amol Pujari, Commented Mar 20, 2014 at 11:19

mustaccio · Accepted Answer · 2013-08-12 13:50:43Z

1

You should use the ResultSet.getSQLXML() method to read the XML column value, then use an appropriate method of the SQLXML class, e.g. getString() or getCharacterStream(). More info here.

answered Aug 12, 2013 at 13:50

mustaccio

19.1k16 gold badges51 silver badges60 bronze badges

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

Collectives™ on Stack Overflow

Reading XML database column in java

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related