[fdo-trac] #433: RDBMS Providers: Better message when try to add system schema.

[FDO]

#433: RDBMS Providers: Better message when try to add system schema.
---------------------------------+------------------------------------------
   Reporter:  brentrobinson      |       Owner:  brentrobinson      
       Type:  defect             |      Status:  new                
   Priority:  minor              |   Milestone:  3.4.0              
  Component:  SQLServer Spatial  |     Version:  3.4.0              
   Severity:  3                  |    Keywords:  apply system schema
External_id:                     |  
---------------------------------+------------------------------------------
 When an RDBMS provider datastore has metaschema, it contains a special
 system feature schema named the same as the datastore. This system schema
 contains the datastore description.

 If the user tries to add the system schema, via FdoIApplySchema, an
 exception is throw since it already exists. However, the exception message
 is index violation message issued by the RDBMS, and not as user-friendly
 as it could be.
 For example, the message from SQL Server is:

 {{{
     Cannot insert duplicate key row in object 'dbo.f_schemainfo' with
 unique
     index 'f_schemainfo_idx'.
 }}}

 This ticket makes the message a bit more specific, e.g.:

 {{{
     Cannot add schema mydatastore to database; it has the same name as the
     system schema
 }}}

-- 
Ticket URL: <http://trac.osgeo.org/fdo/ticket/433>
FDO <http://fdo.osgeo.org/>
Feature Data Objects