Bug 779993 (SOA-2353) - JDBC metadata getColumns() is exposing column jcr:primaryType for some tables in which its not queryable on the server
Summary: JDBC metadata getColumns() is exposing column jcr:primaryType for some tables...
Keywords:
Status: CLOSED NEXTRELEASE
Alias: SOA-2353
Product: JBoss Enterprise SOA Platform 5
Classification: JBoss
Component: EDS
Version: 5.1.0 GA
Hardware: Unspecified
OS: Unspecified
high
high
Target Milestone: ---
: 5.1.0 GA
Assignee: Van Halbert
QA Contact:
URL: http://jira.jboss.org/jira/browse/SOA...
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2010-09-28 15:19 UTC by Van Halbert
Modified: 2011-11-30 18:59 UTC (History)
0 users

Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Clone Of:
Environment:
Last Closed: 2010-10-01 15:37:14 UTC
Type: Bug

Attachments (Terms of Use)
Add an attachment (proposed patch, testcase, etc.)


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

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.
Note You need to log in before you can comment on or make changes to this bug.