125,7 → 125,8 |
{ |
try { |
List list = HibernateUtil.currentSession().find( |
"from MailAlias where name=?", name, Hibernate.STRING); |
"select a from MailAlias a left join fetch a.domain" |
+ " left join fetch a.owner where a.name=?", name, Hibernate.STRING); |
|
if(list.size() == 0) |
return null; |
275,8 → 276,11 |
{ |
try { |
if(editor.isSuperuser()) |
return HibernateUtil.currentSession().find("from MailAlias"); |
return HibernateUtil.currentSession().find( |
"select a from MailAlias a left join fetch a.domain as d" |
+ " left join fetch a.owner"); |
else |
// FIXME: any problems for big lists or by pages? |
return CollectionUtils.addUnique( |
HibernateUtil.currentSession().find( |
"select a from MailAlias a left join fetch a.domain as d" |
326,7 → 330,7 |
|
try { |
mailAliases = HibernateUtil.currentSession().find( |
"from MailAlias where owner = ?", |
"select a from MailAlias a left join fetch a.domain where a.owner = ?", |
user, Hibernate.entity(User.class) ); |
} |
catch(HibernateException ex) |
344,7 → 348,7 |
|
try { |
mailAliases = HibernateUtil.currentSession().find( |
"from MailAlias where owner = ?", |
"select a from MailAlias a left join fetch a.domain where a.owner = ?", |
user, Hibernate.entity(User.class) ); |
} |
catch(HibernateException ex) |
364,7 → 368,7 |
|
try { |
mailAliases = HibernateUtil.currentSession().find( |
"from MailAlias where domain = ?", |
"select a from MailAlias a left join fetch a.owner where a.domain = ?", |
domain, Hibernate.entity(InetDomain.class) ); |
} |
catch(HibernateException ex) |
382,7 → 386,7 |
|
try { |
mailAliases = HibernateUtil.currentSession().find( |
"from MailAlias where domain = ?", |
"select a from MailAlias a left join fetch a.owner where a.domain = ?", |
domain, Hibernate.entity(InetDomain.class) ); |
} |
catch(HibernateException ex) |