Skip to Content
avatar image
Former Member

XML file as datasource

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|can-xml-files-be-used-for-data; 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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Oct 13, 2008 at 07:42 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • 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