Use MySQL transaction isolation level per session

XMLWordPrintable

      We should switch confluence to using per-session level transaction isolation, rather than relying on customers modifying the global setting.

      Some customers can't (or are unwilling to) change the default settings for isolation globally for their MySQL. We need to provide a better solution for these customers, and to reduce the configuration effort for all customers. Using per session isolation settings (via hibernate.connection.isolation=2, see http://docs.jboss.org/hibernate/core/3.3/reference/en/html/session-configuration.html#configuration-optional and http://download.oracle.com/javase/6/docs/api/constant-values.html#java.sql.Connection.TRANSACTION_READ_COMMITTED) would fit the bill nicely.

            Assignee:
            Katrina Walser (Inactive)
            Reporter:
            Richard Atkins
            Votes:
            28 Vote for this issue
            Watchers:
            24 Start watching this issue

              Created:
              Updated:
              Resolved: