Changes in MySQL Connector/J 9.7.0 (2026-04-22)

Note

These release notes were created with the assistance of MySQL HeatWave GenAI.

Version 9.7.0 is a new GA release of MySQL Connector/J. MySQL Connector/J 9.7.0 supersedes 9.6 and is recommended for use on production systems. This release can be used against MySQL Server version 8.0 and later. It supports the Java Database Connectivity (JDBC) 4.2 API, and implements the X DevAPI.

• Functionality Added or Changed

• Bugs Fixed

Functionality Added or Changed

• Connector/J now implements the following java.sql.Statement methods:

  • enquoteIdentifier(String identifier, boolean alwaysQuote)

  • enquoteLiteral(String val)

  • enquoteNCharLiteral(String val)

  • isSimpleIdentifier(String identifier)

  (Bug #112083, Bug #35716870, WL #17215)

Bugs Fixed

• Negative TIME values were incorrecly decoded over the binary protocol. For example, when useServerPrepStmts=true. (Bug #119863, Bug #38951042)

• Fixed an issue in BinaryResultsetReader where, for servers not deprecating the EOF packet and without cursor usage, the intermediate EOF packet after column definitions was not consumed. This resulted in prematurely empty ResultSets and protocol desynchronization in some prepared statement queries. The fix ensures the extra EOF packet is properly consumed, restoring correct result processing and connection state alignment. (Bug #119659, Bug #38916595)

• Queries containing the string INTO within valid tokens, such as table or column names, were not handled correctly. Errors were returned similar to the following:

          java.sql.SQLException: Statement.executeQuery() cannot issue
          statements that do not produce result sets

  Our thanks to Milo van der Zee for the contribution. (Bug #119245, Bug #38599240)