| 134,7 → 134,7 |
|---|
| try { |
| List list = HibernateUtil.currentSession().find( |
| "select mb from Mailbox mb left join fetch mb.domain as d" |
| + " left join fetch mb.owner left join fetch mb.systemUser where mb.login=?", |
| + " left join fetch mb.owner where mb.login=?", |
| login, Hibernate.STRING); |
| |
| if(list.size() == 0) |
| 287,18 → 287,18 |
|---|
| if(editor.isSuperuser()) |
| return HibernateUtil.currentSession().find( |
| "select mb from Mailbox mb left join fetch mb.domain as d" |
| + " left join fetch mb.owner left join fetch mb.systemUser"); |
| + " left join fetch mb.owner"); |
| else |
| // FIXME: any problems for big lists or by pages? |
| return CollectionUtils.addUnique( |
| HibernateUtil.currentSession().find( |
| "select mb from Mailbox mb left join fetch mb.domain as d" |
| + " left join fetch mb.owner left join fetch mb.systemUser" |
| + " left join fetch mb.owner" |
| + " where mb.owner=?", |
| new Object[] { editor }, new Type[] { Hibernate.entity(User.class) } ), |
| HibernateUtil.currentSession().find( |
| " select mb from Mailbox mb left join fetch mb.domain as d" |
| + " left join fetch mb.owner left join fetch mb.systemUser" |
| + " left join fetch mb.owner" |
| + " where d.owner=?", |
| new Object[] { editor }, new Type[] { Hibernate.entity(User.class) } )); |
| } |
| 339,8 → 339,7 |
|---|
| |
| try { |
| mailboxes = HibernateUtil.currentSession().find( |
| "select mb from Mailbox mb left join fetch mb.domain" |
| + " left join fetch mb.systemUser where mb.owner = ?", |
| "select mb from Mailbox mb left join fetch mb.domain where mb.owner = ?", |
| user, Hibernate.entity(User.class) ); |
| } |
| catch(HibernateException ex) |
| 358,8 → 357,7 |
|---|
| |
| try { |
| mailboxes = HibernateUtil.currentSession().find( |
| "select mb from Mailbox mb left join fetch mb.domain" |
| + " left join fetch mb.systemUser where mb.owner = ?", |
| "select mb from Mailbox mb left join fetch mb.domain where mb.owner = ?", |
| user, Hibernate.entity(User.class) ); |
| } |
| catch(HibernateException ex) |
| 379,8 → 377,7 |
|---|
| |
| try { |
| mailboxes = HibernateUtil.currentSession().find( |
| "select mb from Mailbox mb left join fetch mb.owner" |
| + " left join fetch mb.systemUser where mb.domain = ?", |
| "select mb from Mailbox mb left join fetch mb.owner where mb.domain = ?", |
| domain, Hibernate.entity(InetDomain.class) ); |
| } |
| catch(HibernateException ex) |
| 398,8 → 395,7 |
|---|
| |
| try { |
| mailboxes = HibernateUtil.currentSession().find( |
| "select mb from Mailbox mb left join fetch mb.owner" |
| + " left join fetch mb.systemUser where mb.domain = ?", |
| "select mb from Mailbox mb left join fetch mb.owner where mb.domain = ?", |
| domain, Hibernate.entity(InetDomain.class) ); |
| } |
| catch(HibernateException ex) |
| 419,7 → 415,7 |
|---|
| |
| try { |
| mailboxes = HibernateUtil.currentSession().find( |
| "select mb from Mailbox mb left join fetch mb.domain" |
| "select mb from Mailbox mb left join fetch mb.domain as d" |
| + " left join fetch mb.owner where mb.systemUser = ?", |
| user, Hibernate.entity(SystemUser.class) ); |
| } |
| 438,7 → 434,7 |
|---|
| |
| try { |
| mailboxes = HibernateUtil.currentSession().find( |
| "select mb from Mailbox mb left join fetch mb.domain" |
| "select mb from Mailbox mb left join fetch mb.domain as d" |
| + " left join fetch mb.owner where mb.systemUser = ?", |
| user, Hibernate.entity(SystemUser.class) ); |
| } |