Error viewing wms layer: 2 SRIDs in same layer ( not true) ) error: Operation
on two geometries with different SRIDs
--------------------------------------------------------------------------------------------------------------------
Key: GEOS-4452
URL: http://jira.codehaus.org/browse/GEOS-4452
Project: GeoServer
Issue Type: Bug
Components: WMS
Environment: Error viewing wms layer: 2 SRIDs in same layer ( not
true) ) error: operation on two geometries with different SRIDs
Reporter: Marc Benito
Assignee: Andrea Aime
Priority: Minor
Attachments: error_snapshot.JPG
Error viewing wms layer in geoserver.
I create 2 differents datastores (postGis stores) pointing to the same machine
( ex: Server1) accessing to different databases but with the same schema and
same table but with different SRIDs
Ex:
Server1 ( postgres) --> databaseBarcelona --> map.limit_line --> srid (
the_geom ) == 23031
Server2 ( postgres) --> databaseMadrid --> map.limit_line --> srid (
the_geom ) == 900913
When i acces to the first, the wms layer runs OK.
When i acces to the second. the wms layers report an ERROR:
org.postgresql.util.PSQLException: ERROR: Operation on two geometries with
different SRIDs
at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2062)
at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1795)
at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:479)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:353)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:252)
at
org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208)
at
org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208)
at
org.geotools.jdbc.JDBCFeatureReader.<init>(JDBCFeatureReader.java:147)
at
org.geotools.jdbc.JDBCFeatureSource.getReaderInternal(JDBCFeatureSource.java:557)
... 149 more
I Reproduce this error in 2 different enviroments:
- with the build 2.1 of 30-03-2011 --> 2.1-SNAPSHOT -->Subversion Revision:
15612
- with an old 2.1 build ( 2 months ago).
In both cases occurs the same.
I Founf a solution:
Change the name of the table:
When i changed the name of the table the second layers runs OK.
--
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
------------------------------------------------------------------------------
Create and publish websites with WebMatrix
Use the most popular FREE web apps or write code yourself;
WebMatrix provides all the features you need to develop and
publish your website. http://p.sf.net/sfu/ms-webmatrix-sf
_______________________________________________
Geoserver-devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-devel
