[wsas-java-dev] svn commit r9539 - in branches/wsas/java/2.1/wsas/java/modules/samples/DataService: dbs sql

[svn at wso2.org]

Author: azeez
Date: Wed Nov  7 07:19:57 2007
New Revision: 9539

Modified:
   branches/wsas/java/2.1/wsas/java/modules/samples/DataService/dbs/DataServiceSample1.dbs
   branches/wsas/java/2.1/wsas/java/modules/samples/DataService/sql/CreateTables.sql
Log:
Changing the SQLs to have the same case as given in the .sql files

Modified: branches/wsas/java/2.1/wsas/java/modules/samples/DataService/dbs/DataServiceSample1.dbs
==============================================================================
--- branches/wsas/java/2.1/wsas/java/modules/samples/DataService/dbs/DataServiceSample1.dbs	(original)
+++ branches/wsas/java/2.1/wsas/java/modules/samples/DataService/dbs/DataServiceSample1.dbs	Wed Nov  7 07:19:57 2007
@@ -6,18 +6,18 @@
         <property name="org.wso2.ws.dataservice.password">wsas</property>            
     </config>
 
-    <operation name="customersInBoston">                
-        <call-query href="customersInBostonSQL" />        
+    <operation name="customersInBoston">                        
+        <call-query href="customersInBostonSQL" />
     </operation>
     <query id="customersInBostonSQL">
-        <sql>select CUSTOMERNAME, CONTACTLASTNAME, CONTACTFIRSTNAME, PHONE, CITY, COUNTRY from WSO2WSAS.CUSTOMERS where CITY = 'Boston' and COUNTRY = 'USA'</sql>
+        <sql>select  * from Customers where city = 'Boston' and country = 'USA'</sql>
         <result element="customers" rowName="customer">
-            <element name="customer-name" column="CUSTOMERNAME" />
-            <element name="contact-last-name" column="CONTACTLASTNAME" />
-            <element name="contact-first-name" column="CONTACTFIRSTNAME" />
-            <element name="phone" column="PHONE" />
-            <element name="city" column="CITY" />
-            <element name="country" column="COUNTRY" />
+            <element name="customer-name" column="customerName" />
+            <element name="contact-last-name" column="contactLastName" />
+            <element name="contact-first-name" column="contactFirstName" />
+            <element name="phone" column="phone" />
+            <element name="city" column="city" />
+            <element name="country" column="country" />
         </result>
     </query>
 
@@ -26,15 +26,15 @@
             <with-param name="employeeNumber" query-param="employeeNumber" />
         </call-query>
     </operation>
-    <query id="employeesByNumberSQL">        
-        <sql>select LASTNAME, FIRSTNAME, EMAIL from WSO2WSAS.EMPLOYEES where EMPLOYEENUMBER = ?</sql>        
-        <result element="employees" rowName="employee">            
-            <element name="last-name" column="LASTNAME" />            
-            <element name="first-name" column="FIRSTNAME" />            
-            <element name="email" column="EMAIL" />        
-        </result>        
-        <param name="employeeNumber" sqlType="INTEGER" />    
-    </query>    
+    <query id="employeesByNumberSQL">
+        <sql>select * from Employees where employeeNumber = ?</sql>
+        <result element="employees" rowName="employee">
+            <element name="last-name" column="lastName" />
+            <element name="first-name" column="firstName" />
+            <element name="email" column="email" />
+        </result>
+        <param name="employeeNumber" sqlType="INTEGER" />
+    </query>
 
     <operation name="customerAddress">
         <call-query href="customerAddressSQL">
@@ -43,17 +43,17 @@
         </call-query>
     </operation>
     <query id="customerAddressSQL">
-        <sql>select CUSTOMERNUMBER, CONTACTLASTNAME, CONTACTFIRSTNAME, ADDRESSLINE1, ADDRESSLINE2, CITY, STATE, POSTALCODE, COUNTRY from WSO2WSAS.CUSTOMERS where CONTACTLASTNAME = ? and CONTACTFIRSTNAME = ?</sql>
+        <sql>select * from Customers where contactLastName = ? and contactFirstName = ?</sql>
         <result element="customer-addresses" rowName="customer-address">
-            <element name="customernumber" column="CUSTOMERNUMBER" />
-            <element name="contactlastname" column="CONTACTLASTNAME" />
-            <element name="contactfirstname" column="CONTACTFIRSTNAME" />
-            <element name="addressline1" column="ADDRESSLINE1" />
-            <element name="addressline2" column="ADDRESSLINE2" />
-            <element name="city" column="CITY" />
-            <element name="state" column="STATE" />
-            <element name="postalcode" column="POSTALCODE" />
-            <element name="country" column="COUNTRY" />
+            <element name="customer-number" column="customerNumber" />
+            <element name="contact-last-name" column="contactLastName" />
+            <element name="contact-first-name" column="contactFirstName" />
+            <element name="address-line1" column="addressLine1" />
+            <element name="address-line2" column="addressLine2" />
+            <element name="city" column="city" />
+            <element name="state" column="state" />
+            <element name="postal-code" column="postalCode" />
+            <element name="country" column="country" />
         </result>
         <param name="lastName" sqlType="STRING" />
         <param name="firstName" sqlType="STRING" />

Modified: branches/wsas/java/2.1/wsas/java/modules/samples/DataService/sql/CreateTables.sql
==============================================================================
--- branches/wsas/java/2.1/wsas/java/modules/samples/DataService/sql/CreateTables.sql	(original)
+++ branches/wsas/java/2.1/wsas/java/modules/samples/DataService/sql/CreateTables.sql	Wed Nov  7 07:19:57 2007
@@ -59,7 +59,7 @@
 CREATE TABLE ProductLines(
 	productLine VARCHAR(50),
 	textDescription VARCHAR(4000),
-	htmlDescription CLOB,
+	htmlDescription VARCHAR(4000),
 	image BLOB
 );
 CREATE UNIQUE INDEX productLines_pk on ProductLines( productLine );