Index: lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/dao/hibernate/QaContentDAO.java =================================================================== diff -u -rccfd66f1abbfc63cd0ed0a044f89914418d67cd1 -r2e8247175a83c659870f7b42f6b7bca80c2fec23 --- lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/dao/hibernate/QaContentDAO.java (.../QaContentDAO.java) (revision ccfd66f1abbfc63cd0ed0a044f89914418d67cd1) +++ lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/dao/hibernate/QaContentDAO.java (.../QaContentDAO.java) (revision 2e8247175a83c659870f7b42f6b7bca80c2fec23) @@ -73,11 +73,6 @@ this.getHibernateTemplate().save(qa); } - public void UpdateQa(QaContent qa) { - getSessionFactory().getCurrentSession().setFlushMode(FlushMode.AUTO); - this.getHibernateTemplate().update(qa); - } - public void removeAllQaSession(QaContent qaContent) { this.getHibernateTemplate().deleteAll(qaContent.getQaSessions()); } Index: lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/dbupdates/patch20140822.sql =================================================================== diff -u --- lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/dbupdates/patch20140822.sql (revision 0) +++ lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/dbupdates/patch20140822.sql (revision 2e8247175a83c659870f7b42f6b7bca80c2fec23) @@ -0,0 +1,15 @@ +-- Turn off autocommit, so nothing is committed if there is an error +SET AUTOCOMMIT = 0; +SET FOREIGN_KEY_CHECKS=0; +----------------------Put all sql statements below here------------------------- + +-- LDEV-3295 Allow questions having user responses with ratings be deleted +ALTER TABLE tl_laqa11_response_rating DROP FOREIGN KEY FK_tl_laqa11_response_rating_2 ; +ALTER TABLE tl_laqa11_response_rating ADD CONSTRAINT FK_tl_laqa11_response_rating_2 FOREIGN KEY (response_id ) REFERENCES tl_laqa11_usr_resp (response_id) ON DELETE CASCADE ON UPDATE CASCADE; + +----------------------Put all sql statements above here------------------------- + +-- If there were no errors, commit and restore autocommit to on +COMMIT; +SET AUTOCOMMIT = 1; +SET FOREIGN_KEY_CHECKS=1; \ No newline at end of file