112 Introduction to TopLink Support for Oracle Spatial

This chapter provides an overview of the TopLink support for Oracle Spatial, as well as demonstrates the ways to extend TopLink to support the mapping and querying of Oracle Spatial columns (MDSYS.SDO_GEOMETRY).

112.2.1 How to Configure the Database Platform to Use Structure Converters

TopLink uses a database platform (see Section 96.1.3.1, "Database Platforms") to control the usage of database vendor-specific and version-specific operations such as SQL dialect, stored procedure calls, sequencing, as well as platform-specific type handling. You need to configure the platform to allow TopLink to use the advanced features of the database.

112.2.2 How to Set Up Mappings Using Structure Converters

Use direct-to-field mappings (see Section 27.3, "Direct-to-Field Mapping") to map your STRUCT types. For each mapping that maps to the type defined by the structure converter, set its field type to the STRUCT data type, as follows:

112.3.2 How to Map JGeometry Attributes

Use direct-to-field mappings (see Section 27.3, "Direct-to-Field Mapping") to map your STRUCT types. For each mapping that maps to the type defined by the structure converter (JGeometry), set its field type to the STRUCT data type, as follows: