Larry, This is what I initially suspected as well. I had already downloaded a java SQL client to test it out when you responded. Oddly enough, it does not duplicate the behavior we experienced via iBatis. The query executes correctly and only deletes the rows defined in the WHERE clause.
Hmmm...I have the iBatis source. I think I will have to step down and get dirty to see what is happening. I know how to avoid this side effect, but curiousity has me now. From the replies, it doesn't sound like anyone else running Sybase with iBatis has experienced this. Cheers, Kevin -----Original Message----- From: Larry Meadors [mailto:[email protected]] Sent: February 11, 2009 12:22 PM To: [email protected] Subject: Re: DELETE statement deletes all rows in table When you say "sql client", are you talking about some native sql client app, or a java-based one that uses the same jdbc driver your app does? Try the statement with straight JDBC - I suspect you'll see the same behaviour. Larry
