Bug 780232 (SOA-2619) - 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
Summary: After importing jdbc metadata from ModeShape to build the Teiid model, the mo...
Keywords:
Status: CLOSED NEXTRELEASE
Alias: SOA-2619
Product: JBoss Enterprise SOA Platform 5
Classification: JBoss
Component: Documentation, EDS
Version: 5.1.0.ER4
Hardware: Unspecified
OS: Unspecified
high
high
Target Milestone: ---
: JBDS
Assignee: Van Halbert
QA Contact:
URL: http://jira.jboss.org/jira/browse/SOA...
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2010-11-29 16:12 UTC by Van Halbert
Modified: 2011-11-30 21:56 UTC (History)
0 users

Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Clone Of:
Environment:
Last Closed: 2011-11-30 21:56:56 UTC
Type: Task


Attachments (Terms of Use)


Links
System ID Private Priority Status Summary Last Updated
Red Hat Issue Tracker SOA-2619 0 None None None Never

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.


Note You need to log in before you can comment on or make changes to this bug.