I wanted to share some info with the group regarding comments embedded in statements in the XML files. I found the following does not work:
1. SQL Server comments (e.g. "--") interleaved with SQL text. This one should have been obvious to me in retrospect <sigh>. <delete id="deletesomething"> -- Delete children delete from thattable where thisid = #value# -- Delete parent delete from thistable where thisid = #value# </delete> The reason is that new lines are removed so you end up with this SQL command: "-- Delete children delete from thattable where thisid = @value -- Delete parent delete from thistable where thisid = @value" which is obviously just one long comment. 2. Interleaved XML comments: <delete id="deletesomething"> <!-- Delete children --> delete from thattable where thisid = #value# <!-- Delete parent --> delete from thistable where thisid = #value# </delete> This doesn't work because newlines are removed and the statements are concatenated without any whitespace in between: "delete from thattable where thisid = @valuedelete from thistable where thisid = @value" The first one is not an ibatis bug. The second one might be, but I am not sure. - Kit
