Re: [appfuse-user] Is there a declarative way to sort the results of a join collection?

[Bryan Noll]

Section 9.1.28 of the 'ejb-3_0-fr-spec-persistence.pdf' doc available 
here:  http://jcp.org/en/jsr/detail?id=220


Bryan Noll wrote:
Check out the @OrderBy annotation.



romsrini wrote:
I guess what I'm really asking is if there is a way to do the sort in 
the
database for a collection returned from a join.
For example, given the following code snippet from 
org.appfuse.model.User:

@ManyToMany(fetch = FetchType.EAGER)     @JoinTable(
            name="user_role",
            joinColumns = { @JoinColumn( name="user_id") },
            inverseJoinColumns = @JoinColumn( name="role_id")
    )        public Set<Role> getRoles() {
        return roles;
    }



Is there a declarative way to sort the roles? I know I can make the 
result
be a List and then sort the List in memory in Java, but I was hoping 
there
was a way to do it in the database using the appfuse framework.

Thanks,
Rom
  


---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]