Licensing optionsfor this format begin with FME Professional Edition.
概述
Ingres Spatial is a geometric library built into Ingres Relational Database Management System (RDBMS) since version 10S (10.1) that provides geometry and Spatial Reference System (SRS) handling. The Ingres Spatial reader/writer module enables FME to read geometric Ingres data as well as underlying attribute data stored in Ingres.
INGRES空间读取器/写入器专门用于处理数据的几何和SRS部分。当读取INGRES的属性表时，应使用INGRES非空间读取器/写入器。Ingres Spatial Reader / Writer使用Ingres JDBC驱动程序。
This chapter assumes familiarity with Ingres Spatial and Ingres, the attribute and geometry types supported, and its indexing mechanisms.
For more information, please see the Ingres home at
和Ingres空间文件在
http://docs.actian.com/ingres/10s/geospatial-user-guide
Usage Notes
The performance of this format is dependent on the amount of memory allocated to the Java Virtual Machine (JVM). The following environment variables allow you to specify memory available to Java Plugins:
- FME_JVM_MIN_HEAP_SIZE: Initial heap size for initializing the JVM. Default value is 1024K.
- fme_jvm_max_heap_size：初始化JVM的最大堆大小。默认值为16384K。
如果未命中，JVM会应用默认值。如果设置，则值必须是1024k的倍数（例如，4m和64m，或4096k和32768k）。
Note:To pass additional parameters used by FME to the Java Virtual Machine, use the JAVA_TOOL_OPTIONS environment variable.
读者概述
FME considers an Ingres Spatial dataset to be a database containing a collection of relational tables together with their corresponding geometries. The tables must be defined in the workspace before they can be read.
任意条款和加入都完全支持，以及整个任意SQL SELECT语句;但是，用户随后对该陈述或条款的正确性承担责任，包括在必要时引用。
When reading from the Ingres database, each table is considered a feature type in FME and each row of a table at least one feature in FME. In the case of heterogeneous geometry collections, they may become more than one FME feature.
The basic reading process involves opening a connection to the database, querying metadata, and querying data. The data is read using a cursor and rows are fetched to the client machine individually. By default, there is one cursor per input table.
如果读取空几何，则将它们视为非几何特征，并且属性保留。
Table and column names are truncated at 256 characters. If duplicate names are produced by truncation, the behavior is undetermined. Please ensure that table names comply with Ingres naming conventions.
Spaces and special characters are permissible in both table and column names. Table and column names are case insensitive and always lowercase.
UNICODE support is enabled either via your databases CHARSET or Unicode char type columns. The client is assumed to have entered data and created tables and columns in the encoding of their operating system.
The user that the client uses to log in with is the schema used for all tables. Specifying schema is not supported.
Writer Overview
The Ingres Spatial writer stores both geometry and attributes into an Ingres database.
Note:Attribute case is not preserved, and all names are lowercase.
The Ingres Spatial writer provides the following capabilities:
- Transaction Support:The Ingres Spatial writer provides transaction support that eases the data loading process. Occasionally, a data load operation terminates prematurely due to data difficulties. The transaction support provides a mechanism for reloading corrected data without data loss or duplication.
- Bulk Loading:By default, the Ingres writer uses a bulk loading technique to ensure speedy data loading.