Skip to Content
0
Former Member
Mar 27, 2008 at 03:35 PM

resolve xml passed as a single string to multiple records

10 Views

Hi

I am using the JDBC adapter to poll for a msg from the DB(by calling a stored procedure). The DB gives me a result set in the form of an xml (the full set of records is passed as a single string). Due to this the adapter is unable to recognise the file as an xml.

Is there any other method to get the file? Can I use the SOAP service(though I prefer not to..)

This is how my input file looks like:

<?xml version="1.0" encoding="utf-8" ?>

- http://test.com/test/SQLXML/Trial">

- <row>

<XMLResult><root><Product><ParentID>1</ParentID><ParentName>Parent 1</ParentName><Child><ChildID>1</ChildID><ChildName>Child 1</ChildName></Child><Child><ChildID>2</ChildID><ChildName>Child 2</ChildName></Child></Product><Product><ParentID>2</ParentID><ParentName>Parent 2</ParentName><Child><ChildID>4</ChildID><ChildName>Child 4</ChildName></Child><Child><ChildID>5</ChildID><ChildName>Child 5</ChildName></Child></Product><Product><ParentID>3</ParentID><ParentName>Parent 3</ParentName><Child><ChildID>3</ChildID><ChildName>Child 3</ChildName></Child></Product></root></XMLResult>

</row>

</ns:Trial_MT>

Thanks in advance

smitha