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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
