{{theTime}}

Search This Blog

Total Pageviews

SqlException: The executeQuery method must return a result set.

executeQuery returns a result set.  Use executeUpdate instead or review the sql.

  • boolean execute() Executes the SQL statement in this PreparedStatement object, for any kind of SQL statement.

  • ResultSet executeQuery() Executes the SQL query in this PreparedStatement returns the ResultSet for the Query(Select ...)

  • int executeUpdate() Executes the SQL statement in this PreparedStatement returns total successful count, which must be an SQL INSERT, UPDATE or DELETE statement; or an SQL statement that returns nothing, such as a DDL statement.

No comments:

Generate Insert Sql from Select Statement

SELECT 'INSERT INTO ReferenceTable (ID, Name) VALUES (' +        CAST(ID AS NVARCHAR) + ', ''' + Name + ''...