SQLServerException: The statement did not return a result set

SQLServerException: The statement did not return a result set

  • Comments 3

Have you ever encountered this exception from executeQuery()? If so, chances are good that your query actually did return a result set (we’ll be addressing the error message text...), but it wasn’t the first result.  Look at your query or stored procedure.  Does it contain multiple SQL statements?  Maybe it includes DDL and DML to create and populate a temp table before the SELECT statement.  If that is the case, then you really need to use execute(), not executeQuery(), to execute it.  The problem is that executeQuery(), per JDBC spec, should only be used with queries whose only result is a single ResultSet.  Quoting from Sun’s documentation of this method:

 

Throws:

SQLException - if a database access error occurs, this method is called on a closed Statement or the given SQL statement produces anything other than a single ResultSet object

 

Some JDBC drivers apparently just ignore and discard DDL and DML results in executeQuery() rather than throwing an exception.

For an explanation on how to use execute() and its partner, getMoreResults(), to execute complex queries, look here.

 

 --David Olix [SQL Server]

This post is provided 'as is' and confers no express or implied warranties or rights.

Leave a Comment
  • Please add 1 and 8 and type the answer here:
  • Post
  • PingBack from http://blog.a-foton.ru/2008/08/sqlserverexception-the-statement-did-not-return-a-result-set/

  • Hi,

    I switched my jdbc driver from type 2 to type 4, right now i m using microsoft sql server jdbc driver of type 4. so as i generate any report in my application it throws error like: net.sf.jasperreports.engine.JRException: Error executing SQL statement for : DataSummaryReport_2

    followed by statement did not return resultset, i have made changes to use statement.execute() instead of statement.executequery() but still its not solved

    I am using stored procedure to retrieve data like: exec wdcGetDataSummaryData $P{SerialNumberStr},$P{Date}

    I have migrated from jdk1.4 to 1.6.

    can you please help me to solve my problem.

    thanks in advance..

  • This error can be avoided if in case we can write all the select statement before any updates, insert or delete statement

Page 1 of 1 (3 items)