ws-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Apache Wiki <wikidi...@apache.org>
Subject [Ws Wiki] Update of "WorkingWithNameMapping" by KevinWilliams
Date Tue, 31 Oct 2006 21:39:27 GMT
Dear Wiki user,

You have subscribed to a wiki page or wiki category on "Ws Wiki" for change notification.

The following page has been changed by KevinWilliams:
http://wiki.apache.org/ws/WorkingWithNameMapping

------------------------------------------------------------------------------
     String author = root.getString("Book[1]/Writer"));
  }}}
  
+ Here is the associated configuration file:
+ {{{
+    <Config xsi:noNamespaceSchemaLocation="http:///org.apache.tuscany.das.rdb/config.xsd"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
+      
+        <Command name="get all books" SQL="SELECT * FROM BOOK" kind="Select"/>
+     
+        <Command name="get Cat in the Hat" SQL="SELECT * FROM BOOK WHERE NAME = 'Cat in
the Hat'" kind="Select"/>
+     
+        <Command name="get book by ID" SQL="SELECT * FROM BOOK WHERE BOOK.BOOK_ID = ?"
kind="Select"/>
+     
+        <Table tableName="BOOK" typeName="Book">
+            <Column columnName="BOOK_ID" primaryKey="true"/>
+            <Column columnName="AUTHOR" propertyName="Writer"/>
+ 	   <Column columnName="OCC" collision="true"/>
+        </Table>
+     
+    </Config>
+ }}}
+ 
+ You can see that the Table definition provides "typeName" and "propertyName" attributes
to override the defualt use of the all-uppercase database names.  You can also see the use
of these names in the example Java source.
+ 

---------------------------------------------------------------------
To unsubscribe, e-mail: general-unsubscribe@ws.apache.org
For additional commands, e-mail: general-help@ws.apache.org


Mime
View raw message