-Original Message-
From: Jakob Braeuchi [mailto:[EMAIL PROTECTED]
Sent: Friday, June 23, 2006 9:54 PM
To: OJB Users List
Cc: Selders, Bart
Subject: Re: Bug : duplicate objects in resultset : Modify RsIterator
class?
hi roger,
with your path applied the testcase
public void
: Bug : duplicate objects in resultset : Why add orderby
columns to resultset?
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
: duplicate objects in resultset : Why add orderby
columns to resultset?
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
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
]
Sent: Friday, June 16, 2006 9:11 PM
To: OJB Users List
Subject: Re: Bug : duplicate objects in resultset
hi roger,
the following works for me. i use a set instead of a collection:
public void testOrderByJoined2()
{
Criteria crit = new Criteria();
QueryByCriteria q
Janssen
iBanx
-Original Message-
From: Jakob Braeuchi [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 15, 2006 10:13 PM
To: OJB Users List
Cc: Selders, Bart
Subject: Re: Bug : duplicate objects in resultset
hi roger,
i can confirm this problem.
this simple testcase shows
(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
-Original Message-
From: Thomas Dudziak [mailto:[EMAIL PROTECTED]
Sent: 19 June 2006 22:26
Subject: Re: Bug : duplicate objects in resultset : Why add orderby
columns to resultset?
On 6/19/06, Janssen, Roger [EMAIL PROTECTED] wrote:
Diving deeper into the OJB code I see
: duplicate objects in resultset
hi roger,
i can confirm this problem.
this simple testcase shows the duplicates:
/**
* test OrderBy joined column
*/
public void testOrderByJoined2()
{
Criteria crit = new Criteria();
QueryByCriteria q
PROTECTED]
Sent: Thursday, June 15, 2006 10:13 PM
To: OJB Users List
Cc: Selders, Bart
Subject: Re: Bug : duplicate objects in resultset
hi roger,
i can confirm this problem.
this simple testcase shows the duplicates:
/**
* test OrderBy joined column
*/
public void
hi roger,
i can confirm this problem.
this simple testcase shows the duplicates:
/**
* test OrderBy joined column
*/
public void testOrderByJoined2()
{
Criteria crit = new Criteria();
QueryByCriteria q = QueryFactory.newQuery(Project.class, crit);
12 matches
Mail list logo