Index: lams_tool_lamc/src/java/org/lamsfoundation/lams/tool/mc/dao/hibernate/McUserDAO.java =================================================================== diff -u -r2f109d895db6c4a6c3852b9f222d5dd40e76ea87 -r5b4d6726478b83139419062ad3e880e225424046 --- lams_tool_lamc/src/java/org/lamsfoundation/lams/tool/mc/dao/hibernate/McUserDAO.java (.../McUserDAO.java) (revision 2f109d895db6c4a6c3852b9f222d5dd40e76ea87) +++ lams_tool_lamc/src/java/org/lamsfoundation/lams/tool/mc/dao/hibernate/McUserDAO.java (.../McUserDAO.java) (revision 5b4d6726478b83139419062ad3e880e225424046) @@ -40,6 +40,8 @@ private static final String COUNT_USERS_IN_SESSION = "select mu.queUsrId from McQueUsr mu where mu.mcSession= :mcSession"; + private static final String COUNT_USERS = "select mu.queUsrId from McQueUsr"; + private static final String LOAD_USER_FOR_SESSION = "from mcQueUsr in class McQueUsr where mcQueUsr.mcSessionId= :mcSessionId"; @@ -143,4 +145,10 @@ mcSession)).size(); } + + public int getTotalNumberOfUsers() { + String query="from obj in class McQueUsr"; + return this.getHibernateTemplate().find(query).size(); + } + }