Opened 16 years ago

Closed 16 years ago

#433 closed defect (fixed)

RDBMS Providers: Better message when try to add system schema.

Reported by: brentrobinson Owned by: brentrobinson
Priority: minor Milestone: 3.4.0
Component: SQLServer Spatial Version: 3.4.0
Severity: 3 Keywords: apply system schema
Cc: External ID:

Description

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

Change History (2)

comment:1 by brentrobinson, 16 years ago

Status: newassigned

Revision: 4261 Author: brentrobinson Date: 11:05:30 AM, Monday, November 24, 2008 Message: Ticket#433: Made system schema add error message more user-friendly.


Modified : /trunk/Providers/GenericRdbms/Src/UnitTest/Common/FdoApplySchemaTest.cpp Modified : /trunk/Providers/GenericRdbms/Src/UnitTest/Common/Pch.h Modified : /trunk/Providers/GenericRdbms/Src/UnitTest/UnitTestMySql.vcproj Modified : /trunk/Providers/GenericRdbms/Src/UnitTest/UnitTestSQLServerSpatial.vcproj Added : /trunk/Providers/GenericRdbms/Src/UnitTest/apply_schema_err10_master.txt Added : /trunk/Providers/GenericRdbms/Src/UnitTest/apply_schema_err11_master.txt Modified : /trunk/Utilities/SchemaMgr/Nls/SmMessage.mc Modified : /trunk/Utilities/SchemaMgr/Src/Sm/SchemaManager.cpp

comment:2 by brentrobinson, 16 years ago

Resolution: fixed
Status: assignedclosed
Note: See TracTickets for help on using tickets.