Bug 780063 (SOA-2428)

Summary: Problem executing an ORDER BY thru TEIID against the ModeShape data source
Product: [JBoss] JBoss Enterprise SOA Platform 5 Reporter: Van Halbert <vhalbert>
Component: EDSAssignee: Default User <jbpapp-maint>
Status: CLOSED NEXTRELEASE QA Contact:
Severity: urgent Docs Contact:
Priority: urgent    
Version: unspecified   
Target Milestone: ---   
Target Release: 5.1.0 GA   
Hardware: Unspecified   
OS: Unspecified   
URL: http://jira.jboss.org/jira/browse/SOA-2428
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2011-02-03 15:20:28 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-10-15 15:03:35 UTC 
project_key: SOA

Exucuting query: Select * From nt_base ORDER BY jcr_path

produces the following exception on the server:

[JDBCExecutionException] 0: Error Code:0 Message:'Column 'jcr_path' does not exist on the table 'g_0'
' error executing statement(s): [SQL: SELECT g_0."jcr:name", g_0."jcr:path", g_0."jcr:primaryType", g_0."jcr:score", g_0."mode:depth", g_0."mode:localName" FROM "nt:base" AS g_0 ORDER BY jcr_path]
1 [SQLException]Column 'jcr_path' does not exist on the table 'g_0'
Comment 1 Van Halbert 2010-10-15 15:03:53 UTC 
Link: Added: This issue depends TEIID-1305
Comment 2 Van Halbert 2010-10-19 14:03:28 UTC 
Teiid has fixed the ModeShape translator regarding ORDER BY and this fix should be available for the next build.
Comment 3 Laura Bailey 2010-12-17 00:41:30 UTC 
Writer: Added: Darrin
Comment 4 Laura Bailey 2010-12-17 00:48:01 UTC 
Release Notes Docs Status: Added: Not Yet Documented
Comment 6 Warren Gibson 2011-02-03 15:20:28 UTC 
2/3/2011 - wgibson resolved