In the past, we had to develop an OracleDatastoreWrapper implementing a DatastoreWrapper to deal with these limitations on Oracle DB:
1) All attributes and type names are UPPERCASE 2) attribute and type names can't be longer than 30 chars
These limitations was preventing the GranuleCatalog based on Oracle DB to properly work in some cases.
Latelly, we found similar issue with PostGIS DB. Quoting from link here: The system uses no more than NAMEDATALEN-1 bytes of an identifier; longer names can be written in commands, but they will be truncated. By default, NAMEDATALEN is 64 so the maximum identifier length is 63 bytes
Therefore we should support a WrapStore mosaic configuration parameter to enable Postgis datastore wrapping in order to properly map original typeNames and schema attribues to truncated values defined in the PG Database.
|