MySQL: cannot insert into or update foreign schema class via FDO gateway

[brentrobinson]

- created a non-FDO datastore with a single table with the following columns:

id varchar(20) not null. data varchar(50) null, geometry geometry, primary key(id)

- created an FDO datastore and applied a Feature Schema and schema overrides that

relate a feature class to the above table.

- executed a FdoIInsert command against the feature class. Got the following

exception:

No column for property 'ClassId?'

[brentrobinson]

Modified the FdoIInsert and FdoIUpdate implementations for MySQL Provider to ignore system properties that don't have columns. This allows the MySQL Provider to handle tables without classid or revisionnumber columns, when these tables are accessed via an FDO datastore.

Revision: 2643 Author: brentrobinson Date: 5:24:22 PM, Monday, March 05, 2007 Message: Ticket #28: Merged Revision 777 from branch 3.2.x: Handle missing system properties for externally created tables.

---

Modified : /trunk/Providers/GenericRdbms/Src/Fdo/FeatureCommands/FdoRdbmsInsertCommand.cpp Modified : /trunk/Providers/GenericRdbms/Src/Fdo/FeatureCommands/FdoRdbmsUpdateCommand.cpp Modified : /trunk/Providers/GenericRdbms/Src/Fdo/Pvc/FdoRdbmsPvcInsertHandler.cpp Modified : /trunk/Providers/GenericRdbms/Src/Fdo/Pvc/FdoRdbmsPvcUpdateHandler.cpp