[wsas-java-dev] svn commit r11886 - trunk/wsas/java/modules/samples/DataService/dbs

[svn at wso2.org]

Author: sumedha
Date: Sun Jan  6 05:01:09 2008
New Revision: 11886

Log:

Nested Query sample

Added:
   trunk/wsas/java/modules/samples/DataService/dbs/NestedQuerySample.dbs

Added: trunk/wsas/java/modules/samples/DataService/dbs/NestedQuerySample.dbs
==============================================================================
--- (empty file)
+++ trunk/wsas/java/modules/samples/DataService/dbs/NestedQuerySample.dbs	Sun Jan  6 05:01:09 2008
@@ -0,0 +1,40 @@
+<data name="NextedQuerySample">
+   <config>
+      <property name="org.wso2.ws.dataservice.driver">org.apache.derby.jdbc.EmbeddedDriver</property>
+      <property name="org.wso2.ws.dataservice.protocol">jdbc:derby:../samples/DataService/database/DATA_SERV_SAMP</property>
+      <property name="org.wso2.ws.dataservice.user">wso2wsas</property>
+      <property name="org.wso2.ws.dataservice.password">wso2wsas</property>
+   </config>
+
+   <operation name="customerOrders">
+      <call-query href="customerOrdersSQL" />
+   </operation>
+
+   <query id="customerOrdersSQL">
+      <sql>select o.ORDERNUMBER,o.ORDERDATE, o.STATUS,o.CUSTOMERNUMBER from WSO2WSAS.ORDERS o</sql>
+
+      <result element="Orders" rowName="Order">
+         <element name="Order-number" column="ORDERNUMBER" />
+         <element name="Last-name" column="ORDERDATE" />
+         <element name="First-name" column="STATUS" />
+         <call-query href="customerNameSQL">
+            <with-param name="customerNumber" query-param="customerNumber" />
+         </call-query>
+      </result>
+   </query>
+
+   <operation name="customerName">
+      <call-query href="customerNameSQL">
+         <with-param name="customerNumber" query-param="customerNumber" />
+      </call-query>
+   </operation>
+
+   <query id="customerNameSQL">
+      <sql>select c.CUSTOMERNAME from WSO2WSAS.CUSTOMERS c where c.CUSTOMERNUMBER = ?</sql>
+      <result element="Customers" rowName="Customer">
+         <element name="Name" column="CUSTOMERNAME" />
+      </result>
+      <param name="customerNumber" sqlType="INTEGER" />
+   </query>
+</data>
+