XMLWordPrintable

    Details

    • Type: Task
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 2.0.1-beta
    • Component/s: API
    • Labels:
      None

      Description

      Must have a new public method "reset" to the connection.
      This must permit to reset connection entirely (based on https://mariadb.com/kb/en/library/com_reset_connection/), to :

      • rollback any open transaction
      • reset transaction isolation level
      • reset session variables
      • delete user variables
      • remove temporary tables
      • remove all PREPARE statement

      Pool implementation must provide an option to reset completely the connection when given back to pool, replacing rollback command.

      This has not to be the default since most of the time, this is not needed and will just add a new useless exchange with the server.
      Still, this adds some security, for applications that needs strong isolation, like not permitting reusing a connection that has a temporary table with data...

        Attachments

          Activity

            People

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

              Dates

              Created:
              Updated:
              Resolved: