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