Page Comparison

Data services are implemented using XML, which means that there can be conflicting element names. Therefore, we use namespaces to uniquely identify the elements defined within a specific web service. Using namespaces for a data service is optional. However, in certain data services, namespaces become necessary. For example, consider a data service with two separate queries using the same set of output mappings. In such situations, you need to use separate namespaces to identify the elements in each query.Namespaces can be used at different levels for . Read below for more information.

See the following topics for instructions on setting namespaces at different levels of a data service:

Setting the namespace for a data service

The service namespace is used to uniquely identify a web service, which means that this namespace applies to all elements in the data service. In the WSDL that represents the service, the namespace is indicated by the "targetNamespace" attribute. The service namespace can be overridden at the query level and at output result row level as explained below. The service namespace can be set using the Create/Edit Data Service window of the set when you define a data service using the management console as shown below.

Setting the namespace for a data service query

When you define a query for your data service, you can set a namespace for the elements in the query result (output mapping). That is, the Row Namespace applies to all the result rows that you define as output mappings for that query. The example below shows how the row namespace is set for the query result element: Customers.

After setting the row namespace, the Customers element's data type of the Customers element falls under the given namespace . The XML Schema fragment in data types section taken from the service's WSDL is as follows:as shown below.

<query id="employeesByNumberSQL" useConfig="default">
      <sql>select * from Employees where employeeNumber = ?</sql>
      <result defaultNamespace="http://abc.com/empNamespace1" element="employees" rowName="employee">
         <element column="lastName" name="last-name" xsdType="string"/>
         <element column="firstName" name="first-name" xsdType="string"/>
         <element column="email" name="email" xsdType="string"/>
         <element column="salary" name="salary" xsdType="double"/>
      </result>
      <param name="employeeNumber" ordinal="1" sqlType="INTEGER"/>
</query>
<query id="employeesByIDSQL" useConfig="default">
      <sql>select * from Employees where employeesID = ?</sql>
      <result defaultNamespace="http://abc.com/empNamespace2" element="employees" rowName="employee">
         <element column="lastName" name="last-name" xsdType="string"/>
         <element column="firstName" name="first-name" xsdType="string"/>
         <element column="email" name="email" xsdType="string"/>
         <element column="phone" name="phone" xsdType="string"/>
      </result>
      <param name="employeeID" ordinal="1" sqlType="INTEGER"/>
</query>

Setting namespaces for specific elements in the query result

The row namespace applies to all elements in the query result. Alternatively, you can specify namespaces for selected elements (output mappingsmapping elements) in the query result as shown below. This namespace will only apply to that element.

This is how the setting is reflected in the WSDL.

Note the following:

<query id="getProductByIDSQL" useConfig="default">
      <sql>select * from Products where productID = ?</sql>
      <result defaultNamespace="http://abc.com/productIDNamespace" element="products" rowName="product">
         <element column="productID" name="productID" xsdType="string"/>
         <element column="productID" name="productID" xsdType="INTEGER"/>
         <element column="productName" name="productName" xsdType="string"/>
      </result>
</query>

Setting namespaces for complex results

In complex results in data services, the result elements can be arbitrarily nested. These nested elements can have their own namespaces. The example below shows how this is represented in a database file fragment, which has a complex result.given below illustrates a query with a complex result (nested elements). As shown below, the namespace specified for the 'contact' element is inherited by the child elements that are nested within. However, if you assign specific namespaces to the child elements, the namespace inherited by the parent element will be overridden. 

<query id="customersInBostonSQL" useConfig="default">
      <sql>select  * from Customers where city = 'Boston' and country = 'USA'</sql>
      <result defaultNamespace="http://abc.com/nsb" element="customers" rowName="customer">
         <element column="customerName" name="customer-name" xsdType="string"/>
         <element namespace="http://abc.com/nsb" name="contact">
         	<element column="contactLastName" name="contact-last-name" xsdType="string"/>
         	<element column="contactFirstName" name="contact-first-name" xsdType="string"/>
         </element>
         <element column="phone" name="phone" xsdType="string"/>
         <element column="city" name="city" xsdType="string"/>
         <element column="country" name="country" xsdType="string"/>
      </result>
</query>

The WSDL created for the above service is as follows:

The resulted XML of the executed service is as follows:

Namespace inheritance in a data service

There's an inheritance order where a top-level namespace is inherited by its children. In summary, the inheritance is as follows: