Bug 780232 (SOA-2619)

Summary: After importing jdbc metadata from ModeShape to build the Teiid model, the mode_properties column in every table must be updated to set 'Selectable' to false
Product: [JBoss] JBoss Enterprise SOA Platform 5 Reporter: Van Halbert <vhalbert>
Component: Documentation, EDSAssignee: Van Halbert <vhalbert>
Status: CLOSED NEXTRELEASE QA Contact:
Severity: high Docs Contact:
Priority: high    
Version: 5.1.0.ER4   
Target Milestone: ---   
Target Release: JBDS   
Hardware: Unspecified   
OS: Unspecified   
URL: http://jira.jboss.org/jira/browse/SOA-2619
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2011-11-30 21:56:56 UTC Type: Task
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:

Description Van Halbert 2010-11-29 16:12:03 UTC 
project_key: SOA

Because Jcr sql doesn't fit nicely into the sql world, a pseudo-column had to be added to sql language for ModeShape in order to transform the query into a jcr readable query.    And this pseudo-column is exposed when importing metadata from ModeShape.    However, because there is no special ModeShape JDBC Importer (yet), the  column attributes - 'Selectable', must be manually changed to 'false' on every table that the mode_properties column appears (which should be every table).    Otherwise,  performing a 'Select *' on a table will result in a query that contains the pseudo-column that is sent to ModeShape, resulting in a invalid query.
Comment 1 Van Halbert 2010-11-29 16:57:12 UTC 
Link: Added: This issue is related to TEIIDDES-723
Comment 2 Van Halbert 2010-11-29 23:13:02 UTC 
Checked in an updated ModeShape.vdb that has the mode:properties column Selectable attribute set to false.
Comment 3 Van Halbert 2010-12-03 21:51:25 UTC 
Changes were committed to change mode:properties to not be selectable upon importing.
Comment 4 Paul Nittel 2011-11-30 21:56:56 UTC 
Tested and closed.