Turn on debug logging for javax.Sql
And see what statements are getting prepared.
R
Sent from my iPhone
On Feb 11, 2009, at 8:24 AM, "Burke.Kevin" <[email protected]>
wrote:
Hi,
We have encountered a bizarre scenario while using iBatis 2.3.0.667 on
Sybase ASE. We began experiencing our entire table being wiped from a
delete statement that uses dynamic SQL to build the FROM and WHERE
clauses in a sqlmap. We were pretty sure valid parameters were being
passed in to the sqlmap via a parameterMap, and after logging the
output of the SQL we verified the statement looked correct. It ran
correctly through a sql client connected directly to ASE. However,
through iBatis it ignored the WHERE clause and deleted all rows.
Turns
out, our table name was preceded with "dbo.". This was causing iBatis
to ignore our WHERE clause and issue just a "delete <tablename>"
against
our db. Yikes! We were using a <delete> tag in our sqlMap file, and
invoking delete() from our dao via Spring's SqlMapClientDaoSupport
class.
Has anyone else experienced this? Is this a possible bug in this
version of iBatis? I have searched the archives and Googled, but I
cannot find any similar experiences.
Cheers,
Kevin
