getting results for multiple delete statements (mybatis-guice)

166 views
Skip to first unread message

Stephen Friedrich

unread,
Apr 19, 2012, 10:36:22 AM4/19/12
to mybati...@googlegroups.com
Using MySQL and connection parameter allowMultiQueries=true, I can issue these statements using a single DB roundtrip:
    <delete id="deleteTask">
        delete from task_status_history where task_id = #{id};
        delete from tree_views where ref_id = #{id};
        delete from tasks where id = #{id} and version_no = 0;
    </delete>
Now how the heck can I access the three individual delete counts?

I am using mybatis-guice.

Larry Meadors

unread,
Apr 19, 2012, 10:41:44 AM4/19/12
to mybati...@googlegroups.com
Use a stored procedure.
Reply all
Reply to author
Forward
0 new messages