Can I execute multiple queries separated by semicolon with MySQL Connector/J? [duplicate]

by

Using ; in a query for most databases doesn’t work as it is usually not part of the statement syntax itself, but a terminator for command line or script input to separate statements. The command line or script processor sees a semi-colon as the signal that the statement is complete and can be sent to the server.

Also in JDBC a single statement prepare (or execute) should only be one actual statement so multiple statements are not allowed and so there is also no need to have a semi-colon, and as for some (most?) databases the semi-colon isn’t part of the statement syntax, it is simply a syntax error to have one included.

If you want to execute multiple statements, you need to use separate executes. Technically, MySQL does have an option to support multiple executions which can be enabled by a connection property. This behavior is not compliant with the JDBC specification/API and makes your code less portable. See allowMultiQueries on Driver/Datasource Class Names, URL Syntax and Configuration Properties for Connector/J

More Related Contents:

  1. Connect Java to a MySQL database
  2. com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
  3. Solving a “communications link failure” with JDBC and MySQL [duplicate]
  4. MySQLSyntaxErrorException near “?” when trying to execute PreparedStatement
  5. Can we connect remote MySQL database in Android using JDBC? [closed]
  6. java.sql.SQLException Parameter index out of range (1 > number of parameters, which is 0) [closed]
  7. Cannot issue data manipulation statements with executeQuery()
  8. Handling MySQL datetimes and timestamps in Java
  9. java.sql.SQLException: Access denied for user ‘root’@’localhost’ (using password: YES)
  10. JDBC MySql connection pooling practices to avoid exhausted connection pool
  11. Getting java.sql.SQLException: Operation not allowed after ResultSet closed
  12. right syntax to use near ‘?’
  13. Running a .sql script using MySQL with JDBC
  14. Java JDBC Access denied for user [closed]
  15. Passing parameters to a JDBC PreparedStatement
  16. JDBC character encoding
  17. runtime error: java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
  18. JDBC returning MySQLSyntaxError Exception with correct statement
  19. ‘0000-00-00 00:00:00’ can not be represented as java.sql.Timestamp error
  20. Problems reading/writing UTF-8 data in MySQL from Java using JDBC connector 5.1
  21. MySQL connector error “The server time zone value Central European Time” [duplicate]
  22. com.mysql.jdbc.PacketTooBigException
  23. com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create connection to database server [duplicate]
  24. Should a database connection stay open all the time or only be opened when needed?
  25. Converting mysql table to spark dataset is very slow compared to same from csv file
  26. A datetime equivalent in java.sql ? (is there a java.sql.datetime ?)
  27. Performance of MySQL Insert statements in Java: Batch mode prepared statements vs single insert with multiple values
  28. A persistent connection with JDBC to MySQL
  29. JDBC MySQL connection using Unix Socket
  30. JDBC connection error : unrecognized timezone [duplicate]

Leave a Comment