| 178,12 → 178,18 |
|---|
| throws ModelStoreException |
| { |
| try { |
| return ((Integer)HibernateUtil.currentSession().iterate( |
| "select count(*) from MailAlias a left join a.domain as d" |
| + " where d.owner=? or a.owner=?", |
| new Object[] { user, user }, |
| new Type[] { Hibernate.entity(User.class), Hibernate.entity(User.class) }) |
| .next()).intValue(); |
| List countlist = HibernateUtil.sqlQuery( |
| "select count(*) from (" |
| + " select a.id from mailaliases a" |
| + " where a.owner=?" |
| + " union" |
| + " select a.id from mailaliases a" |
| + " left join domains as d on a.domain = d.id" |
| + " where d.owner=?" |
| + ") as count_table", |
| new Object[] { user.getId(), user.getId() }); |
| |
| return ((Long)countlist.get(0)).intValue(); |
| } |
| catch(HibernateException ex) |
| { |