Bug 780063 (SOA-2428) - Problem executing an ORDER BY thru TEIID against the ModeShape data source
Summary: Problem executing an ORDER BY thru TEIID against the ModeShape data source
Keywords:
Status: CLOSED NEXTRELEASE
Alias: SOA-2428
Product: JBoss Enterprise SOA Platform 5
Classification: JBoss
Component: EDS
Version: unspecified
Hardware: Unspecified
OS: Unspecified
urgent
urgent
Target Milestone: ---
: 5.1.0 GA
Assignee: Default User
QA Contact:
URL: http://jira.jboss.org/jira/browse/SOA...
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2010-10-15 15:03 UTC by Van Halbert
Modified: 2011-02-03 15:20 UTC (History)
0 users

Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Clone Of:
Environment:
Last Closed: 2011-02-03 15:20:28 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-2428 0 None Closed Problem executing an ORDER BY thru TEIID against the ModeShape data source 2012-01-13 09:23:34 UTC

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