hi all,
this is what hsql says when the orderby column is not in the select :(
Caused by: java.sql.SQLException: ORDER BY item should be in the SELECT
DISTINCT list: [EMAIL PROTECTED] in statement [SELECT
DISTINCT A0.ID,A0.TITLE,A0.DESCRIPTION FROM PROJECT A0 INNER JOIN
PERSON_PROJECT A1 ON
Hi,
I found the following in OJB code:
For Version 1.0.4:
In class SqlSelectStatement in method protected String
buildStatement():
orderByFields = query.getOrderBy();
columnList = ensureColumns(orderByFields, columnList, stmt);
For Version 1.0 RC6 (which we are still using...
(1) was left
out, would that be a problem?
Roger Janssen
iBanx
-Original Message-
From: Janssen, Roger [mailto:[EMAIL PROTECTED]
Sent: Monday, June 19, 2006 5:32 PM
To: OJB Users List
Subject: RE: Bug : duplicate objects in resultset : Why add orderby
columns to resultset?
Hi,
I found
On 6/19/06, Janssen, Roger [EMAIL PROTECTED] wrote:
Diving deeper into the OJB code I see that the ensureColumns method in
fact does two things:
(1) add the columns to the returnable set of columns in the resultset
(2) adds the columns to a list of columns to be used in force a join
(2) is