Bug 779993 (SOA-2353)

Summary: JDBC metadata getColumns() is exposing column jcr:primaryType for some tables in which its not queryable on the server
Product: [JBoss] JBoss Enterprise SOA Platform 5 Reporter: Van Halbert <vhalbert>
Component: EDSAssignee: Van Halbert <vhalbert>
Status: CLOSED NEXTRELEASE QA Contact:
Severity: high Docs Contact:
Priority: high    
Version: 5.1.0 GA   
Target Milestone: ---   
Target Release: 5.1.0 GA   
Hardware: Unspecified   
OS: Unspecified   
URL: http://jira.jboss.org/jira/browse/SOA-2353
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2010-10-01 15:37:14 UTC Type: Bug
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-09-28 15:19:22 UTC
project_key: SOA

An example is table: mix:created
Database metadata says it has 3 columns: jcr_created,jcr_createdBy,jcr_primaryType
This is what's imported when creating the Teiid model.
However, query: Select jcr:created,jcr:createdBy,jcr:primaryType From mix_created
produces error that indicates jcr:primaryType does not exist. 

See modeshape linked jira for more info.

Comment 1 Van Halbert 2010-09-28 15:19:42 UTC
Link: Added: This issue depends MODE-911


Comment 2 Van Halbert 2010-10-01 15:37:14 UTC
ModeShape has resolved this issue and the new ModeShape.vdb has been created based on the correction to exposing databasemetadata.