Re: Redundant "Reset stmt" before "Execute" when setting useServerPrepStmts and cachePrepStmts to true in MySQL Connector/J
Posted by: Filipe Silva
Date: April 22, 2022 01:31PM

It seems you've found a bug. We'll need to investigate it further, but it really looks like that there is some mix up regarding the internal value of longParameterSwitchDetected and the "Reset stmt" is not always needed.

Regarding your questions:

1. ATM, as long as you are enabling prepared statements caching, there's no way of avoiding the "Reset stmt".

2. "longParameterSwitchDetected" is required to cleanup data that may have been sent through streams, and to close cursors that may have been opened during previous executions. It relates to protocol command COM_STMT_RESET.

Could you please file a bug if you haven't yet? Thank you.

Options: ReplyQuote


Subject
Written By
Posted
Re: Redundant "Reset stmt" before "Execute" when setting useServerPrepStmts and cachePrepStmts to true in MySQL Connector/J
April 22, 2022 01:31PM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.