Fetch size defaults to 0 in JDBCDataStore
-----------------------------------------
Key: GEOT-3825
URL: https://jira.codehaus.org/browse/GEOT-3825
Project: GeoTools
Issue Type: Bug
Components: jdbc, jdbc-postgis plugin
Affects Versions: 2.6.0
Reporter: Kostis Pristouris
Priority: Minor
When getting a JDBCDataStore with the minimum required parameters, the
fetchSize property is set to a default of 0 (zero). This has an adverse effect
on at least the jdbc-postgis plugin, where the JDBC driver loads the results of
queries fully into memory, instead of using a cursor.
A workaround is to explicitly set the parameter "fetch size" to a non-zero
value when creating the data store. A possible fix is maybe to set a hard-coded
default in the JDBCDataStore class ?
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
EMC VNX: the world's simplest storage, starting under $10K
The only unified storage solution that offers unified management
Up to 160% more powerful than alternatives and 25% more efficient.
Guaranteed. http://p.sf.net/sfu/emc-vnx-dev2dev
_______________________________________________
Geotools-devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geotools-devel
