Index: lams_tool_assessment/src/java/org/lamsfoundation/lams/tool/assessment/dao/hibernate/AssessmentQuestionResultDAOHibernate.java =================================================================== diff -u -rceb74e3b4097cf6461280448f904fa21a176aaa4 -r70d1adeee6d96136e69aa91bb50d94c4a3b826d2 --- lams_tool_assessment/src/java/org/lamsfoundation/lams/tool/assessment/dao/hibernate/AssessmentQuestionResultDAOHibernate.java (.../AssessmentQuestionResultDAOHibernate.java) (revision ceb74e3b4097cf6461280448f904fa21a176aaa4) +++ lams_tool_assessment/src/java/org/lamsfoundation/lams/tool/assessment/dao/hibernate/AssessmentQuestionResultDAOHibernate.java (.../AssessmentQuestionResultDAOHibernate.java) (revision 70d1adeee6d96136e69aa91bb50d94c4a3b826d2) @@ -48,7 +48,7 @@ private static final String GET_ANSWER_MARK = "SELECT q.mark FROM " + AssessmentQuestionResult.class.getName() + " AS q, " + AssessmentResult.class.getName() + " AS r " - + " WHERE q.assessmentResult.uid = r.uid AND r.assessment.uid = ? AND (r.finishDate != null) AND r.user.userId =? AND q.assessmentQuestion.sequenceId =? ORDER BY r.startDate DESC"; + + " WHERE q.assessmentResult.uid = r.uid AND r.assessment.uid = :assessmentUid AND (r.finishDate != null) AND r.user.userId =:userId AND q.assessmentQuestion.sequenceId =:questionSequenceId ORDER BY r.startDate DESC"; @Override public int getNumberWrongAnswersDoneBefore(Long assessmentUid, Long userId, Long questionUid) { @@ -79,9 +79,9 @@ @Override public Float getQuestionResultMark(Long assessmentUid, Long userId, int questionSequenceId) { Query q = getSession().createQuery(GET_ANSWER_MARK); - q.setParameter(0, assessmentUid); - q.setParameter(1, userId); - q.setParameter(2, questionSequenceId); + q.setParameter("assessmentUid", assessmentUid); + q.setParameter("userId", userId); + q.setParameter("questionSequenceId", questionSequenceId); q.setMaxResults(1); Object result = q.uniqueResult(); return result != null ? ((Number) result).floatValue() : null; Index: lams_tool_lamc/src/java/org/lamsfoundation/lams/tool/mc/dao/hibernate/McContentDAO.java =================================================================== diff -u -r8846e87b362ce07b580e3750128c5826e667f7e5 -r70d1adeee6d96136e69aa91bb50d94c4a3b826d2 --- lams_tool_lamc/src/java/org/lamsfoundation/lams/tool/mc/dao/hibernate/McContentDAO.java (.../McContentDAO.java) (revision 8846e87b362ce07b580e3750128c5826e667f7e5) +++ lams_tool_lamc/src/java/org/lamsfoundation/lams/tool/mc/dao/hibernate/McContentDAO.java (.../McContentDAO.java) (revision 70d1adeee6d96136e69aa91bb50d94c4a3b826d2) @@ -79,7 +79,7 @@ public void removeMcById(Long mcContentId) { if (mcContentId != null) { List list = getSessionFactory().getCurrentSession().createQuery(FIND_MC_CONTENT) - .setParameter(0, mcContentId.longValue()).list(); + .setParameter("mcContentId", mcContentId.longValue()).list(); if (list != null && list.size() > 0) { McContent mc = (McContent) list.get(0); Index: lams_tool_wiki/src/java/org/lamsfoundation/lams/tool/wiki/dao/hibernate/WikiPageDAO.java =================================================================== diff -u -rceb74e3b4097cf6461280448f904fa21a176aaa4 -r70d1adeee6d96136e69aa91bb50d94c4a3b826d2 --- lams_tool_wiki/src/java/org/lamsfoundation/lams/tool/wiki/dao/hibernate/WikiPageDAO.java (.../WikiPageDAO.java) (revision ceb74e3b4097cf6461280448f904fa21a176aaa4) +++ lams_tool_wiki/src/java/org/lamsfoundation/lams/tool/wiki/dao/hibernate/WikiPageDAO.java (.../WikiPageDAO.java) (revision 70d1adeee6d96136e69aa91bb50d94c4a3b826d2) @@ -14,7 +14,7 @@ public class WikiPageDAO extends LAMSBaseDAO implements IWikiPageDAO { public static final String GET_BY_WIKI_AND_TITLE = "from tl_lawiki10_wiki_page in class " + WikiPage.class.getName() - + " where wiki_uid=? AND title=? AND wiki_session_uid=null"; + + " where wiki_uid=:wikiId AND title=:title AND wiki_session_uid=null"; public static final String GET_BY_SESSION_AND_TITLE = "from tl_lawiki10_wiki_page in class " + WikiPage.class.getName() + " where wiki_session_uid=:wikiId AND title=:title"; @@ -35,8 +35,8 @@ if (wiki != null && title != null && title.length() > 0) { Long wikiId = wiki.getUid(); Query query = getSessionFactory().getCurrentSession().createQuery(GET_BY_WIKI_AND_TITLE); - query.setParameter(0, wikiId); - query.setParameter(1, title); + query.setParameter("wikiId", wikiId); + query.setParameter("title", title); return (WikiPage) query.uniqueResult(); } return null;