Index: lams_tool_chat/src/java/org/lamsfoundation/lams/tool/chat/dao/IChatSessionDAO.java
===================================================================
RCS file: /usr/local/cvsroot/lams_tool_chat/src/java/org/lamsfoundation/lams/tool/chat/dao/IChatSessionDAO.java,v
diff -u -r1.5 -r1.6
--- lams_tool_chat/src/java/org/lamsfoundation/lams/tool/chat/dao/IChatSessionDAO.java	20 Apr 2006 03:27:43 -0000	1.5
+++ lams_tool_chat/src/java/org/lamsfoundation/lams/tool/chat/dao/IChatSessionDAO.java	23 May 2006 04:12:21 -0000	1.6
@@ -36,4 +36,6 @@
 	void saveOrUpdate(ChatSession session);
 
 	ChatSession getBySessionId(Long toolSessionId);
+	
+	ChatSession getByJabberRoom(String jabberRoom);
 }
Index: lams_tool_chat/src/java/org/lamsfoundation/lams/tool/chat/dao/hibernate/ChatSessionDAO.java
===================================================================
RCS file: /usr/local/cvsroot/lams_tool_chat/src/java/org/lamsfoundation/lams/tool/chat/dao/hibernate/ChatSessionDAO.java,v
diff -u -r1.5 -r1.6
--- lams_tool_chat/src/java/org/lamsfoundation/lams/tool/chat/dao/hibernate/ChatSessionDAO.java	20 Apr 2006 03:27:43 -0000	1.5
+++ lams_tool_chat/src/java/org/lamsfoundation/lams/tool/chat/dao/hibernate/ChatSessionDAO.java	23 May 2006 04:12:21 -0000	1.6
@@ -37,6 +37,8 @@
 
 	public static final String SQL_QUERY_FIND_BY_SESSION_ID = "from "
 			+ ChatSession.class.getName() + " where session_id=?";
+	public static final String SQL_QUERY_FIND_BY_JABBER_ROOM = "from " 
+			+ ChatSession.class.getName() + " where jabber_room=?";
 
 	public void saveOrUpdate(ChatSession session) {
 		this.getHibernateTemplate().saveOrUpdate(session);
@@ -50,4 +52,12 @@
 			return null;
 		return (ChatSession) list.get(0);
 	}
+
+	public ChatSession getByJabberRoom(String jabberRoom) {
+		List list = this.getHibernateTemplate().find(
+				SQL_QUERY_FIND_BY_JABBER_ROOM, jabberRoom);
+		if (list == null || list.isEmpty())
+			return null;
+		return (ChatSession) list.get(0);
+	}
 }