XML file as datasource

[Former Member]

Hi All

I want to read an xml file which contains all the requried data for presentation purposes. Is there any in which this file can be used a datasource and we can query this file to create different reports.

From [this|; thread, it seems that it is possible through JDBC XML drivers. Has anyone used this concept before..??

Also, we are using NW2004s and accordingly, the J2EE engine supports only 1.x or 2.0 compliant JDBC drivers only.

Please suggest as to how to implement this solution.

Thanks

Deepak

[former_member4251]

Hi Deepak,

You can use an SQL query to load the XML data into an Store Procedure, then you can use the SP as supported datasource.

An alternative is by using NWDS you can create a WebService to consume this XML and use it as datasource...

Best Regards,

Luis

[Former Member]

Hi Luis

Thanks for the reply.

The XML file that I have is of the following structure:

<UserDetails>
    <UserInfo>
        <FirstName>fsdfsdfs</Firstname>
        <LastName>dfdsfsd</LastName>
         ...
         ...
        ....

    </UserInfo>
    <UserInfo>
        <FirstName>gdfgdgd</Firstname>
        <LastName>dfgdfgd</LastName>
         ...
         ...
         ...
    </UserInfo>
<UserDetails>

With respect to the above structure, can you please give some technical implementation suggestions as to how your suggestion can be implemented..?? (Like return types in web services, input parameters OR if I have to use Stored Procedures.. how should i go about that..)

Thanks

Deepak