Inability to run cite tests against Oracle

Details

  • Type: New Feature New Feature
  • Status: Open Open
  • Priority: Major Major
  • Resolution: Unresolved
  • Affects Version/s: None
  • Fix Version/s: 2.0.x
  • Component/s: Oracle
  • Labels:
    None

Description

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.

Activity

Ascending order - Click to sort in descending order
Hide
Permalink
Andrea Aime added a comment -

From the Oracle spatial 10g guide (http://www.stanford.edu/dept/itss/docs/oracle/10g/appdev.101/b10826/sdo_objrelschema.htm):

2.4.1 TABLE_NAME

The TABLE_NAME column contains the name of a feature table, such as COLA_MARKETS, that has a column of type SDO_GEOMETRY.

The table name is stored in the spatial metadata views in all uppercase characters.

The table name cannot contain spaces or mixed-case letters in a quoted string when inserted into the USER_SDO_GEOM_METADATA view, and it cannot be in a quoted string when used in a query (unless it is in all uppercase characters).

and

2.4.2 COLUMN_NAME

The COLUMN_NAME column contains the name of the column of type SDO_GEOMETRY. For the COLA_MARKETS table, this column is called SHAPE.

The column name is stored in the spatial metadata views in all uppercase characters.

The column name cannot contain spaces or mixed-case letters in a quoted string when inserted into the USER_SDO_GEOM_METADATA view, and it cannot be in a quoted string when used in a query (unless it is in all uppercase characters).

Show
Andrea Aime added a comment - From the Oracle spatial 10g guide (http://www.stanford.edu/dept/itss/docs/oracle/10g/appdev.101/b10826/sdo_objrelschema.htm):
2.4.1 TABLE_NAME The TABLE_NAME column contains the name of a feature table, such as COLA_MARKETS, that has a column of type SDO_GEOMETRY. The table name is stored in the spatial metadata views in all uppercase characters. The table name cannot contain spaces or mixed-case letters in a quoted string when inserted into the USER_SDO_GEOM_METADATA view, and it cannot be in a quoted string when used in a query (unless it is in all uppercase characters).
and
2.4.2 COLUMN_NAME The COLUMN_NAME column contains the name of the column of type SDO_GEOMETRY. For the COLA_MARKETS table, this column is called SHAPE. The column name is stored in the spatial metadata views in all uppercase characters. The column name cannot contain spaces or mixed-case letters in a quoted string when inserted into the USER_SDO_GEOM_METADATA view, and it cannot be in a quoted string when used in a query (unless it is in all uppercase characters).
Hide
Permalink
Andrea Aime added a comment -

And this comes from the 11G guide (http://download.oracle.com/docs/cd/B28359_01/appdev.111/b28400/sdo_objrelschema.htm#i1001937)

The following considerations apply to schema, table, and column names that are stored in any Oracle Spatial metadata views:

*

The name must contain only letters, numbers, and underscores. For example, the name cannot contain a space ( ), an apostrophe ('), a quotation mark ("), or a comma (,).
*

All letters in the names are converted to uppercase before the names are stored in geometry metadata views or before the tables are accessed. This conversion also applies to any schema name specified with the table name.

Show
Andrea Aime added a comment - And this comes from the 11G guide (http://download.oracle.com/docs/cd/B28359_01/appdev.111/b28400/sdo_objrelschema.htm#i1001937)
The following considerations apply to schema, table, and column names that are stored in any Oracle Spatial metadata views: * The name must contain only letters, numbers, and underscores. For example, the name cannot contain a space ( ), an apostrophe ('), a quotation mark ("), or a comma (,). * All letters in the names are converted to uppercase before the names are stored in geometry metadata views or before the tables are accessed. This conversion also applies to any schema name specified with the table name.

People

  • Assignee:
    Andrea Aime
    Reporter:
    Andrea Aime
Vote (0)
Watch (0)

Dates

  • Created:
    Updated: