Re: Bug : duplicate objects in resultset [new patch]

2006-07-07 Thread Jakob Braeuchi
, and if so, will it be applied in 1.0.5 and 1.1? Roger Janssen iBanx -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 cl

Re: Bug : duplicate objects in resultset : Modify RsIterator class?

2006-06-23 Thread Jakob Braeuchi
From: Jakob Braeuchi [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 21, 2006 10:13 PM To: OJB Users List Subject: Re: 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: jav

Re: Bug : duplicate objects in resultset : Modify RsIterator class?

2006-06-23 Thread Jakob Braeuchi
006 10:13 PM To: OJB Users List Subject: Re: 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 PRO

RE: Bug : duplicate objects in resultset : Modify RsIterator class?

2006-06-22 Thread Janssen, Roger
: 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,A0.TIT

Re: Bug : duplicate objects in resultset : Why add orderby columns to resultset?

2006-06-21 Thread Jakob Braeuchi
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 A

RE: Bug : duplicate objects in resultset : Why add orderby column s to resultset?

2006-06-19 Thread Charles Anthony
> -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: >

Re: Bug : duplicate objects in resultset : Why add orderby columns to resultset?

2006-06-19 Thread Thomas Dudziak
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 ok

RE: Bug : duplicate objects in resultset : Why add orderby columns to resultset?

2006-06-19 Thread Janssen, Roger
rby's (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

RE: Bug : duplicate objects in resultset : Why add orderby columns to resultset?

2006-06-19 Thread Janssen, Roger
ject: 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 = QueryFactory.newQuery(Project.class, cr

RE: Bug : duplicate objects in resultset

2006-06-19 Thread Janssen, Roger
ECTED] 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(); QueryByCrite

Re: Bug : duplicate objects in resultset

2006-06-16 Thread Jakob Braeuchi
lto:[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 the duplicates: /** * test OrderBy joined column */ p

RE: Bug : duplicate objects in resultset

2006-06-16 Thread Janssen, Roger
: 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

Re: Bug : duplicate objects in resultset

2006-06-15 Thread Jakob Braeuchi
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); q.

Bug : duplicate objects in resultset

2006-06-15 Thread Janssen, Roger
Hi guys, I have come across a bug. I included a method to be added to org.apache.ojb.broker.QueryTest class in the OJB testsuite that reproduces that bug, for version 1.0.4! The test: Create a project, create two persons, the two persons are a member of the project, select all projects ordered by