Hi all, just a query regarding updating multiple tables in ibatis. For our project we want to be able to keep transparency between the dao code and the actual sql statements. Different records get updated depending on the business unit involved.
Essentially, we want to be able to call one statement that will update multiple tables in the database. Is there any way of doing this in iBatis? The only ways I can thin of is putting all the update statements within one statement but that doesn't work.
<!-- Updates the status information about a request in the database -->
<update id = "updateRequestStatusData" parameterClass = "RequestStatusVO">
parameter40 = #projectNumber:VARCHAR#
request_id = #requestId# and batch_number = 1;
parameter17 = #status:VARCHAR#
request_id = #requestId# and batch_number = 4;
parameter50 = #errorMessage:VARCHAR#
request_id = #requestId# and batch_number = 5;
Is there a way to call a statement that then calls multiple statements.