WebRowSet Format

WebRowSet represents a set of fetched rows that can be passed between tiers and components and for which the data (obtained in XML format) is managed either by storing it in a string or by writing it to a file in the local file system. PeopleSoft uses the standard WebRowSet format based on the WebRowSet schema. When you use WebRowSet, the rows (tabular data) referred to as rowsets can be read and written in XML format, thus enabling rowsets to be sent over the Internet using the HTTP/XML protocol.

WebRowSet Schema definition describes the internal data of a RowSet object in three distinct areas:

Term	Definition
Properties	These properties describe the standard synchronization provider properties in addition to the more general rowset properties.
Metadata	The metadata describes the tabular structure governed by a WebRowSet object.
Data	The data is the current data values.

This example shows the four rows of data returned for a simple query MSGSET that has two columns. The SQL for this query is:

SELECT A.MESSAGE_SET_NBR, A.DESCR
  FROM PSMSGSETDEFN A

Example WebRowset File:

<?xml version='1.0'?>
 <webRowSet xmlns='http://java.sun.com/xml/ns/jdbc'>
  <properties>
    <command></command>
    <concurrency>1007</concurrency>
    <datasource/>
    <escape-processing>true</escape-processing>
    <fetch-direction>1000</fetch-direction>
    <fetch-size>0</fetch-size>
    <isolation-level>1</isolation-level>
    <key-columns/>
    <map/>
    <max-field-size>0</max-field-size>
    <max-rows>0</max-rows>
    <query-timeout>0</query-timeout>
    <read-only>true</read-only>
    <rowset-type>1003</rowset-type>
    <show-deleted>false</show-deleted>
    <table-name/>
    <url></url>
    <sync-provider>
      <sync-provider-name></sync-provider-name>
      <sync-provider-vendor></sync-provider-vendor>
      <sync-provider-version></sync-provider-version>
      <sync-provider-grade></sync-provider-grade>
      <data-source-lock></data-source-lock>
    </sync-provider>
  </properties>
  <metadata>
    <column-count>2</column-count>
    <column-definition>
      <column-index>1</column-index>
      <auto-increment>false</auto-increment>
      <case-sensitive>false</case-sensitive>
      <currency>false</currency>
      <nullable>false</nullable>
      <signed>false</signed>
      <searchable>false</searchable>
      <column-display-size>0</column-display-size>
      <column-label>Message Set</column-label>
      <column-name>A.MESSAGE_SET_N</column-name>
      <schema-name/>
      <column-precision>0</column-precision>
      <column-scale>0</column-scale>
      <table-name/>
      <catalog-name/>
      <column-type>2</column-type>
      <column-type-name>NUMBER</column-type-name>
   </column-definition>
   <column-definition>
      <column-index>2</column-index>
      <auto-increment>false</auto-increment>
      <case-sensitive>false</case-sensitive>
      <currency>false</currency>
      <nullable>false</nullable>
      <signed>false</signed>
      <searchable>false</searchable>
      <column-display-size>0</column-display-size>
      <column-label>Message Set Description</column-label>
      <column-name>A.DESCR</column-name>
      <schema-name/>
      <column-precision>0</column-precision>
      <column-scale>0</column-scale>
      <table-name/>
      <catalog-name/>
      <column-type>1</column-type>
      <column-type-name>CHAR</column-type-name>
   </column-definition>
  </metadata>
  <data>
    <currentRow>
      <columnValue>1</columnValue>
      <columnValue>
        <![CDATA[PeopleTools Message Bar Items]]>
      </columnValue>
    </currentRow>
    <currentRow>
      <columnValue>2</columnValue>
      <columnValue>
        <![CDATA[PeopleCode]]>
      </columnValue>
    </currentRow>
    <currentRow>  
      <columnValue>3</columnValue>
      <columnValue>
        <![CDATA[General Tools Messages]]>
      </columnValue>
    </currentRow>
    <currentRow>
      <columnValue>4</columnValue>
      <columnValue>
        <![CDATA[Help Processor]]>
      </columnValue>
    </currentRow>
  </data>
</webRowSet>