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> + _______________________________________________ Wsas-java-dev mailing list [email protected] http://wso2.org/cgi-bin/mailman/listinfo/wsas-java-dev
