How to read/export XML file which is output from SQL server in JAVA

Question

I have a Query, which I execute in SQL server 2005/2008, gives me output in XML format.

Here is the sample query to generate xml output :

SELECT 
    (SELECT 'White' AS Color1,
            'Blue' AS Color2,
            'Black' AS Color3,
            'Light' AS 'Color4/@Special',
            'Green' AS Color4,
            'Red' AS Color5 
    FOR XML PATH('Colors'),TYPE),
    (SELECT 'Apple' AS Fruits1,
            'Pineapple' AS Fruits2,
            'Grapes' AS Fruits3,
            'Melon' AS Fruits4 
    FOR XML PATH('Fruits'),TYPE) 
FOR XML PATH(''),ROOT('SampleXML')

What I need is, to read the output in Java to convert it to a java.io.File format, so I can parse and populate objects.

I tried : SQLXML sqlxml = resultSet.getSQLXML(column);, which is given in here

But it is throwing an exception : Exception in thread "main" java.lang.AbstractMethodError: com.inet.pool.g.getSQLXML(I)Ljava/sql/SQLXML;

Please suggest me a way to read the file.

Plz Note : I am able to read the o/p as String using resultSet.getString(column), but not able to parse it.

Mads Hansen · Accepted Answer · 2014-06-05 01:48:39Z

2

The SQLXML interface provides methods for accessing the XML value as a String, a Reader or Writer, or as a Stream.put the sqlxml into binary stream and parse the xml

SQLXML sqlxml = resultSet.getSQLXML(column);
InputStream binaryStream = sqlxml.getBinaryStream();

edited Jun 5, 2014 at 1:48

Mads Hansen

67.6k12 gold badges119 silver badges154 bronze badges

answered Mar 6, 2013 at 10:47

MSREDDY

212 bronze badges

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

2 Comments

Sanjeev Over a year ago

it is throwing an exception : Exception in thread "main" java.lang.AbstractMethodError: com.inet.pool.g.getSQLXML(I)Ljava/sql/SQLXML;

MSREDDY Over a year ago

are you using which version of java?SQLXML is support for java 1.6 version.if your using java 1.6 The dbcp library in server must have been compiled against a previous JDK version which doesn't support XML related methods in the SQL classes

Collectives™ on Stack Overflow

How to read/export XML file which is output from SQL server in JAVA

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related