[jira] Commented: (IBATIS-155) Dependencies for statements in sql-Maps

["S Boyd (JIRA)" <ib...@incubator.apache.org>]

    [ http://issues.apache.org/jira/browse/IBATIS-155?page=comments#action_12329851 ] 

S Boyd commented on IBATIS-155:
-------------------------------

I think this is a valid request especially in the case where saving an object requires updates to association tables.  For example, updating a group may require adding/removing users from the group_user table.  I think it would be cleaner to issue one dao call from the service layer update("updateGroup",groupObj) which calls the appropriate sqlmaps instead of issuing three calls to the dao (1 to update the group, 1 to add user, and 1 to delete users).  The latter requires the service layer to "know" to some extent how the database is structured.  Therefore, I think the former way hides that implementation detail.

I don't believe stored procedures solve this problem mentioned because you have variable length arguments passed in every time.  



> Dependencies for statements in sql-Maps
> ---------------------------------------
>
>          Key: IBATIS-155
>          URL: http://issues.apache.org/jira/browse/IBATIS-155
>      Project: iBatis for Java
>         Type: New Feature
>   Components: SQL Maps
>  Environment: all
>     Reporter: Steffen Legler
>     Priority: Minor

>
> i am using ibatis with ~120 sql-Maps.
> When a java object arrives, the software should call in most cases a select and update statement. This works fine.
> But there are other cases, where the software should call for example an insert statement before calling an update-statetement.
> I think it would be useful, if there is an attribute like depends added to the xml-tags statement, insert, update, delete, so that ibatis automatically executes the insert statement when calling the update-statement. 
> For example:
> 	<insert id="insert" parameterClass="class1">
> 		insert into....
> 	</insert>
>   	<update id="update" parameterClass="class1" depends="insert">
> 		update ...
> 	</update>
> Java-execute:
>     sqlMapClient.update("namespace:update",class1);
> In this case the software tries to execute the statement "namespace:update" and ibatis executes two statements:
>   namespace:insert
>   namespace.update
> The advantage of this solution is, that you are not depending on the support of multiple sql-Statements from the jdbc-driver.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira