Problem with OUTER JOIN hibernate

[Mike Halford]

Hi,
I have two classes - abbreviated for clarity.

1:

@Entity
@Table(name = "category")
public class Category extends BaseEntity<Integer> implements Serializable {

  private static final long serialVersionUID = 1L;

  private Integer id;

  private String name;

  
  
  private List<Progress> progress;

  @Override
  @Id
  @Column(name = "id", precision = 11)
  public Integer getId() {
    return id;
  }

  @Override
  public void setId(Integer id) {
    this.id = id;
  }
  
  @OneToMany(cascade=CascadeType.ALL)
  @JoinColumn(name="category",nullable=true)
  public List<Progress> getProgress() {
    return progress;
  }

  public void setProgress(List<Progress> progress) {
    this.progress = progress;
  }

   @Column(length = 40)
  public String getName() {
    return name;
  }

  public void setName(String name) {
    this.name = name;
  }

 }
    

2:

 @Entity
@Table(name = "progress")
public class Progress extends BaseEntity<ProgressPk> implements Serializable {

  private static final long serialVersionUID = 1L;

  private ProgressPk id;


  private Category category;

  @Override
  @Id
  public ProgressPk getId() {
    return id;
  }

  @Override
  public void setId(ProgressPk id) {
    this.id = id;
  }

   
  @ManyToOne
  @JoinColumn(name = "category",insertable=false, updatable=false)
  public Category getCategory() {
    return category;
  }

  public void setCategory(Category category) {
    this.category = category;
  }

  

  

There are 5 different categories in the categories table and I'm trying to use an outer join to get me the number of times each category occurs in the progress table; e.g.
Error Category A 16839
Error Category B 22871
Error Category C 10
Invalid Entity 6706
No Error 201186

This query is working fine..

select  c.name, count(p.category) from  Category  c  left join  c.progress as p group by c.name   

EXCEPT that if there are no occurences of a Category in the Progress table
I would like to see Error Category C 0 for example. The trouble is that in such a case the output is:
Error Category A 16839
Error Category B 22871
Invalid Entity 6706
No Error 201186

i.e no count for Error Category C 0.
In good ol' SQL the outer join works fine, but HQL doesn't seem to return null rows. Is this just a feature of HQL or am I doing something wrong???