ws-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Apache Wiki <>
Subject [Ws Wiki] Update of "WorkingWithNameMapping" by KevinWilliams
Date Tue, 31 Oct 2006 21:35:49 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:

  The default behavior for the RDB DAS is to map database names to SDO names.  So, if a CUTSOMER
table is read from the database then each row will be represented as a CUSTOMER !DataObject.
 Likewise, if the CUSTOMER tabel has columns (ID, LASTNAME, ADDRESS) then CUSTOMER !DataObject
instances will have properties (ID, LASTNAME, ADDRESS).  Database Table names map to !DataObject
Type names and database column names map to !DataObject property names.
+ This implicit mapping of database and SDO names woks well but some developers will want
explicit name mapping that allows the database and SDO names to vary.  One typical example
is that the database might have all tables and columns conventionally named in all upercase
but a Java developer might want to wrk with SDO Types and properties that are camelcased.
 So, database names CUSTOMER and LASTNAME might map to SDO names Customer and lastName.
+ The RDB DAS allows this type of explicit mapping via configuration (usually in the form
of a XML config file).  The following example illstrates the use of this feature:
+ {{{
+    DAS das = DAS.FACTORY.createDAS(getConfig("BooksConfigWithAlias.xml"), getConnection());
+    Command select = das.getCommand("get book by ID");
+    select.setParameter(1, Integer.valueOf(1));
+    DataObject root = select.executeQuery();
+    String author = root.getString("Book[1]/Writer"));
+ }}}

To unsubscribe, e-mail:
For additional commands, e-mail:

View raw message