From 200a40b332420f94992eb39a6d0ea1cf1490ffc4 Mon Sep 17 00:00:00 2001 From: coreyg Date: Fri, 21 Nov 2014 09:30:19 +0000 Subject: Adding tuscany's website to their svn repo for svnpubsub git-svn-id: http://svn.us.apache.org/repos/asf/tuscany@1640879 13f79535-47bb-0310-9956-ffa450edef68 --- .../rdb-das-c-resultsetdrivendataobjecttypes.html | 98 ++++++++++++++++++++++ 1 file changed, 98 insertions(+) create mode 100644 site/trunk/site-publish/rdb-das-c-resultsetdrivendataobjecttypes.html (limited to 'site/trunk/site-publish/rdb-das-c-resultsetdrivendataobjecttypes.html') diff --git a/site/trunk/site-publish/rdb-das-c-resultsetdrivendataobjecttypes.html b/site/trunk/site-publish/rdb-das-c-resultsetdrivendataobjecttypes.html new file mode 100644 index 0000000000..fd6e26d6a0 --- /dev/null +++ b/site/trunk/site-publish/rdb-das-c-resultsetdrivendataobjecttypes.html @@ -0,0 +1,98 @@ + + + + + + + RDB DAS C++ ResultSetDrivenDataObjectTypes : Apache Tuscany + + + + + + + + + + + + + + + + +
+ + + + +   + + + +
+ + +
+
+ + + + + + + +
+  Apache Tuscany > Home > DAS Overview > DAS C++ > DAS C++ Documentation Menu > RDB DAS C++ - User Guide > RDB DAS C++ ResultSetDrivenDataObjectTypes + + User List | Dev List | Issue Tracker   +
+ + + + + +
+
+ +
+
+

ResultSetDrivenDataObjectTypes 

+ +

RDB DAS uses the database metadata retrieved by ODBC driver to create the set of SDO Types used to construct the data graph returned as a result of a query. ODBC returns the data resulting from a query as a set of rows of column values. The metadata associated with this result set provides information about these values. Table name, column name, column type, etc. are all provided for each returned value.

+ +

For example, consider a database with the following table:

+
+
TABLE CUSTOMER
+      ID         INTEGER
+      LASTNAME   VARCHAR(20)
+      ADDRESS    VARCHAR(30)
+
+
+

The user might query the database like this:

+
+

DASImpl* das = (DASImpl*) DASImpl::getFactory().createDAS(getConnection());
+ CommandPtr readCustomers = das->createCommand("select * from CUSTOMER where LASTNAME = 'Williams'");
+ DataObjectPtr root = readCustomers0->executeQuery();

+
+

The DAS returns a graph of DataObjects each of Type CUSTOMER and each instance 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 metadata.

+
+
+
+
+ + + + + website stats + + + + + \ No newline at end of file -- cgit v1.2.3