Cannot issue data manipulation statements with executeQuery

Question

In MySQL I have two tables  tableA and tableB   I am trying to execute two queries   executeQuery query1   executeQuery query2    But I get the following error   can not issue data manipulation statements with executeQuery      What does this mean

User · Answer

Use executeUpdate   to issue data manipulation statements  executeQuery   is only meant for SELECT queries  i e  queries that return a result set

User · Answer

This code works for me  I set values whit an INSERT and get the LAST INSERT ID   of this value whit a SELECT  I use java NetBeans 8 1  MySql and java JDBC driver                   try            String Query    INSERT INTO  stock   stock    min stock                       id stock   VALUES                              p get Stock   getStock                                     p get Stock   getStockMinimo                                   null                  Statement st   miConexion createStatement            st executeUpdate Query            java sql ResultSet rs          rs   st executeQuery  Select LAST INSERT ID   from stock limit 1                            rs next      para posicionar el puntero en la primer fila         ultimo id   rs getInt  LAST INSERT ID                catch  SqlException ex    ex printTrace

User · Answer

That s what executeUpdate is for   Here s a very brief summary of the difference  http   www coderanch com t 301594 JDBC java Difference-between-execute-executeQuery-executeUpdate

User · Answer

Modifying  Transactional  Query value    delete from cart item where cart cart id  cart   nativeQuery   true  public void deleteByCart  Param  cart   int cart      Do not forget to add  Modifying and  Transnational before  query  it works for me   To delete the record with some condition using native query with JPA the above mentioned annotations are important

User · Answer

Besides executeUpdate   on the parentheses  you must also add a variable to use an SQL statement   For example   PreparedStatement pst    connection prepareStatement sql   int numRowsChanged   pst executeUpdate sql

User · Answer

When executing DML statement   you should use executeUpdate execute rather than executeQuery   Here is a brief comparison

User · Answer

executeQuery   returns a ResultSet   I m not as familiar with Java MySQL  but to create indexes you probably want a executeUpdate

User · Answer

If you re using spring boot  just add an  Modifying annotation     Modifying  Query  value    UPDATE user SET middleName    Mudd  WHERE id   1   nativeQuery   true  void updateMiddleName

User · Answer

To manipulate data you actually need executeUpdate   rather than executeQuery     Here s an extract from the executeUpdate   javadoc which is already an answer at its own      Executes the given SQL statement  which may be an INSERT  UPDATE  or DELETE statement or an SQL statement that returns nothing  such as an SQL DDL statement

User · Answer

For Delete query - Use  Modifying and  Transactional before the  Query like -  Repository public interface CopyRepository extends JpaRepository lt Copy  Integer gt          Modifying      Transactional      Query value    quot DELETE FROM tbl copy where trade id    1    quot   nativeQuery   true      void deleteCopyByTradeId Integer id       It won t give the java sql SQLException  Can not issue data manipulation statements with executeQuery   error  Edit  Since this answer is getting many upvotes  I shall refer you to the documentation as well for more understanding   Transactional By default  CRUD methods on repository instances are transactional  For read operations   the transaction configuration readOnly flag is set to true   All others are configured with a plain  Transactional so that default transaction  configuration applies    Modifying Indicates a query method should be considered as modifying query as that changes the way  it needs to be executed  This annotation is only considered if used on query methods defined  through a Query annotation   It s not applied on custom implementation methods or queries  derived from the method name as they already have control over the underlying data access  APIs or specify if they are modifying by their name   Queries that require a  Modifying annotation include INSERT  UPDATE  DELETE  and DDL  statements

[java] Cannot issue data manipulation statements with executeQuery()

Examples related to java

Examples related to mysql

Examples related to jdbc