Not sure how you are going to avoid writing 10 different sql statements....
and now you have some sql based in two different places (.java and .xml).
I think you are over thinking this and would have already been done if you
just placed the 10 delete statements in your sqlmap files :)
of course this is just my opinion
Nathan
On 10/16/07, Navanee <[EMAIL PROTECTED]> wrote:
>
>
> Hi
>
> Is there a way to pass dynamic Query values to delete statement. like
> below
>
> <delete id="trimTable" parameterClass="String" >
> $value$
> </delete>
>
> In my case, I need to delete some ten tables, But I want to have only one
> delete sql map statement like above instead of having ten different SQL
> statement,
>
> I'll pass the $value$ as below for all tables,
>
> String dynamicQuery = "DELETE FROM TABLE1 WHERE NAME = 'TEST'";
> sqlMapper.delete("trimTable",dynamicQuery);
>
> I wrote a sample code to achive the above, but during execution the code
> hangs and does not come out of it, when there is a valid data to delete,
> But
> finishes it execution where there is no data in the table.
>
> What might cause the above issue, is there any workaround/solution for
> this...
>
> Could someone please share/provide solution on this?
>
> Thanks and Regards,
> Navanee
> --
> View this message in context:
> http://www.nabble.com/How-to-achieve-Dynamic-SQL-query-in-delete-statement-tf4634689.html#a13235168
> Sent from the iBATIS - User - Java mailing list archive at Nabble.com.
>
>
