Inability to run cite tests against Oracle
------------------------------------------
Key: GEOS-2027
URL: http://jira.codehaus.org/browse/GEOS-2027
Project: GeoServer
Issue Type: New Feature
Components: Oracle
Reporter: Andrea Aime
Assignee: Andrea Aime
Fix For: 2.0
Just a quick reminder or why cite tests cannot be run against the Oracle database:
- boolean type is not supported by Oracle, wfs 1.1 cite do use boolean properties (we'd need a mapping from number(1) or to char(1) (Y,N) to boolean)
- whilst Oracle supports mixed case table names, Oracle spatial does not. The documentation states that the TABLE_NAME and the COLUMN_NAME
to be inserted into USER_SDO_GEOM_METADATA cannot use quoted, mixed case identifiers.
Given how expensive a working Oracle install is, this is *very* disappointing.
Long story short, to support cite testing in Oracle we'll need aliasing not only on the feature type names, but also on the column names, and possibly
also type mapping.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://jira.codehaus.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira