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.BasicFeatureRendere
r.render(BasicFeatureRenderer.java:309)
at
net.refractions.udig.render.internal.feature.basic.BasicFeatureRendere
r.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)
===============================================
快来和我一起享受TOM免费邮箱吧！ 看看除了1.5G，
还有什么？
看看女人都在聊什么? 美图尽赏 聊天世界
明星金曲免费送(http://mm.tom.com/ivr/)：周杰伦 林俊
杰 庞龙 张惠妹
劲爆歌曲尽情点(http://mm.tom.com/ivr/)：霍元甲 吉祥三
宝 人质 曹操
炫酷彩铃免费送(http://mm.tom.com/cailing/)：周杰伦帮你
接电话 麻烦女朋友 七里香 小城故事
===============================================
_______________________________________________
User-friendly Desktop Internet GIS (uDig)
http://udig.refractions.net
http://lists.refractions.net/mailman/listinfo/udig-devel
_______________________________________________
User-friendly Desktop Internet GIS (uDig)
http://udig.refractions.net
http://lists.refractions.net/mailman/listinfo/udig-devel
