Cannot issue data manipulation statements with executeQuery()

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.

Related Posts:

  1. com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
  2. com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
  3. java.sql.SQLException: No database selected – why?
  4. java.lang.ClassNotFoundException: com.mysql.jdbc.Driver in Eclipse
  5. java.lang.ClassNotFoundException: com.mysql.jdbc.Driver in Eclipse
  6. getting error HTTP Status 405 – HTTP method GET is not supported by this URL but not used `get` ever?
  7. Can’t find mysqladmin on Mac OSX 10.6.8
  8. DB2 jdbc connection error Connection refused. ERRORCODE=-4499, SQLSTATE=08001
  9. A JNI error has occurred, please check your installation and try again in Eclipse x86 Windows 8.1
  10. Unable to create requested service [org.hibernate.engine.jdbc.env.spi.JdbcEnvironment]
  11. DB2 SQL Error: SQLCODE=-204, SQLSTATE=42704
  12. java.sql.SQLException: Access denied for user ‘root’@’localhost’ (using password: YES)
  13. ResultSet exception – before start of result set
  14. java.lang.ClassNotFoundException: sun.jdbc.odbc.JdbcOdbcDriver Exception occurring. Why?
  15. IO Error: The Network Adapter could not establish the connection
  16. Getting java.sql.SQLException: Operation not allowed after ResultSet closed
  17. How do I get the size of a java.sql.ResultSet?
  18. SQL Error: 0, SQLState: 08S01 Communications link failure
  19. How to resolve Unable to load authentication plugin ‘caching_sha2_password’ issue
  20. Efficient way to do batch INSERTS with JDBC
  21. What kind of Java type is “[B”?
  22. Connection Java – MySQL : Public Key Retrieval is not allowed
  23. JPA or JDBC, how are they different?
  24. What does Java option -Xmx stand for? [duplicate]
  25. How do I convert a String to an int in Java?
  26. What does Java option -Xmx stand for? [duplicate]
  27. Is there an invisible character that is not regarded as whitespace?
  28. Problem with gif with transparent background
  29. Finding white rectangle in an image
  30. 1000 * 60 * 60 * 24 * 30 results in a negative number [duplicate]
  31. How to convert nanoseconds to seconds using the TimeUnit enum?
  32. Search for words with telephone numbers from 2-3-4 tree
  33. Using or ‘|’ in regex [duplicate]
  34. How to format strings in Java
  35. What is the difference between x86 and x64
  36. && (AND) and || (OR) in IF statements
  37. How to use the toString method in Java?
  38. What is a NullPointerException, and how do I fix it?
  39. What exactly is Apache Camel?
  40. Unable to find valid certification path to requested target – error even after cert imported
  41. Unable to find valid certification path to requested target – error even after cert imported
  42. What is the equivalent of the C++ Pair in Java?
  43. Java – Convert integer to string [duplicate]
  44. Getting random numbers in Java [duplicate]
  45. What is an instance variable in Java?
  46. javac is not recognized as an internal or external command, operable program or batch file [closed]
  47. javac is not recognized as an internal or external command, operable program or batch file [closed]
  48. Java: “error: cannot find symbol”
  49. How does the Java ‘for each’ loop work?
  50. What is a StackOverflowError?
  51. How to uninstall Eclipse?
  52. Is GNU’s Java Compiler (GCJ) dead? [closed]
  53. How does System.out.print() work?
  54. How do I “decompile” Java class files? [closed]
  55. How do I determine whether an array contains a particular value in Java?
  56. How to initialize an array in Java?
  57. How does the Java ‘for each’ loop work?
  58. Java 8 Iterable.forEach() vs foreach loop
  59. Initialize part of an array in java
  60. How can I solve Exception in thread “main” java.lang.NullPointerException error [duplicate]
  61. How to split a string in Java
  62. What does “Could not find or load main class” mean?
  63. What does “Could not find or load main class” mean?
  64. Why am I getting a NoClassDefFoundError in Java?
  65. How to avoid “ConcurrentModificationException” while removing elements from `ArrayList` while iterating it? [duplicate]
  66. Eclipse/Maven error: “No compiler is provided in this environment”
  67. How do I compare strings in Java?
  68. What is reflection and why is it useful?
  69. Implementing UML diagram to Java [closed]
  70. How to round a number to n decimal places in Java
  71. Using Pairs or 2-tuples in Java [duplicate]
  72. How do I create a file and write to it?
  73. Could not reserve enough space for object heap
  74. When to use LinkedList over ArrayList in Java?
  75. How to convert a char to a String?
  76. Difference between Arrays.asList(array) and new ArrayList(Arrays.asList(array))
  77. What is the proper way to handle a NumberFormatException when it is expected?
  78. What causes “Unable to access jarfile” error?
  79. What does “Could not find or load main class” mean?
  80. How do you create a dictionary in Java? [closed]
  81. Reading a plain text file in Java
  82. Error unable to access jarfile C:\Jar
  83. Where is JRE 11? [duplicate]
  84. In laymans terms, what does ‘static’ mean in Java? [duplicate]
  85. How to convert/parse from String to char in java?
  86. Reverse a string in Java
  87. Static Classes In Java
  88. Is there any doubly linked list implementation in Java?
  89. How to set a Timer in Java?
  90. How do I declare and initialize an array in Java?
  91. How to parse JSON in Java
  92. Is there a way to convert all comments into javadoc comments? [Eclipse/Java]
  93. Convert list to array in Java [duplicate]
  94. Reverse a string in Java
  95. Sort an array in Java
  96. Java String Split by “|”
  97. Convert String to double in Java
  98. Exception in thread “main” java.util.NoSuchElementException
  99. Could not reserve enough space for object heap
  100. Converting double to string

Leave a Comment

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)