"mvk", We're pleased to have you here with us in the JDBC forum, but there are a few rules that need to be followed, and one is that proper names are required. Please take a look at the JavaRanch Naming Policy and adjust your display name to match it.
In particular, your display name must be a first and a last name separated by a space character, and must not be obviously fictitious.
Which Database are you using? I'd expect you'd have to consult your DB/Driver documentation for an answer. After quick glace at my Oracle docs, it seems you use the Oracle specific Class oracle.xdb.XMLType with this data type. Probably different on other platforms, if they support this type.
We are using Oracle Database. Per our architecture, Stored procedure will return this COLUMN of type XMLTYPE, along with other values. I would like to retrieve it along with other values. I think i might have to parse the values from the XMLTYPE data.
If you want to deal with XMLTYPE in JDBC code then you will have to use Oracle driver's extension -
XMLType xml = XMLType.createXML(resultSet.getOPAQUE("xmlColumn"));
There are multiple ways to deal with XMLType in your JDBC code. One is to use Oracle Specific extension as above, You can also use JAVA DOM API with Oracle extension. You can find enough examples in online documentation.
Other simple way to avoid Oracle specific extensions would be to make your stored procedure return CLOB or String for XMLType.
The Select statement in SP would look like
SELECT e.xmlColumn.getStringVal() from table e -- for String SELECT e.xmlColumn.getClobVal() from table e -- for Clob
subject: how to use data of type XMLTYPE in database in java