Hi,
This is probably a bug in that NaN is not being handled properly. That
said it would help to have the actual sql statement being executed. If
you turn up the logger "org.geotools.data.jdbc" to FINE, the sql
statement should appear on the console. If you could provide it that
would be helpful. Thanks.
-Justin
Tobia Di Pisa wrote:
> Hi all,
>
> I have already sent you a mail to explain the problem I have found
> inserting some data in a table,
> whose attributes are of type "double precision". The database to which
> the table belongs is of type PostGIS.
> As I have sad in the previous mail I have initially used the library
> geotools 2.4-RC0. Andrea Aime has
> answered me saying that this kind of library is too old and he suggested
> me to replace it with the trunk.
>
> For my project I have to use the stable version 2.5.3 with whom there is
> the same error.
>
> The code I am using now is the following:
>
>
> ...
>
> Map params = new HashMap();
> params.put("dbtype", "postgis"); //must be postgis
> params.put("host", "localhost"); //the name or ip address of the
> machine running PostGIS
> params.put("port", new Integer(5432)); //the port that PostGIS is
> running on (generally 5432)
> params.put("database", "testdb"); //the name of the database to
> connect to.
> params.put("user", "postgres"); //the user to connect with
> params.put("passwd", "tobaro"); //the password of the user.
>
> DataStore pgDataStore = DataStoreFinder.getDataStore(
> params);
> FeatureWriter aWriter = pgDataStore.getFeatureWriter("measurements",
> Transaction.AUTO_COMMIT);
>
>
> for(int y=0; y<measurements; y++){
> SimpleFeature aNewFeature = (SimpleFeature)aWriter.next();
>
>
> aNewFeature.setAttribute("dist", dist[y].doubleValue());
> aNewFeature.setAttribute("cond", cond[y].doubleValue());
>
> ...
>
> aWriter.write();
> }
>
> aWriter.close();
>
> ...
>
>
> The problem always concerns the case in which dist[y] or cond[y] contain
> 'NaN'.
> In this case the application finishes abruptly showing the following
> error in console:
>
>
> 25-mar-2009 17.56.00 org.geotools.data.jdbc.JDBCTextFeatureWriter doInsert
> GRAVE: SQL Exception writing geometry columnERROR: column "nan" does not
> exist
> org.postgresql.util.PSQLException: ERROR: column "nan" does not exist
> at
> org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1525)
> at
> org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1309)
> at
> org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188)
> at
> org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)
> at
> org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:340)
> at
> org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:286)
> at
> org.apache.commons.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:228)
> at
> org.geotools.data.jdbc.JDBCTextFeatureWriter.doInsert(JDBCTextFeatureWriter.java:117)
> at
> org.geotools.data.jdbc.JDBCFeatureWriter.write(JDBCFeatureWriter.java:216)
> at
> org.geotools.data.InProcessLockingManager$1.write(InProcessLockingManager.java:330)
> at test.NETcdfPGDataStore.main(NETcdfPGDataStore.java:261)
> 17:56:00,680 ERROR NETcdfPGDataStore:267 -
> org.geotools.data.DataSourceException: SQL Exception writing geometry
> columnERROR: column "nan" does not exist
>
>
> In all the other cases the records are correctly inserted in the table.
> Could you give me any indications to resolve this problem?
>
>
> Best regards,
> Tobia Di Pisa
>
>
> ------------------------------------------------------------------------
>
> ------------------------------------------------------------------------------
>
>
> ------------------------------------------------------------------------
>
> _______________________________________________
> Geotools-gt2-users mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/geotools-gt2-users
--
Justin Deoliveira
OpenGeo - http://opengeo.org
Enterprise support for open source geospatial.
------------------------------------------------------------------------------
_______________________________________________
Geotools-gt2-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geotools-gt2-users
