JDBC (Java Database Connectivity) Reader: Feature Type Parameters
To access feature type parameters, click the gear icon on a feature type in the workspace to open the Feature Type Parameter Editor. To always display the editor in Workbench, you can select View > Windows > Parameter Editor.
General
All feature types share similar General parameters, including the Feature Type Name, Reader or Writer Name, and Geometry.
In most Writer Feature Type parameter dialogs, you can also control Dynamic Schema Definitions. Some database formats accept a Table Qualifier prefix on the output table feature type.
See Editing Writer Feature Types for more information.
These parameters apply only to a selected feature type, not to the entire reader.
Note: If a feature type parameter corresponds to a reader-level parameter, then the reader parameter will be ignored and the feature type parameter will be used.
Table Settings: Spatial
The name of the column containing geometry, when reading from only one of multiple geometry columns. When not specified, the first geometry column found is chosen.
To construct a WHERE clause, click the browse button to open the Where Clause editor. You can also type a WHERE clause directly in the parameter field.
If the WHERE clause SQL is invalid, the translation will fail.