[OOZIE-1517] Support using MS SQL Server as a metastore

• Type: Sub-task
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 4.1.0
• Component/s: core, tools
• Assignee: David Wannemacher
• Reporter: David Wannemacher
• Created: 03/Sep/13 17:06
• Updated: 09/Dec/14 00:45
• Resolved: 14/Oct/13 20:18

Description

A few things need to be changed/added to enable Oozie to use SQL Server as a metastore:

1. Add oozie-sqlserver-orm.xml
2. Add a section in persistence.xml for SQL Server
3. OozieDBCLI.java: Add a section to the DDL queries for upgrading a database
4. OozieDBCLI.java: Create a clustered index on OOZIE_SYS