Opened 15 years ago
Closed 15 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 , 15 years ago
Status: | new → assigned |
---|
comment:2 by , 15 years ago
Resolution: | → fixed |
---|---|
Status: | assigned → closed |
Note:
See TracTickets
for help on using tickets.
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