Hi,
I just figured this one out. It is a problem with how you have postgis setup. Search the postgis mailing list and you will get some tips on how to fix it. Basically the SRID defined by the Geometry columns doesn't match that in the geometries in the table. You have to make them match.
Jesse On Sep 13, 2007, at 3:22 AM, 赵新元 wrote: HI,
I update UDig to udig-1.1.RC11.When I open a map, it can't display the map. I found some error on console. I found the error is : "Operation on two geometries with different SRIDs". The layer to display is a postgis spatial table, in the geometry-columns,I set the table SRID is 4326. I can't find the problem in udig-1.1-RC8. How can I do?
This the exception stack.
2007-9-13 16:44:23 org.geotools.data.jdbc.JDBC1DataStore executeQuery 严重: Error Performing SQL query: SELECT "gid", AsText(force_2d("the_geom")) FROM "public"."test_poi" WHERE "the_geom" && GeometryFromText('POLYGON ((116.32268676757779 39.890502548217775, 116.32268676757779 39.979999923706025, 116.4019531250002 39.979999923706025, 116.4019531250002 39.890502548217775, 116.32268676757779 39.890502548217775))', 4326) AND intersects("the_geom", GeometryFromText('POLYGON ((116.32268676757779 39.890502548217775, 116.32268676757779 39.979999923706025, 116.4019531250002 39.979999923706025, 116.4019531250002 39.890502548217775, 116.32268676757779 39.890502548217775))', 4326)) org.postgresql.util.PSQLException: 错误: Operation on two geometries with different SRIDs 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.executeQuery(AbstractJdbc2Statement.java:239) at sun.reflect.GeneratedMethodAccessor9.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at org.postgresql.ds.common.PooledConnectionImpl$StatementHandler.invoke(PooledConnectionImpl.java:474) at $Proxy24.executeQuery(Unknown Source) at org.geotools.data.jdbc.JDBC1DataStore.executeQuery(JDBC1DataStore.java:922) at org.geotools.data.jdbc.JDBC1DataStore.getFeatureReader(JDBC1DataStore.java:672) at org.geotools.data.jdbc.JDBCFeatureCollection.reader(JDBCFeatureCollection.java:78) at org.geotools.renderer.lite.StreamingRenderer.getReader(StreamingRenderer.java:1173) at org.geotools.renderer.lite.StreamingRenderer.processStylers(StreamingRenderer.java:1272) at org.geotools.renderer.lite.StreamingRenderer.paint(StreamingRenderer.java:464) at org.geotools.renderer.lite.StreamingRenderer.paint(StreamingRenderer.java:374) at net.refractions.udig.render.internal.feature.basic.BasicFeatureRenderer.render(BasicFeatureRenderer.java:309) at net.refractions.udig.render.internal.feature.basic.BasicFeatureRenderer.render(BasicFeatureRenderer.java:193) at net.refractions.udig.project.internal.render.impl.RenderExecutorImpl$RenderJob.startRendering(RenderExecutorImpl.java:315) at net.refractions.udig.project.internal.render.impl.RenderExecutorImpl$RenderJob.run(RenderExecutorImpl.java:396) at org.eclipse.core.internal.jobs.Worker.run(Worker.java:58)
_______________________________________________ User-friendly Desktop Internet GIS (uDig) |