I think you've listed your own solution. The hanging may be a db issue,
meaning the time it takes for the query to execute/number of rows it
takes to process. How long does it take the query to run outside of
iBatis (when running directly on the db)?
Navanee 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
