Uploaded image for project: 'MariaDB Connector/J'
  1. MariaDB Connector/J
  2. CONJ-549

Pooling used with useServerPrepStmts and useResetConnection

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • None
    • 2.2.1, 1.7.1
    • pooling
    • 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"

      Attachments

        Activity

          Ascending order - Click to sort in descending order
          diego dupin Diego Dupin created issue -
          diego dupin Diego Dupin made changes -
          Field Original Value New Value
          Fix Version/s 2.2.1 [ 22802 ]
          diego dupin Diego Dupin made changes -
          Component/s pooling [ 14209 ]
          Fix Version/s 1.7.1 [ 22808 ]
          Resolution Fixed [ 1 ]
          Status Open [ 1 ] Closed [ 6 ]
          serg Sergei Golubchik made changes -
          Workflow MariaDB v3 [ 83720 ] MariaDB v4 [ 135037 ]

          People

            diego dupin Diego Dupin
            diego dupin Diego Dupin
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.