I keep getting this error.
How do I solve this problem?
Error:
java.sql.SQLSyntaxErrorException: ORA-00933: SQL command not properly ended
Code:
<update id="updateProc" parameterClass="rating">
update rating set
rating_title=#rating_title#
rating_cont=#rating_cont#
where mem_id=#mem_id#
and rating_code=#rating_code#
</update>
Please put ,
between your columns of Set
Clause like:
update rating set rating_title=#rating_title#, rating_cont=#rating_cont#
where mem_id=#mem_id# and rating_code=#rating_code#