gvSIG bugs #5605
Error al añadir capa a la copia de trabajo
| Status: | Closed | % Done: | 0% | |
|---|---|---|---|---|
| Priority: | Normal | Spent time: | - | |
| Assignee: |  Francisco Díaz Carsí | |||
| Category: | Database | |||
| Target version: | 2.6.0-3220 | |||
| Severity: | Minor | Add-on version: | ||
| gvSIG version: | 2.6.0 | Add-on build: | ||
| gvSIG build: | 3218 | Add-on resolve version: | ||
| Operative System: | Add-on resolve build: | |||
| Keywords: | Proyecto: | AYTOA 1 | ||
| Has patch: | Hito: | Fase 01 | ||
| Add-on name: | Unknown |
Description
La prueba se ha hecho en un repositorio en Oracle, accediendo a través de un servidor web local y con autenticación.
Se añade capa al TOC desde una tabla de Oracle correctamente, pero al intentar añadirla a la copia de trabajo sale el siguiente error:
WARN 1826600 VCSGisAddToWorkingCopy org.gvsig.vcsgis.lib.workspace.VCSGisWorkspaceImpl - Can't add features to 'ENT_161101_ACTUAL' in 'jdbc:h2:file:C:/Users/vicmon/Desktop/Control Versiones gvSIG/Pruebas repositorio en Oracle/3218/ct1_3218;MODE=PostgreSQL;SCHEMA=PUBLIC;ALLOW_LITERALS=ALL'.
org.gvsig.fmap.dal.feature.exception.StoreInsertFeatureException: Can't insert feature in store 'ENT_161101_ACTUAL'.
at org.gvsig.fmap.dal.feature.impl.DefaultFeatureStore.insert(DefaultFeatureStore.java:1529)
at org.gvsig.vcsgis.lib.workspace.VCSGisWorkspaceImpl.addNewTable(VCSGisWorkspaceImpl.java:1065)
at org.gvsig.vcsgis.lib.workspace.VCSGisWorkspaceImpl.add(VCSGisWorkspaceImpl.java:1005)
at org.gvsig.vcsgis.lib.workspace.VCSGisWorkspaceImpl.add(VCSGisWorkspaceImpl.java:997)
at org.gvsig.vcsgis.swing.impl.addToWorkspace.VCSGisJAddToWorkspaceImpl.add(VCSGisJAddToWorkspaceImpl.java:365)
at org.gvsig.vcsgis.app.VCSGisExtension.lambda$showAddToWorkspaceDialog$1(VCSGisExtension.java:193)
at org.gvsig.vcsgis.app.VCSGisDialogsHelper$VCSGisDialogInfo.performDialogAction(VCSGisDialogsHelper.java:86)
at org.gvsig.vcsgis.app.VCSGisDialogsHelper$VCSGisDialogInfo.lambda$null$0(VCSGisDialogsHelper.java:140)
at java.lang.Thread.run(Unknown Source)
Caused by: java.lang.RuntimeException: Can't insert feature.
at org.gvsig.fmap.dal.store.jdbc2.spi.operations.AppendOperation.append(AppendOperation.java:220)
at org.gvsig.fmap.dal.store.jdbc2.spi.JDBCStoreProviderBase.append(JDBCStoreProviderBase.java:621)
at org.gvsig.fmap.dal.feature.impl.DefaultFeatureStore.insert(DefaultFeatureStore.java:1501)
... 8 more
Caused by: org.h2.jdbc.JdbcBatchUpdateException: Violación de Check constraint: "NVL2 = 25830)
AND ((PUBLIC.ST_GEOMETRYTYPECODE(AA_GEOM) = 0)
AND (PUBLIC.ST_COORDDIM(AA_GEOM) = 2))), TRUE)"
Check constraint violation: "NVL2 = 25830)
AND ((PUBLIC.ST_GEOMETRYTYPECODE(AA_GEOM) = 0)
AND (PUBLIC.ST_COORDDIM(AA_GEOM) = 2))), TRUE)"; SQL statement:
INSERT INTO "ENT_161101_ACTUAL" ( "MSLINK", "SIGLA", "NOMBRE", "AA_GEOM", "VCSGISCODE" ) VALUES ( ?, ?, ?, ST_GeomFromWKB((?), (?)), ? ) [23513-196]
at org.h2.jdbc.JdbcPreparedStatement.executeBatch(JdbcPreparedStatement.java:1234)
at org.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:297)
at org.gvsig.fmap.dal.store.jdbc2.JDBCUtils.executeBatch(JDBCUtils.java:205)
at org.gvsig.fmap.dal.store.jdbc2.spi.operations.AppendOperation.executeBatch(AppendOperation.java:231)
at org.gvsig.fmap.dal.store.jdbc2.spi.operations.AppendOperation.append(AppendOperation.java:205)
... 10 more
Se crea la tabla en el repositorio local pero vacía.
Related issues
Associated revisions
refs #5605 Changes made to distinguish between database tables or views and to know which ones are modifiable or not
refs #5605 Changes made to distinguish between database tables or views and to know which ones are modifiable or not
refs #5605 Improved getting the geometry type and subtype
refs #5605 Fixed unknown geometry type register. Improved wizard for vectorial database layers.
Se han realizado modificaciones relacionadas con:
- refs #5605, para soportar cargar vistas de BBDD como capas.
- LLevado al API el componente de seleccion de entidades y implantado en los dialogos en que se seleccionan entidades.
refs #5605 Fixed notification label in TableInfoController
History
#1
Updated by Joaquín del Cerro Murciano over 3 years ago
- Target version set to 2.6.0-3219
#2
Updated by Joaquín del Cerro Murciano over 3 years ago
- Hito set to Fase 01
- gvSIG build set to 3218
- Target version deleted (
2.6.0-3219)
#3
Updated by Joaquín del Cerro Murciano over 3 years ago
- Target version set to 2.6.0-3219
#4
Updated by Joaquín del Cerro Murciano over 3 years ago
- Related to gvSIG bugs #5610: Falla la gestion de transacciones sobre mas de una tabla. added
#5
Updated by Victor Montes Camara over 3 years ago
- Status changed from New to Awaiting response
- File ENT_010101_ACTUAL.sql added
Adjunto el contenido de una tabla de las que está dando error.
Se corresponde al límite de municipio y son sólo 7 registros.
#6
Updated by Joaquín del Cerro Murciano over 3 years ago
- Assignee set to Francisco Díaz Carsí
- Status changed from Awaiting response to In progress
- Category set to Database
Parece ser que el problema se da cuando se esta trabajando con una vista (SQL), o con una tabla de Oracle que no esta dada de alta en SDO_USERS_GEOM_METADATA y GEOMETRY_COLUMNS.
gvSIG desktop consulta en estas tablas para recabar datos sobre proyeccion y tipo de geometria entre otros, y al no encontrarla falla y carga la tabla con la informacion geografica incompleta.
Se esta modificando el dialogo de añadir capa para que el usuario pueda indicar toda la informacion necesaria para cargar la capa aunque no exista esta en los metadados de la BBDD.
#7
Updated by Francisco Díaz Carsí over 3 years ago
- Status changed from In progress to Fixed
#8
Updated by Joaquín del Cerro Murciano about 3 years ago
- Target version changed from 2.6.0-3219 to 2.6.0-3221
#9
Updated by Joaquín del Cerro Murciano about 3 years ago
- Target version changed from 2.6.0-3221 to 2.6.0-3220
#10
Updated by Álvaro Anguix about 3 years ago
- Status changed from Fixed to Closed