gvSIG bugs #4272
Error al cargar capa postgis sin SRID
Status: | Closed | % Done: | 0% | |
---|---|---|---|---|
Priority: | Normal | Spent time: | - | |
Assignee: | Joaquín del Cerro Murciano | |||
Category: | Database | |||
Target version: | 2.4.0-2829 (rev. org.gvsig.desktop-2.0.195) | |||
Severity: | Minor | Add-on version: | ||
gvSIG version: | 2.3.0 | Add-on build: | ||
gvSIG build: | 2428 | Add-on resolve version: | ||
Operative System: | Add-on resolve build: | |||
Keywords: | Proyecto: | |||
Has patch: | Hito: | |||
Add-on name: | Unknown |
Description
Pasos a seguir para reproducir el bug:
- Tener una capa PostGIS que no tenga asignado SRID (se queda en 0)
- Crear una vista con el mismo sistema de coordenadas de la capa
- Cargar la capa sin especificar proyeccción
ERROR [MapControl Drawer Worker] (NotificationManager.java:90) - Exception reading 'tuneles_l'. org.gvsig.fmap.dal.exception.ReadException: Exception reading 'tuneles_l'. at org.gvsig.fmap.mapcontext.layers.vectorial.FLyrVect.draw(FLyrVect.java:325) at org.gvsig.fmap.mapcontext.impl.DefaultMapContextDrawer$DrawList.drawLayer(DefaultMapContextDrawer.java:549) at org.gvsig.fmap.mapcontext.impl.DefaultMapContextDrawer$DrawList.draw(DefaultMapContextDrawer.java:530) at org.gvsig.fmap.mapcontext.impl.DefaultMapContextDrawer$DrawList.drawLayers(DefaultMapContextDrawer.java:469) at org.gvsig.fmap.mapcontext.impl.DefaultMapContextDrawer.draw(DefaultMapContextDrawer.java:161) at org.gvsig.fmap.mapcontext.MapContext.draw(MapContext.java:1182) at org.gvsig.fmap.mapcontrol.MapControl$PaintingRequest.paint(MapControl.java:1344) at org.gvsig.fmap.mapcontrol.MapControl$Drawer$Worker.run(MapControl.java:1564) at java.lang.Thread.run(Thread.java:745) Caused by: org.gvsig.symbology.fmap.mapcontext.rendering.legend.impl.LegendDrawingException: Error while drawing the legend at org.gvsig.symbology.fmap.mapcontext.rendering.legend.impl.AbstractVectorialLegend.internalDraw(AbstractVectorialLegend.java:455) at org.gvsig.symbology.fmap.mapcontext.rendering.legend.impl.AbstractVectorialLegend.draw(AbstractVectorialLegend.java:338) at org.gvsig.symbology.fmap.mapcontext.rendering.legend.impl.AbstractVectorialLegend.draw(AbstractVectorialLegend.java:143) at org.gvsig.fmap.mapcontext.layers.vectorial.FLyrVect.draw(FLyrVect.java:309) ... 8 more Caused by: Error executing action in resource 'PostgreSQLResource(jdbc:postgresql://localhost:5432/carreteras,postgres)'. at org.gvsig.fmap.dal.resource.spi.AbstractNonBlockingResource.execute(AbstractNonBlockingResource.java:59) at org.gvsig.fmap.dal.store.jdbc.JDBCStoreProvider.createResultSet(JDBCStoreProvider.java:258) at org.gvsig.fmap.dal.store.jdbc.JDBCStoreProvider.createResultSet(JDBCStoreProvider.java:250) at org.gvsig.fmap.dal.store.jdbc.JDBCSetProvider.createFastIterator(JDBCSetProvider.java:353) at org.gvsig.fmap.dal.store.jdbc.JDBCSetProvider.createFastIterator(JDBCSetProvider.java:1) at org.gvsig.fmap.dal.feature.spi.AbstractFeatureSetProvider.fastIterator(AbstractFeatureSetProvider.java:98) at org.gvsig.fmap.dal.feature.spi.AbstractFeatureSetProvider.fastIterator(AbstractFeatureSetProvider.java:93) at org.gvsig.fmap.dal.feature.impl.featureset.FastDefaultIterator.<init>(FastDefaultIterator.java:52) at org.gvsig.fmap.dal.feature.impl.featureset.DefaultFeatureSet.fastIterator(DefaultFeatureSet.java:365) at org.gvsig.fmap.dal.feature.impl.featureset.DefaultFeatureSet.doAccept(DefaultFeatureSet.java:328) at org.gvsig.tools.visitor.impl.AbstractIndexedVisitable.doAccept(AbstractIndexedVisitable.java:63) at org.gvsig.tools.visitor.impl.AbstractVisitable.accept(AbstractVisitable.java:49) at org.gvsig.symbology.fmap.mapcontext.rendering.legend.impl.AbstractVectorialLegend.drawFeaturesSingleLayer(AbstractVectorialLegend.java:547) at org.gvsig.symbology.fmap.mapcontext.rendering.legend.impl.AbstractVectorialLegend.drawFeatures(AbstractVectorialLegend.java:529) at org.gvsig.symbology.fmap.mapcontext.rendering.legend.impl.AbstractVectorialLegend.internalDraw(AbstractVectorialLegend.java:447) ... 11 more Caused by: Error executing action in resource 'PostgreSQLResource(jdbc:postgresql://localhost:5432/carreteras,postgres)'. at org.gvsig.fmap.dal.resource.spi.AbstractNonBlockingResource.execute(AbstractNonBlockingResource.java:59) at org.gvsig.fmap.dal.store.jdbc.JDBCStoreProvider.createNewResultSet(JDBCStoreProvider.java:613) at org.gvsig.fmap.dal.store.jdbc.JDBCStoreProvider$2.run(JDBCStoreProvider.java:261) at org.gvsig.fmap.dal.resource.spi.AbstractResource.performExecution(AbstractResource.java:338) at org.gvsig.fmap.dal.resource.spi.AbstractNonBlockingResource.execute(AbstractNonBlockingResource.java:57) ... 25 more Caused by: org.gvsig.fmap.dal.store.jdbc.exception.JDBCExecutePreparedSQLException: An JDBC exception was throw when execute SQL: 'Select ST_AsEWKB("the_geom"), "gid" from "layers"."tuneles_l" where ( ST_intersects(ST_GeomFromText('POLYGON ((534580.2474786227 4194071.2699999004, 910663.8163247111 4194071.2699999004, 910663.8163247111 4519029.884421846, 534580.2474786227 4519029.884421846, 534580.2474786227 4194071.2699999004))', '25830'), ST_envelope("the_geom")) ) ' with params {unknow} at org.gvsig.fmap.dal.store.jdbc.JDBCStoreProvider$8.run(JDBCStoreProvider.java:662) at org.gvsig.fmap.dal.resource.spi.AbstractResource.performExecution(AbstractResource.java:338) at org.gvsig.fmap.dal.resource.spi.AbstractNonBlockingResource.execute(AbstractNonBlockingResource.java:57) ... 29 more Caused by: org.postgresql.util.PSQLException: ERROR: Operation on mixed SRID geometries at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2103) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1836) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:512) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:388) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:273) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:93) at org.gvsig.fmap.dal.store.jdbc.JDBCHelper.executeQuery(JDBCHelper.java:130) at org.gvsig.fmap.dal.store.jdbc.JDBCStoreProvider$8.run(JDBCStoreProvider.java:644) ... 31 more
La aplicación debería, como mínimo, que la capa no tiene especificado SRID
NOTA: si se fuerza a que reproyecte sí que funciona. Sólo es en el caso especificado
Associated revisions
History
#1 Updated by Joaquín del Cerro Murciano over 7 years ago
- Target version changed from 2.3.0-2447-final (rev. org.gvsig.desktop-2.0.153) to 2.4.0-2850-final (rev. org.gvsig.desktop-2.0.220)
#2 Updated by Joaquín del Cerro Murciano almost 7 years ago
- Target version changed from 2.4.0-2850-final (rev. org.gvsig.desktop-2.0.220) to 2.4.0-2829 (rev. org.gvsig.desktop-2.0.195)
- Assignee set to Joaquín del Cerro Murciano
- Status changed from New to Fixed
#3 Updated by Álvaro Anguix over 6 years ago
- Status changed from Fixed to Closed