Sign In
Microsoft JDBC Driver Team Blog
Discussions related to Microsoft JDBC driver.
Options
Email Blog Author
RSS for posts
Atom
RSS for comments
OK
Tags
AlwaysOn
annoucement
Announcement
Azure
Connectivity
CTP
Data Access API
Denali
Developer
Features
General
Java
JDBC
Kerberos
Linux
ODBC
SQL
sql azure
SQL Connectivity
SQL Server
SQL Server 2008
SQL Server 2008 R2
Support
survey
Troubleshooting
Archive
Archives
January 2012
(2)
November 2011
(2)
October 2011
(2)
September 2011
(3)
August 2011
(2)
July 2011
(1)
May 2011
(1)
March 2011
(1)
February 2011
(1)
January 2011
(2)
December 2010
(1)
October 2010
(1)
July 2010
(1)
June 2010
(1)
May 2010
(1)
April 2010
(2)
March 2010
(4)
January 2010
(1)
November 2009
(1)
October 2009
(1)
April 2009
(2)
February 2009
(1)
January 2009
(2)
October 2008
(2)
September 2008
(2)
August 2008
(3)
July 2008
(2)
June 2008
(2)
May 2008
(1)
March 2008
(2)
December 2007
(1)
November 2007
(1)
October 2007
(1)
September 2007
(1)
June 2007
(2)
May 2007
(2)
April 2007
(1)
Translate This Page
Translate this page
Powered by
Microsoft® Translator
August, 2008
MSDN Blogs
>
Microsoft JDBC Driver Team Blog
>
August, 2008
Posts
Subscribe via RSS
Sort by:
Most Recent
|
Most Views
|
Most Comments
Excerpt View
|
Full Post View
Microsoft JDBC Driver Team Blog
Why doesn't executeUpdate() give me the exception I expected?
Posted
over 4 years ago
by
dpblogs
1
Comments
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...
Microsoft JDBC Driver Team Blog
SQLServerException: The statement did not return a result set
Posted
over 4 years ago
by
dpblogs
2
Comments
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...
Microsoft JDBC Driver Team Blog
Use execute() and getMoreResults() methods for those pesky complex SQL queries
Posted
over 4 years ago
by
dpblogs
9
Comments
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...
Page 1 of 1 (3 items)
Search
Advanced search options...
Search In:
Everything
Blogs
Forums
People
Groups
Places
Pages
Date range:
All Time
Last Year
Last 6 Months
Last 3 Months
Last Month
Last Week
Last Two Days