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 "Tuscany/TuscanyJava/DAS Java Overview/RDBDAS Java User Guide/ResultSet-driven metadata" by KevinWilliams
Date Mon, 02 Oct 2006 22:12:08 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/Tuscany/TuscanyJava/DAS_Java_Overview/RDBDAS_Java_User_Guide/ResultSet-driven_metadata

------------------------------------------------------------------------------
  
  The RDB DAS uses JDBC [http://java.sun.com/j2se/1.3/docs/api/java/sql/ResultSetMetaData.html
ResultSetMetadata] to create the set of SDO Types used to construct the data graph returned
as a result of a query.  JDBC provides an instance of ResultSet to return the data reulting
from a query execution and this data is organized as rows of column values.  The associated
!ResultSetMetadata provides information about the values.  For example, table name, column
name, column type, etc are provided for each returned column value in the !ResultSet.
  
- Consider
+ For example, consider a database with the following table:
+ {{{
+    TABLE CUSTOMER
+              ID         INTEGER
+              LASTNAME   VARCHAR(20)
+              ADDRESS    VARCHAR(30)
+ }}}
  
+ The user then queries the database like this:
+ 
+ {{{
+    DAS das = DAS.FACTORY.createDAS(getConnection());
+    Command readCustomers = das.createCommand("select * from CUSTOMER where LASTNAME = 'Williams'");
	
+    DataObject root = readCustomers.executeQuery();			
+ }}}
+ 
+ The DAS will returns a graph of !DataObjects each of Type CUSTOMER and each instance in
will have three properties: (ID, LASTNAME, ADDRESS).  Since this example does not pass the
DAS a set of SDO Types to use, the DAS creates the Types dynamically based on the !ResultSetMetadata
+ 

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


Mime
View raw message