Index: lams_tool_forum/.classpath =================================================================== RCS file: /usr/local/cvsroot/lams_tool_forum/.classpath,v diff -u -r1.6 -r1.7 --- lams_tool_forum/.classpath 2 Dec 2005 04:58:00 -0000 1.6 +++ lams_tool_forum/.classpath 7 Dec 2005 04:00:24 -0000 1.7 @@ -4,7 +4,7 @@ - + Index: lams_tool_forum/src/java/org/lamsfoundation/lams/tool/forum/persistence/MessageDao.java =================================================================== RCS file: /usr/local/cvsroot/lams_tool_forum/src/java/org/lamsfoundation/lams/tool/forum/persistence/MessageDao.java,v diff -u -r1.13 -r1.14 --- lams_tool_forum/src/java/org/lamsfoundation/lams/tool/forum/persistence/MessageDao.java 5 Dec 2005 03:53:48 -0000 1.13 +++ lams_tool_forum/src/java/org/lamsfoundation/lams/tool/forum/persistence/MessageDao.java 7 Dec 2005 04:00:24 -0000 1.14 @@ -14,8 +14,8 @@ * @author conradb */ public class MessageDao extends HibernateDaoSupport { - private static final String SQL_QUERY_FIND_ROOT_TOPICS = "from " + Message.class.getName() - + " where parent_uid is null and forum_session_uid=?"; + private static final String SQL_QUERY_FIND_ROOT_TOPICS = "from " + Message.class.getName() +" m " + + " where parent_uid is null and m.toolSession.sessionId=?"; private static final String SQL_QUERY_FIND_TOPICS_FROM_AUTHOR = "from " + Message.class.getName() + " where is_authored = true and forum_uid=?"; @@ -24,7 +24,7 @@ + " where parent=?"; private static final String SQL_QUERY_BY_USER_SESSION = "from " + Message.class.getName() + " m " - + " where m.createdBy.uid = ? and m.toolSession.uid=?"; + + " where m.createdBy.uid = ? and m.toolSession.sessionId=?"; private static final String SQL_QUERY_BY_SESSION = "from " + Message.class.getName() + " m " + " where m.toolSession.sessionId=?"; @@ -70,8 +70,8 @@ public List getRootTopics(Long sessionId) { return this.getHibernateTemplate().find(SQL_QUERY_FIND_ROOT_TOPICS, sessionId); } - public List getTopicsFromAuthor(Long forumId) { - return this.getHibernateTemplate().find(SQL_QUERY_FIND_TOPICS_FROM_AUTHOR, forumId); + public List getTopicsFromAuthor(Long forumUid) { + return this.getHibernateTemplate().find(SQL_QUERY_FIND_TOPICS_FROM_AUTHOR, forumUid); } public void deleteById(Long uid) {