Check the Javadoc for Statement.execute, it will return true if a result set is available.  You should just be checking Statement.getUpdateCount()

Steve

Jane,

What Steve said above is, when you execute a statement like "Statement.execute("udpate xxx set xxxxx")", it will only be returning the Statement.getUpdateCount(), which indicates how many records have been updated with your update statement.

However if you executed "statement.execute('select * from ....')", which does return a resultset, but you do not know whether you executed the first form above or the second from, the "statement.execute" itself "returns" a boolean. If that return is true, then you can call statement.getResultSet(), if false, then you can only call statement.getUpdateCount()

All this explained in the javadoc for the statement class.

Hope this helps.

Ramesh..