[
https://issues.apache.org/jira/browse/SIS-608?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Martin Desruisseaux reassigned SIS-608:
---------------------------------------
> 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
> Priority: Major
> 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)
