Re: Example to define the ResultSet shape Definition for a join in DAS
Hi, DAS Config file does support ResultDescriptor and [2] test case mentioned by Luciano is quite descriptive. This functionality is there in the latest stable release. Recently there is JIRA-1465 fixed with which, Dynamically created Commands (the ones that are not in DAS Config file) also can make use of ResultDescriptor. This is fixed in the svn trunk but not part of release. Also, in order to get correct query results from DAS, it may be good to include the column Primary Keys of all tables involved in the Select clause. This is just a suggestion by looking at the query you have mentioned. Regards, Amita On 8/15/07, Chu, Wing (Exchange) [EMAIL PROTECTED] wrote: Would like an example if my query is a join between two tables? For example, Select a.dept_name, b.employee_name from dept a, emp b where a.id = b.dept_id (+) How do I define an Explicit ResultSet shape definition for the resultset from a join I'm working in Oracle. Thanks, Wing *** Bear Stearns is not responsible for any recommendation, solicitation, offer or agreement or any information about any transaction, customer account or account activity contained in this communication. *** - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Example to define the ResultSet shape Definition for a join in DAS
Would like an example if my query is a join between two tables? For example, Select a.dept_name, b.employee_name from dept a, emp b where a.id = b.dept_id (+) How do I define an Explicit ResultSet shape definition for the resultset from a join I'm working in Oracle. Thanks, Wing *** Bear Stearns is not responsible for any recommendation, solicitation, offer or agreement or any information about any transaction, customer account or account activity contained in this communication. *** - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: Example to define the ResultSet shape Definition for a join in DAS
You can find some information on the DAS User Guide [1]. There are couple test cases that also show this working, here is one test case [2] and it's config file [3]. Amita is also working on getting support for passing ResultDescriptor for dynamic Commands [4], if that would be useful for you. [1] http://incubator.apache.org/tuscany/explicit-resultset-shape-definition.html [2] https://svn.apache.org/repos/asf/incubator/tuscany/java/das/rdb/src/test/java/org/apache/tuscany/das/rdb/test/RelationshipTests.java [3] https://svn.apache.org/repos/asf/incubator/tuscany/java/das/rdb/src/test/resources/companyMappingWithResultDescriptor.xml [4] http://www.mail-archive.com/[EMAIL PROTECTED]/msg19886.html On 8/15/07, Chu, Wing (Exchange) [EMAIL PROTECTED] wrote: Would like an example if my query is a join between two tables? For example, Select a.dept_name, b.employee_name from dept a, emp b where a.id = b.dept_id (+) How do I define an Explicit ResultSet shape definition for the resultset from a join I'm working in Oracle. Thanks, Wing *** Bear Stearns is not responsible for any recommendation, solicitation, offer or agreement or any information about any transaction, customer account or account activity contained in this communication. *** - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] -- Luciano Resende Apache Tuscany Committer http://people.apache.org/~lresende http://lresende.blogspot.com/ - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
