Re: Newbie question about to-many ordered list

From: Andrus Adamchik (andru..bjectstyle.org)
Date: Tue May 06 2008 - 03:59:23 EDT

  • Next message: Daniel Doppmeier: "many-to-many mapping resulting in incomplete SQL queries"

    As a side note pre-ordered relationships have been on our TODO list
    for some time. Since it is a JPA feature, it is higher priority now.

    Andrus

    On May 6, 2008, at 10:52 AM, Malcolm Edgar wrote:

    > I tend to do this:
    >
    > public List<Customer> getCustomers() {
    > List<Customers> customers = super.getCustomers();
    >
    > Collections.sort(customers, new
    > StringComparator(Customer.NAME_PROPERTY));
    >
    > return customers;
    > }
    >
    > regards Malcolm Edgar
    >
    > On Tue, May 6, 2008 at 4:58 PM, Aristedes Maniatis <ar..sh.com.au>
    > wrote:
    >
    >>
    >> On 06/05/2008, at 11:30 AM, JGL wrote:
    >>
    >> Hi All,
    >>>
    >>> I recently discovered Cayenne while searching for an alternative for
    >>> Hibernate.
    >>> I am very impressed with the easy & intuitive framework Cayenne
    >>> provides.
    >>>
    >>> While porting my current Hibernate app to Cayenne, I did run into an
    >>> issue
    >>> which I'd like to seek your help:
    >>> In Hibernate, the M side of 1-M relationship can be mapped as a
    >>> list,
    >>> which
    >>> means it's ordered. I can specify the list-index column like this:
    >>>
    >>> <class name="Item" table="ITEM">
    >>> ...
    >>> <list name="bids">
    >>> <key column="ITEM_ID" not-null="true"/>
    >>> <list-index column="BID_POSITION"/>
    >>> <one-to-many class="Bid"/>
    >>> </list>
    >>> </class>
    >>>
    >>> and the BID_POSITION is automatically managed by the framework.
    >>>
    >>> Is there any 'list index column' equivalent in Cayenne? How can I
    >>> ask
    >>> the
    >>> framework to manage the list index ? or do I have to manage it by
    >>> myself?
    >>>
    >>> Thanks very much!!
    >>>
    >>
    >>
    >> Well, you can order the results easily enough once you fetch them
    >> into a
    >> list:
    >>
    >> http://cayenne.apache.org/doc/using-orderings.html
    >>
    >> In Cayenne 3 you can also fetch the results into a Map if that
    >> helps what
    >> you are trying to do.
    >>
    >>
    >> Ari Maniatis
    >>
    >>
    >>
    >> -------------------------->
    >> ish
    >> http://www.ish.com.au
    >> Level 1, 30 Wilson Street Newtown 2042 Australia
    >> phone +61 2 9550 5001 fax +61 2 9550 4001
    >> GPG fingerprint CBFB 84B4 738D 4E87 5E5C 5EFA EF6A 7D2E 3E49 102A
    >>
    >>
    >>



    This archive was generated by hypermail 2.0.0 : Tue May 06 2008 - 03:59:58 EDT