find.all sort oneTomany in Ebean

Question

I'm following How can I sort related entities in Ebean? but i got this error

 RuntimeException: Can not find Master [class models.Card] 
 in Child[models.FinalMark]

Is the solution forgot to put this? Even with ID stil not working.

@Id
public Integer id;

I think my case quite similar.

@Entity
public class Club extends Model {
    @Id
    public Long id;
    public String name;

    @OneToMany(cascade = CascadeType.ALL)
    @OrderBy("name asc")
    public List<Male> male = new ArrayList<>();

    @OneToMany(cascade = CascadeType.ALL)
    @OrderBy("name asc")
    public List<Female> female = new ArrayList<>();

    private static Finder<Long, Club> find = 
    new Finder<>(Long.class, Club.class);
}

@Entity
public class Male extends Model {
  @Id
  public Long id;
  public String name;
  private static Finder<Long, Male> find = new Finder<>(Long.class, Male.class);
}

@Entity
public class Female extends Model {
  @Id
  public Long id;
  @ManyToOne
  public Club club;
  public String name;
  private static Finder<Long, Female> find = new Finder<>(Long.class, Female.class);
}

I've intial data

male:
- !!models.Male &m1
    name:           "Martin"

- !!models.Male &m2
    name:           "Alan"

female:
- !!models.Female &f1
    name:           "June"

- !!models.Female &f2
    name:           "Babe"


club:
- !!models.Club
    name:           "BigClub"
    male:
    - *m1
    - *m2
    female:
    - *f1
    - *f2

during initialization.

    Map<String, List<Object>> all = (Map<String, List<Object>>) Yaml
                    .load("initial-data.yml");

   // Insert club
   Ebean.save(all.get("club"));

when i call Club.find.all(), the male and female fields still not sort in ascending. I've tried 2 different ways (each in male & female). both also not sort in asc. any idea?

do you have any other models? since ebean is trying to find model card class which isn't there — Seroney, Sep 18 '15 at 06:33
What's Person.class? Your finder in the Club class is referring to Person.class — Atif, Sep 18 '15 at 08:45
@Seroney, It was referring to the solution in my first statement (please refer to the hyperlink) — keepscoding, Sep 18 '15 at 13:39
@Atif, naming error and corrected. example here has changed the actual name for better illustration. — keepscoding, Sep 18 '15 at 13:40

score 0 · Answer 1 · answered Sep 18 '15 at 18:10

0

You need to specify the "path" of the related object when you are configuring the order-by like so:

@OneToMany(cascade = CascadeType.ALL)
@OrderBy("male.name asc")
public List<Male> male = new ArrayList<>();

@OneToMany(cascade = CascadeType.ALL)
@OrderBy("female.name asc")
public List<Female> female = new ArrayList<>();

Otherwise, it thinks that you're referring to "name" field of the current class.

answered Sep 18 '15 at 18:10

Atif

942
1
6
19

sorry, i should mentioned i'm using old ebean. After ported, the latest play-ebean in 2.4. it is working with "id asc". your suggestion is not working. Anyway, thanks. – keepscoding Sep 21 '15 at 10:02

find.all sort oneTomany in Ebean

1 Answers1