Should JDBC.executeQuery() for multi-statement "select into; select @@rowcount" throw "The statement did not return a result set" exception?

select @@rowcount does return a result set - one row with the number of affected rows.

---

For every expert, there is an equal and opposite expert. - Becker's Law





My blog



My TechNet articles

(1) This is obvious. (2) This doesn't answer a question, sorry. SQL is multi-statement and expected behavior of executeQuery() is to throw an exception. Of course, execute() should be OK and it's second result is a result set.