gvSIG bugs #4272

Error al cargar capa postgis sin SRID

Added by José Badía almost 8 years ago. Updated over 6 years ago.

Status:Closed% Done:

0%

Priority:NormalSpent 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

Revision 43377
Added by Joaquín del Cerro Murciano almost 7 years ago

refs #4539, #4540, #4541, #4272, #4453, Corregidos varios errores en la carga de capas de BBDD (postgresql, spatialite, h2spatial) y en la exportacion a estos.

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

Also available in: Atom PDF