Cannot read features from SQL datastore with NaN numeric values
---------------------------------------------------------------
Key: GEOT-3421
URL: http://jira.codehaus.org/browse/GEOT-3421
Project: GeoTools
Issue Type: Bug
Components: data jdbc
Affects Versions: 2.7-RC1
Reporter: Clive Butler
Priority: Minor
SQL database columns of type NUMERIC support the special value NaN, but the
GeoTools SQL datastores map NUMERIC SQL types on to the Java BigDecimal class,
which specifically does not support NaN. Any attempt to read NUMERIC columns
with NaN values results in an exception, which is bad news. The same issue may
apply to non-NUMERIC floating point data types.
FYI, my environment is a GeoServer instance, and the style being applied to
features has a filter that is smart enough not to use the affected column
values (one of the columns is a pseudo feature type that is used to determine
the valid data columns). The exception being thrown is enough to cause
rendering to fail.
The workaround is to alter every NaN to be NULL using pgsql, but a fix to the
code would be much better.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://jira.codehaus.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
The ultimate all-in-one performance toolkit: Intel(R) Parallel Studio XE:
Pinpoint memory and threading errors before they happen.
Find and fix more than 250 security defects in the development cycle.
Locate bottlenecks in serial and parallel code that limit performance.
http://p.sf.net/sfu/intel-dev2devfeb
_______________________________________________
Geotools-devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geotools-devel
