[CONJ-549] Pooling used with useServerPrepStmts and useResetConnection Created: 2017-11-09 Updated: 2017-11-20 Resolved: 2017-11-20 |
|
| Status: | Closed |
| Project: | MariaDB Connector/J |
| Component/s: | pooling |
| Affects Version/s: | None |
| Fix Version/s: | 2.2.1, 1.7.1 |
| Type: | Bug | Priority: | Major |
| Reporter: | Diego Dupin | Assignee: | Diego Dupin |
| Resolution: | Fixed | Votes: | 0 |
| Labels: | None | ||
| Description |
|
When activating "useResetConnection", when connection is given back to pool, connection is reset. Part of that reset consist of removing existing Prepare commands, so, if prepStmtCacheSize is > 0 (default) and useResetConnection is enable (not default), then if query is in cache, query won't be reprepared, resulting in an error 'Unknown prepared statement handler (xxx) given to mysqld_stmt_execute" |