Index: lams_tool_forum/.classpath
===================================================================
diff -u -r62402371ee899b9b20c61c988149efbec1cc00bd -rf2dc26e95cad64b7d5c55b483a0fbb32691d7f13
--- lams_tool_forum/.classpath (.../.classpath) (revision 62402371ee899b9b20c61c988149efbec1cc00bd)
+++ lams_tool_forum/.classpath (.../.classpath) (revision f2dc26e95cad64b7d5c55b483a0fbb32691d7f13)
@@ -4,7 +4,7 @@
-
+
Index: lams_tool_forum/src/java/org/lamsfoundation/lams/tool/forum/persistence/MessageDao.java
===================================================================
diff -u -re3a49cfedf88904e13c5286d6d70f169f5930a50 -rf2dc26e95cad64b7d5c55b483a0fbb32691d7f13
--- lams_tool_forum/src/java/org/lamsfoundation/lams/tool/forum/persistence/MessageDao.java (.../MessageDao.java) (revision e3a49cfedf88904e13c5286d6d70f169f5930a50)
+++ lams_tool_forum/src/java/org/lamsfoundation/lams/tool/forum/persistence/MessageDao.java (.../MessageDao.java) (revision f2dc26e95cad64b7d5c55b483a0fbb32691d7f13)
@@ -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) {