oracle id in m:n tables

2006-06-19 Thread Dennis Bekkering
Hello All, When i add a record to a collection that is of type many 2 many the following sql is executed INSERT INTO m2m_196 (ruleValueListId,ruleValueId) VALUES (?,?) , the id field is not specified in the query but the table has such a field and therefore oracle complains about the fact that

RE: Bug : duplicate objects in resultset

2006-06-19 Thread Janssen, Roger
Hi, You're solution only seems to filter out the duplicates based on hashmap logic, this of course only works when the method hashCode() has properly been implemented. [And... does this suggested solution support the paging (pagination) implementation?] But more critical since the resultset

Re: oracle id in m:n tables

2006-06-19 Thread Thomas Dudziak
On 6/19/06, Dennis Bekkering [EMAIL PROTECTED] wrote: When i add a record to a collection that is of type many 2 many the following sql is executed INSERT INTO m2m_196 (ruleValueListId,ruleValueId) VALUES (?,?) , the id field is not specified in the query but the table has such a field and

Re: oracle id in m:n tables

2006-06-19 Thread Dennis Bekkering
Thanks for the link Tom, that information was exactly what i was looking for. 2006/6/19, Thomas Dudziak [EMAIL PROTECTED]: On 6/19/06, Dennis Bekkering [EMAIL PROTECTED] wrote: When i add a record to a collection that is of type many 2 many the following sql is executed INSERT INTO

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

2006-06-19 Thread Janssen, Roger
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...

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

2006-06-19 Thread Janssen, Roger
Hi, 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 okay for orderby's, but (1) is not. If for orderby's

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

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: Diving deeper into the OJB code I see that