Bug 758362 - add DB support for SQL Server 2008 R2
Summary: add DB support for SQL Server 2008 R2
Keywords:
Status: NEW
Alias: None
Product: RHQ Project
Classification: Other
Component: Core Server
Version: 4.2
Hardware: Unspecified
OS: Unspecified
medium
low
Target Milestone: ---
: ---
Assignee: Nobody
QA Contact:
URL:
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2011-11-29 17:03 UTC by Ian Springer
Modified: 2024-03-04 13:35 UTC (History)
1 user (show)

Fixed In Version:
Doc Type: Enhancement
Doc Text:
Clone Of:
Environment:
Last Closed:
Embargoed:

Attachments (Terms of Use)

Description Ian Springer 2011-11-29 17:03:37 UTC 
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 10:04:36 UTC 
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.
Note You need to log in before you can comment on or make changes to this bug.