Welcome to MSDN Blogs Sign in | Join | Help

Microsoft JDBC Driver Team Blog

Discussions related to Microsoft JDBC driver.

August 2008 - Posts

Why doesn't executeUpdate() give me the exception I expected?
If you are using executeUpdate() to execute a query or stored procedure containing multiple SQL statements, the problem may just be that the error you're expecting wasn't the first result returned by the query. Consider a case where you use executeUpdate() Read More...
SQLServerException: The statement did not return a result set
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. Read More...
Use execute() and getMoreResults() methods for those pesky complex SQL queries
Per JDBC spec, the Statement.executeUpdate() and Statement.executeQuery() methods are to be used only with queries that produce a single update count or result set, respectively. If you need to execute multiple SQL statements in a single query, perhaps Read More...
Page view tracker