Uploaded image for project: 'Nuxeo Platform'
  1. Nuxeo Platform
  2. NXP-10219

Support Microsoft's JDBC driver for SQL Server

    XMLWordPrintable

    Details

    • Type: Improvement
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 5.6
    • Fix Version/s: 5.6.0-HF02, 5.7.1
    • Component/s: Core VCS
    • Backlog priority:
      1,000
    • Impact type:
      Configuration format change
    • Upgrade notes:
      Hide

      To support XA using the Microsoft JDBC driver, some setup has to be done in the SQL Server itself. It is NECESSARY to follow the Configuration Instructions listed at http://msdn.microsoft.com/en-us/library/aa342335(v=sql.105).aspx

      In particular, after the configuration, note that you must add your database user ('nuxeo' in this example) to proper role in order for him to execute XA statements:

      USE master
      EXEC sp_grantdbaccess 'nuxeo', 'nuxeo'
      EXEC sp_addrolemember [SqlJDBCXAUser], 'nuxeo'

      Some screenshots for the first part are visible at http://www.sqlserver-dba.com/2011/12/enable-xa-transactions-for-sql-server.html

      Show
      To support XA using the Microsoft JDBC driver, some setup has to be done in the SQL Server itself. It is NECESSARY to follow the Configuration Instructions listed at http://msdn.microsoft.com/en-us/library/aa342335(v=sql.105).aspx In particular, after the configuration, note that you must add your database user ('nuxeo' in this example) to proper role in order for him to execute XA statements: USE master EXEC sp_grantdbaccess 'nuxeo', 'nuxeo' EXEC sp_addrolemember [SqlJDBCXAUser] , 'nuxeo' Some screenshots for the first part are visible at http://www.sqlserver-dba.com/2011/12/enable-xa-transactions-for-sql-server.html

      Description

      There are some changes needed to replace jtds with Microsoft's driver.

        Attachments

          Issue Links

            Activity

              People

              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  PagerDuty

                  Error rendering 'com.pagerduty.jira-server-plugin:PagerDuty'. Please contact your Jira administrators.