Bug 758362

Summary: add DB support for SQL Server 2008 R2
Product: [Other] RHQ Project Reporter: Ian Springer <ian.springer>
Component: Core ServerAssignee: RHQ Project Maintainer <rhq-maint>
Status: NEW --- QA Contact: Mike Foley <mfoley>
Severity: low Docs Contact:
Priority: medium    
Version: 4.2CC: hbrock, hrupp
Target Milestone: ---Keywords: FutureFeature
Target Release: ---   
Hardware: Unspecified   
OS: Unspecified   
Fixed In Version: Doc Type: Enhancement
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: Type: ---
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: ---

Description Ian Springer 2011-11-29 12:03:37 EST
DBTypeFactory currently contains:

            } else if (db_name.indexOf("sql server") != -1) {
                if (db_version.startsWith("09.00") || db_version.startsWith("9.00")) { // SQL Server 2005
                    database_type_class = SQLServer2005DatabaseType.class;
                } else if (db_version.startsWith("10.00")) { // SQL Server 2008
                    database_type_class = SQLServer2008DatabaseType.class;

This will not match SQL Server 2008 R2, whose version will start with "10.50".

See http://support.microsoft.com/kb/321185 for details on SQL Server versioning.
Comment 1 Heiko W. Rupp 2011-11-30 05:04:36 EST
My understanding after talking to Joe, who implemented SQL-Server, is that our code only supports selected versions. So just adding the version to the type factory may not be enough.