Why is an error displayed when adding a record in MS SQL?

Question

Java

There is a piece of code. (JAVA)

sql = "SET NOCOUNT OFF INSERT INTO USER_INFO_TCC (USR_LAST_NAME,USR_FIRST_NAME,USR_MIDDLE_NAME,USR_EMAIL,USR_UDF_ADLOGIN,USR_UDF_START_DATE,USR_UDF_END_DATE,USR_UDF_JOBPOSITIONNAME,USR_UDF_PERSONNEL_NUMBER,USR_UDF_ORG_UNIT,USR_UDF_BALANCE_CODE) VALUES " +
                        "('"+USR.USR_LAST_NAME+"','"+USR.USR_FIRST_NAME+"','"+USR.USR_MIDDLE_NAME+"','"+USR.USR_EMAIL+"','"+USR.USR_UDF_ADLOGIN+"',"+USR_UDF_START_DATE_TCC+","+USR_UDF_END_DATE_TCC+",'"+USR.USR_UDF_JOBPOSITIONNAME+"','"+USR.USR_UDF_PERSONNEL_NUMBER+"','"+USR.USR_UDF_ORG_UNIT+"','"+USR.USR_UDF_BALANCE_CODE+"')";
                    System.out.println(sql);
                    TCCBDSt.executeQuery(sql);

A record is added to the table, but an exception is thrown:
Exception in thread "main" com.microsoft.sqlserver.jdbc.SQLServerException: The statement did not return a result set.
What could be the problem? SET NOCOUNT OFF has no effect.

Answer 1

executeQuery is called for SELECT queries that return result sets.
In your case, you need to use executeUpdate, which is for UPDATE INSERT DELETE commands that result sets don't return.

Answer 2

Thanks =)