eclipse-vertx/vertx-sql-client

MySQLConnectionImpl.resetConnection() does not clear PreparedStatementCache

KitanoTom opened this issue · 1 comments

KitanoTom commented

Version

4.5.4

Issue

The ResetConnection in MySQL (COM_RESET_CONNECTION) releases the prepared statements, but MySQLConnectionImpl.resetConnection() does not clear the PreparedStatementCache. Therefore, executing the same query after resetConnection(), it will cause an error like the following.

io.vertx.mysqlclient.MySQLException: {errorMessage=Unknown prepared statement handler (1) given to mysql_stmt_precheck, errorCode=1243, sqlState=HY000}
tsegismont commented

Fixed by 878c454

  • 👍2