_>    public Collection selectMessagesByChannel(long channelId) {
_>        Collection messages = new ArrayList();
_>        try {
_>            Connection conn = DAOFactory.getConnection();
_>            try {
_>                PreparedStatement query = conn.prepareStatement(
_>                        "select ID from jsub_Messages where ChannelID=?");
_>                query.setLong(1, channelId);
_>                ResultSet rs = query.executeQuery();
_>                while(rs.next()) {
_>                    Message message = findByPrimaryKey(rs.getLong("ID"));
_>                    messages.add(message);
_>                }
_>                rs.close();
_>                query.close();
_>            } finally {
_>                conn.close();
_>            }
_>        } catch(Exception e) {
_>            Log.error("Couldn't select messages by channel \"" + channelId + "\"", e);
_>        }        
_>        return messages;
_>    }
_>