Crash while retrieving Results from a Reportquery and query.setEndAtIndex()

2005-02-14 Thread Christoph Hermann
Hello, i'm having Problems when retrieving Results with a Reportquery. I set the max number of results to 10 and on the 9th row my loop crashes (because in the database there are only 8 rows). I would expect ojb to only return 8 Rows. Code snippet: var crit = new

Re: Crash while retrieving Results from a Reportquery and query.setEndAtIndex()

2005-02-14 Thread Christoph Hermann
Jakob Braeuchi schrieb: Hello, what do you mean by 'crash' ? could you please post the exception. hmm of course, sorry that i forgot this :/ The Exception is: org.apache.cocoon.ProcessingException: Failed to execute pipeline.: java.lang.RuntimeException: java.lang.RuntimeException:

Re: Crash while retrieving Results from a Reportquery and query.setEndAtIndex()

2005-02-14 Thread Christoph Hermann
Antonio Gallardo schrieb: Hello, Line 318): java.util.NoSuchElementException: Could not obtain next object: inner hasNext was false 317: while ( it.hasNext() ) { 318: var o = it.next(); // crashes here 319: suggestions.add(o); 320: } Thanks. This is inside Cocoon Flow.

Need help with (Report-) Query

2005-02-13 Thread Christoph Hermann
Hello, i'm trying to build a simple query with ojb. SELECT menu_links.*,it.cnt FROM menu_links, (SELECT menu_link_id,COUNT(*) AS cnt FROM logs GROUP BY menu_link_id ORDER BY COUNT(*) DESC) AS it WHERE menu_links.id = it.menu_link_id ORDER BY it.cnt DESC; Basically select all Objects from

Re: Update of 1toN relationship

2005-02-09 Thread Christoph Hermann
Nils Liebelt schrieb: Hello, I experience a problem while updating a 1toN relationship: I got a contact object with has n service objects. If I create a new service with a certain contactId (foreign key for contact) and store that object, the addressed contact object does not have the

Re: Sorting Child Objects

2005-02-08 Thread Christoph Hermann
Robert S. Sfeir schrieb: Hello, Steps 1.) and 2.) are imo ok. the sql contains an order by and ArrayList also maintains the order. The problem is in step 3.) how could we warn the user that his list may cause sorting problems ? Yup exactly what I was originally thinking, I do think

Re: Sorting Child Objects

2005-02-08 Thread Christoph Hermann
Robert S. Sfeir schrieb: Hello, I have a similar Problem (i think). When retrieving a Collection for the first time, the order is fine like i want it. When retrieving it a second or third, or ... time i seem to get a random order. My disordering is consistently ordered by record

Re: Sorting Child Objects

2005-02-08 Thread Christoph Hermann
Robert S. Sfeir schrieb: Hello, ObjectCachePerBrokerImpl now its working fine (until i get a problem with that ;-)). You wouldn't be using Spring Framework by any chance? I did that because Spring requires it as well. No, i'm just using Cocoon. Christoph pgpZOXSeilpwA.pgp

Re: Decomposed m:n mapping with ojb and jdo

2005-01-29 Thread Christoph Hermann
Christoph Hermann schrieb: Hello again, The problem seems to lie here: !-- ProfileMenuCategory -- class-descriptor class=papillon.ProfileMenuCategory table=rel_profiles_menu_categories field-descriptor name=profile_id column=profiles_id jdbc-type=INTEGER primarykey=true / field

Re: Decomposed m:n mapping with ojb and jdo

2005-01-29 Thread Christoph Hermann
Thomas Dudziak schrieb: Hello, Both your references use a primarykey part as their foreignkey. Is this really what you want ? The referenced objects must then have the same primarykey value (part) as the ProfileMenuCategory object, and that before you store the ProfileMenutCategory object,

Re: Decomposed m:n mapping with ojb and jdo

2005-01-29 Thread Christoph Hermann
Thomas Dudziak schrieb: Hello, You should not use the primarykey for this. It would be better if you add a simple primarykey field to the ProfileMenuCategory, make the other two fields normal fields, and in the database add a unqiue constraint on these two fields. This way, the database will

Decomposed m:n mapping with ojb and jdo

2005-01-28 Thread Christoph Hermann
Hello, i try to realize an m:n mapping using ojb/jdo and update the java classes with cocoon using cforms. My problem ist, that i don't get the intermediate table to update correctly in the database. I have the following three classes: public class Profile implements Serializable {