Index: lams_tool_forum/src/java/org/lamsfoundation/lams/tool/forum/persistence/MessageDao.java =================================================================== diff -u -r33a3ed3f118b3e599ed6ef024c1b92a6f94225b1 -r7fe03c68127a8cb4fca2f8e95b14ab673eb30a86 --- lams_tool_forum/src/java/org/lamsfoundation/lams/tool/forum/persistence/MessageDao.java (.../MessageDao.java) (revision 33a3ed3f118b3e599ed6ef024c1b92a6f94225b1) +++ lams_tool_forum/src/java/org/lamsfoundation/lams/tool/forum/persistence/MessageDao.java (.../MessageDao.java) (revision 7fe03c68127a8cb4fca2f8e95b14ab673eb30a86) @@ -126,14 +126,14 @@ public int getTopicsNum(Long userID, Long sessionId) { List list = this.getHibernateTemplate().find(SQL_QUERY_TOPICS_NUMBER_BY_USER_SESSION,new Object[]{userID,sessionId}); if(list != null && list.size() > 0) - return ((Integer)list.get(0)).intValue(); + return ((Number)list.get(0)).intValue(); else return 0; } public boolean hasAuthoredTopics(Long sessionId) { List list = this.getHibernateTemplate().find(SQL_QUERY_COUNT_SESSION_TOPICS_FROM_AUTHOR,new Object[]{sessionId}); if(list != null && list.size() > 0) - return ((Integer)list.get(0)).intValue() > 0 ? true:false; + return ((Number)list.get(0)).longValue() > 0 ? true:false; else return false; } Index: lams_tool_larsrc/src/java/org/lamsfoundation/lams/tool/rsrc/dao/hibernate/ResourceItemVisitDAOHibernate.java =================================================================== diff -u -r6f9ce8030c9939df344a3aa7f5894116491a90d8 -r7fe03c68127a8cb4fca2f8e95b14ab673eb30a86 --- lams_tool_larsrc/src/java/org/lamsfoundation/lams/tool/rsrc/dao/hibernate/ResourceItemVisitDAOHibernate.java (.../ResourceItemVisitDAOHibernate.java) (revision 6f9ce8030c9939df344a3aa7f5894116491a90d8) +++ lams_tool_larsrc/src/java/org/lamsfoundation/lams/tool/rsrc/dao/hibernate/ResourceItemVisitDAOHibernate.java (.../ResourceItemVisitDAOHibernate.java) (revision 7fe03c68127a8cb4fca2f8e95b14ab673eb30a86) @@ -67,15 +67,18 @@ List list = getHibernateTemplate().find(FIND_VIEW_COUNT_BY_USER,new Object[]{toolSessionId, userUid}); if(list == null || list.size() ==0) return 0; - return ((Integer) list.get(0)).intValue(); + return ((Number) list.get(0)).intValue(); } public Map getSummary(Long contentId) { - + + // Note: Hibernate 3.1 query.uniqueResult() returns Integer, Hibernate 3.2 query.uniqueResult() returns Long List result = getHibernateTemplate().find(FIND_SUMMARY,contentId); Map summaryList = new HashMap (result.size()); for(Object[] list : result){ - summaryList.put((Long)list[0],(Integer)list[1]); + if ( list[1] != null ) { + summaryList.put((Long)list[0],new Integer(((Number)list[1]).intValue())); + } } return summaryList;