Martin Desruisseaux created SIS-608:
---------------------------------------
Summary: Improve robutness of SQLStore
Key: SIS-608
URL: https://issues.apache.org/jira/browse/SIS-608
Project: Spatial Information Systems
Issue Type: Improvement
Components: Storage
Affects Versions: 1.4
Reporter: Martin Desruisseaux
Assignee: Martin Desruisseaux
Fix For: 1.5
{{SQLStore}} can connect to a SQL database conform to standards such as SQLMM
and Geopackage, infers the {{FeatureType}} from the tables stuctures,
automatically following the foreigner keys for complex features. But the
implementation has limitations that need to be improved:
* {{java.time}} objects need to be formatted as SQL dates.
* The {{raster_columns}} table of PostGIS should be optional (currently, an
exception is thrown if missing).
* Add SRID argument when executing a {{ST_*}} function.
* When only a subset of the feature properties is requested, declare only that
subset in the SQL {{SELECT}} statement.
* Make more robust to cases where there is no information about the schema or
catalog.
* Make more robust to JDBC drivers having unsupported features (missing search
escape character, missing metadata about foreigner keys, unsupported estimation
of the number of rows).
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
