[Gvsig_usuarios] Error trabajando con tablas en Postgis

[Javier Scaravella]

Hola, no tengo idea si puede ser esto pero te tiro una linea de prueba.
He tenido problema con la escritura de atributos entre QGIS y GVSIG y la
cosa venía por la codificación de caracteres. Por defecto en QGIS te
pone UTF-8 y gvSIG usa Latin1 (no recuerdo el codigo ISO)
Saludos.ar
El jue, 29-01-2009 a las 08:43 +0100, José Plaza escribió:

> Buenas a todos. Es la primera vez que escribo a esta lista, aunque llevo 
> leyendo tiempo los mensajes. Trabajo en el Departamento de  catastro  de 
> un  Ayuntamiento y quisiera poner en marcha la utilización  de postgis y 
> programas de mantenimiento de cartografia  desde propramas opensource.
> 
> Existen programas bastante buenos, pero unos son más manejables que 
> otros. Llevo tiempo fijandome en Gvsig y he empezado a hacer pruebas con 
> el y Postgis. Estoy interesado en ello porque somos varios tocando 
> cartografia y trabajomos con shapes pero me gustaria centralizarlo. Pero 
> como he dicho cada uno tiene sus ventajas y siempre existe mucho de 
> subjetivo en ello.
> Yo me he manejado en edición con QGIS y me gusta su rapidez, pero tiene 
> problemas con el manejo de las tablas y los claves de las mismas según 
> me han dicho.
> Bueno al grano. Que el otro día instale el Gvisig y exporte la tabla a 
> PostGis y  seguidamente hice la prueba de edición con el  programa Qgis 
> y ahora pues no  puedo  abrir  la cartografia  modificada con Gvsig me 
> da el error de "Error abriendo el documento: Tabla de atributos: 
> catastro2006 postgis  ProjectTable"
> 
> Y mi pregunta es, como seria posible el uso de distintos programas 
> opensuorce para editar tablas en postgis, como Gvsig, Kosmos, Qgis, 
> Udig, sin que te de problemas con las tablas, las claves principales, 
> etc, etc. Y en este caso particular que ha pasada cuando he editado con 
> Qgis la cartografia cargada con Gvsig, me ha cambiado la proyección. 
> Ambos teinen la misma proyección.
> Buenos pues gracias por todo. Mando el fichero log para que lo veais.
> 
> 
> 
> documento de texto sencillo adjunto (gvSIG.log)
> 
> WARN AWT-EventQueue-1 com.iver.andami.PluginServices - Plugin com.iver.core -- No se encontr la traduccin para debe_estar_activada
> WARN AWT-EventQueue-1 com.iver.andami.PluginServices - Plugin com.iver.core -- No se encontr la traduccin para debe_estar_activada
> WARN AWT-EventQueue-1 com.iver.andami.PluginServices - Plugin com.iver.cit.gvsig.geoprocess -- No se encontr la traduccin para debera de estar activada
> WARN AWT-EventQueue-1 com.iver.andami.PluginServices - Plugin com.iver.gvsig.addeventtheme -- No se encontr la traduccin para debera de estar activada
> WARN AWT-EventQueue-1 com.iver.andami.PluginServices - Plugin com.iver.gvsig.datalocator -- No se encontr la traduccin para debera de estar activada
> WARN AWT-EventQueue-1 com.iver.andami.PluginServices - Plugin com.iver.gvsig.centerviewpoint -- No se encontr la traduccin para debera de estar activada
> WARN AWT-EventQueue-1 com.iver.andami.Launcher - Men sin posicin asignada - Capa/export_to/GML - org.gvsig.gpe.GPEWriterExtension
> WARN AWT-EventQueue-1 com.iver.andami.Launcher - Men sin posicin asignada - Capa/export_to/KML - org.gvsig.gpe.GPEWriterExtension
> WARN AWT-EventQueue-1 com.iver.andami.PluginServices - Plugin org.gvsig.scripting -- No se encontr la traduccin para script_sep
> WARN AWT-EventQueue-1 com.iver.andami.PluginServices - Plugin org.gvsig.gpe -- No se encontr la traduccin para GML
> WARN AWT-EventQueue-1 com.iver.andami.PluginServices - Plugin org.gvsig.gpe -- No se encontr la traduccin para GML
> WARN AWT-EventQueue-1 com.iver.andami.PluginServices - Plugin org.gvsig.gpe -- No se encontr la traduccin para KML
> WARN AWT-EventQueue-1 com.iver.andami.PluginServices - Plugin org.gvsig.gpe -- No se encontr la traduccin para KML
> DEBUG AWT-EventQueue-1 com.iver.andami.Launcher - Initializing extensions from com.iver.cit.gvsig
> INFO AWT-EventQueue-1 com.iver.cit.gvsig.IntializeApplicationExtension - gvSIG version: 1.1.2 (Build 1045)
> INFO AWT-EventQueue-1 com.iver.cit.gvsig.IntializeApplicationExtension -     gvSIG app exec path: H:\Archivos de programa\gvSIG_1.1.1\bin
> INFO AWT-EventQueue-1 com.iver.cit.gvsig.IntializeApplicationExtension -     gvSIG user app home: H:\Documents and Settings\plaza\gvSIG\
> INFO AWT-EventQueue-1 com.iver.cit.gvsig.IntializeApplicationExtension -     gvSIG extension path: H:\Archivos de programa\gvSIG_1.1.1\bin\gvSIG\extensiones
> INFO AWT-EventQueue-1 com.iver.cit.gvsig.IntializeApplicationExtension -     gvSIG locale language: spa
> INFO AWT-EventQueue-1 com.iver.cit.gvsig.IntializeApplicationExtension - OS name: Windows XP
> INFO AWT-EventQueue-1 com.iver.cit.gvsig.IntializeApplicationExtension -     arch:x86
> INFO AWT-EventQueue-1 com.iver.cit.gvsig.IntializeApplicationExtension -     version:5.1
> INFO AWT-EventQueue-1 com.iver.cit.gvsig.IntializeApplicationExtension - JAVA vendor: Sun Microsystems Inc.
> INFO AWT-EventQueue-1 com.iver.cit.gvsig.IntializeApplicationExtension -     version:1.5.0_12
> INFO AWT-EventQueue-1 com.iver.cit.gvsig.IntializeApplicationExtension -     home: H:\Archivos de programa\Java\jre1.5.0_12
> WARN AWT-EventQueue-1 org.gvsig.i18n.Messages - org.cresques.ui Can't find bundle for base name org.cresques.translations.text, locale es
> WARN AWT-EventQueue-1 org.gvsig.i18n.Messages - org.cresques.ui Can't find bundle for base name org.cresques.translations.text_en, locale en
> ERROR AWT-EventQueue-1 com.iver.cit.gvsig.fmap.layers.LayerFactory - 
> java.lang.NoClassDefFoundError: oracle/sql/Datum
> 	at java.lang.Class.getDeclaredConstructors0(Native Method)
> 	at java.lang.Class.privateGetDeclaredConstructors(Unknown Source)
> 	at java.lang.Class.getConstructor0(Unknown Source)
> 	at java.lang.Class.newInstance0(Unknown Source)
> 	at java.lang.Class.newInstance(Unknown Source)
> 	at com.hardcode.driverManager.DriverManager.loadDrivers(Unknown Source)
> 	at com.iver.cit.gvsig.fmap.layers.LayerFactory.initializeDriverManager(Unknown Source)
> 	at com.iver.cit.gvsig.fmap.layers.LayerFactory.setDriversPath(Unknown Source)
> 	at com.iver.cit.gvsig.ProjectExtension.initialize(Unknown Source)
> 	at com.iver.andami.Launcher.initializeExtensions(Unknown Source)
> 	at com.iver.andami.Launcher.access$400(Unknown Source)
> 	at com.iver.andami.Launcher$4.run(Unknown Source)
> 	at java.awt.event.InvocationEvent.dispatch(Unknown Source)
> 	at java.awt.EventQueue.dispatchEvent(Unknown Source)
> 	at com.iver.andami.ui.AndamiEventQueue.dispatchEvent(Unknown Source)
> 	at java.awt.EventDispatchThread.pumpOneEventForHierarchy(Unknown Source)
> 	at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
> 	at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
> 	at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
> 	at java.awt.EventDispatchThread.run(Unknown Source)
> DEBUG AWT-EventQueue-1 com.iver.andami.Launcher - Initializing extensions from org.gvsig.scripting
> DEBUG AWT-EventQueue-1 com.iver.andami.Launcher - Initializing extensions from org.gvsig.gpe
> DEBUG AWT-EventQueue-1 com.iver.andami.Launcher - Initializing extensions from org.gvsig.georeferencing
> DEBUG AWT-EventQueue-1 com.iver.andami.Launcher - Initializing extensions from org.gvsig.rasterTools
> DEBUG AWT-EventQueue-1 com.iver.andami.Launcher - Initializing extensions from com.iver.cit.gvsig.jdbc_spatial
> DEBUG AWT-EventQueue-1 com.iver.andami.Launcher - Initializing extensions from com.iver.cit.gvsig.geoprocess
> DEBUG AWT-EventQueue-1 com.iver.andami.Launcher - Initializing extensions from org.gvsig.crs
> DEBUG AWT-EventQueue-1 com.iver.andami.Launcher - Initializing extensions from com.iver.core
> INFO AWT-EventQueue-1 com.iver.andami.messages.NotificationManager - Se aade un listener al manager de notificaciones
> INFO AWT-EventQueue-1 com.iver.andami.messages.NotificationManager - Se aade un listener al manager de notificaciones
> INFO AWT-EventQueue-1 com.iver.andami.messages.NotificationManager - Se aade un listener al manager de notificaciones
> DEBUG AWT-EventQueue-1 com.iver.andami.Launcher - Initializing extensions from com.iver.cit.gvsig.annotation
> DEBUG AWT-EventQueue-1 com.iver.andami.Launcher - Initializing extensions from es.gva.cit.gvsig.catalogClient
> WARN AWT-EventQueue-1 com.iver.andami.PluginServices - No se encontr la traduccin para Catalog
> DEBUG AWT-EventQueue-1 com.iver.andami.Launcher - Initializing extensions from com.iver.cit.gvsig.wms
> DEBUG AWT-EventQueue-1 com.iver.andami.Launcher - Initializing extensions from com.iver.gvsig.datalocator
> DEBUG AWT-EventQueue-1 com.iver.andami.Launcher - Initializing extensions from com.iver.gvsig.centerviewpoint
> DEBUG AWT-EventQueue-1 com.iver.andami.Launcher - Initializing extensions from com.iver.gvsig.addeventtheme
> DEBUG AWT-EventQueue-1 com.iver.andami.Launcher - Initializing extensions from com.iver.cit.gvsig.oracle_spatial
> ERROR AWT-EventQueue-1 es.prodevelop.cit.gvsig.jdbc_spatial.ExportOracleExtension - Unbale to instantiate ROWID (oracle jar missing?) : oracle.sql.ROWID
> INFO AWT-EventQueue-1 es.prodevelop.cit.gvsig.jdbc_spatial.ExportOracleExtension - *-----------------------------------------------------------------------*
> INFO AWT-EventQueue-1 es.prodevelop.cit.gvsig.jdbc_spatial.ExportOracleExtension - * Oracle library not found!                                             *
> INFO AWT-EventQueue-1 es.prodevelop.cit.gvsig.jdbc_spatial.ExportOracleExtension - * You need to place the Oracle JDBC library in gvSIG's main LIB folder. *
> INFO AWT-EventQueue-1 es.prodevelop.cit.gvsig.jdbc_spatial.ExportOracleExtension - * Read the Oracle driver user manual for details.                       *
> INFO AWT-EventQueue-1 es.prodevelop.cit.gvsig.jdbc_spatial.ExportOracleExtension - *-----------------------------------------------------------------------*
> DEBUG AWT-EventQueue-1 es.prodevelop.cit.gvsig.jdbc_spatial.OraEpsgTableLoader - createOracleEpsgTable() -- fdsa = es.prodevelop.cit.gvsig.fmap.drivers.jdbc.oracle.OFileDataSourceAdapter en bebb88
> DEBUG AWT-EventQueue-1 com.iver.andami.Launcher - Initializing extensions from com.iver.cit.gvsig.wcs
> DEBUG AWT-EventQueue-1 com.iver.andami.Launcher - Initializing extensions from es.prodevelop.cit.gvsig.arcims
> DEBUG AWT-EventQueue-1 com.iver.andami.Launcher - Initializing extensions from com.iver.cit.gvsig.cad
> DEBUG AWT-EventQueue-1 com.iver.andami.Launcher - Initializing extensions from com.iver.cit.gvsig.geoprocessextensions
> DEBUG AWT-EventQueue-1 com.iver.andami.Launcher - Initializing extensions from com.iver.gvsig.expresionfield
> DEBUG AWT-EventQueue-1 com.iver.andami.Launcher - Initializing extensions from com.iver.cit.gvsig.wfs2
> WARN AWT-EventQueue-1 com.iver.andami.PluginServices - Plugin com.iver.core -- No se encontr la traduccin para Gestor de proyectos
> WARN AWT-EventQueue-1 com.iver.andami.PluginServices - Plugin com.iver.core -- No se encontr la traduccin para Gestor de proyectos
> WARN AWT-EventQueue-1 com.iver.andami.PluginServices - Plugin com.iver.core -- No se encontr la traduccin para Activa la ventana
> DEBUG AWT-EventQueue-1 com.iver.core.mdiManager.NewSkin - Activando Gestor de proyectos
> WARN AWT-EventQueue-1 com.iver.andami.PluginServices - No se encontr la traduccin para GPE
> DEBUG AWT-EventQueue-1 com.iver.andami.ui.mdiFrame.MDIFrame - Memoria total: 28 MB
> DEBUG AWT-EventQueue-1 com.iver.andami.ui.mdiFrame.MDIFrame - Execute command:ABRIR
> DEBUG AWT-EventQueue-1 com.iver.andami.ui.mdiFrame.MDIFrame - Memoria total: 29 MB
> DEBUG AWT-EventQueue-1 com.iver.cit.gvsig.fmap.layers.FLayers - layer: Capa WMS PNOA loaded. 16 msecs.
> INFO AWT-EventQueue-1 com.hardcode.gdbms.engine.data.AutomaticDataSource - timer start
> DEBUG AWT-EventQueue-1 com.iver.cit.gvsig.fmap.layers.FLayers - layer: catastro2006 postgis loaded. 5266 msecs.
> INFO AWT-EventQueue-1 com.hardcode.gdbms.engine.data.AutomaticDataSource - timer start
> INFO AWT-EventQueue-1 com.hardcode.gdbms.engine.data.AutomaticDataSource - timer reset
> INFO AWT-EventQueue-1 com.hardcode.gdbms.engine.data.AutomaticDataSource - datasource closed
> INFO AWT-EventQueue-1 com.hardcode.gdbms.engine.data.AutomaticDataSource - timer start
> INFO AWT-EventQueue-1 com.hardcode.gdbms.engine.data.AutomaticDataSource - timer reset
> INFO AWT-EventQueue-1 com.hardcode.gdbms.engine.data.AutomaticDataSource - datasource closed
> DEBUG AWT-EventQueue-1 com.iver.cit.gvsig.fmap.layers.FLayers - layer: parcela.shp loaded. 31 msecs.
> DEBUG AWT-EventQueue-1 com.iver.cit.gvsig.fmap.layers.FLayers - layer: Capa WMS Catastro loaded. 0 msecs.
> INFO AWT-EventQueue-1 com.hardcode.gdbms.engine.data.AutomaticDataSource - timer start
> INFO AWT-EventQueue-1 com.hardcode.gdbms.engine.data.AutomaticDataSource - timer reset
> INFO AWT-EventQueue-1 com.hardcode.gdbms.engine.data.AutomaticDataSource - datasource closed
> INFO AWT-EventQueue-1 com.hardcode.gdbms.engine.data.AutomaticDataSource - timer start
> INFO AWT-EventQueue-1 com.hardcode.gdbms.engine.data.AutomaticDataSource - timer reset
> INFO AWT-EventQueue-1 com.hardcode.gdbms.engine.data.AutomaticDataSource - datasource closed
> DEBUG AWT-EventQueue-1 com.iver.cit.gvsig.fmap.layers.FLayers - layer: CARTO NUEVA.shp loaded. 31 msecs.
> INFO Thread-9 com.hardcode.gdbms.engine.data.AutomaticDataSource - datasource closed
> DEBUG AWT-EventQueue-1 com.iver.andami.messages.NotificationManager - Error abriendo el documento: Tabla de atributos: catastro2006 postgis
>   ProjectTable
> 
> java.lang.NullPointerException
> 	at com.iver.cit.gvsig.fmap.edition.EditableAdapter.initalizeFields(Unknown Source)
> 	at com.iver.cit.gvsig.fmap.edition.EditableAdapter.setOriginalDataSource(Unknown Source)
> 	at com.iver.cit.gvsig.project.documents.table.ProjectTable.setSelectableDataSource(Unknown Source)
> 	at com.iver.cit.gvsig.project.documents.table.ProjectTable.setXMLEntity(Unknown Source)
> 	at com.iver.cit.gvsig.project.Project.createFromXML(Unknown Source)
> 	at com.iver.cit.gvsig.ProjectExtension.readProject(Unknown Source)
> 	at com.iver.cit.gvsig.ProjectExtension.readProject(Unknown Source)
> 	at com.iver.cit.gvsig.ProjectExtension.execute(Unknown Source)
> 	at com.iver.andami.plugins.ExtensionDecorator.execute(Unknown Source)
> 	at com.iver.andami.ui.mdiFrame.MDIFrame.actionPerformed(Unknown Source)
> 	at javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
> 	at javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source)
> 	at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)
> 	at javax.swing.DefaultButtonModel.setPressed(Unknown Source)
> 	at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(Unknown Source)
> 	at java.awt.AWTEventMulticaster.mouseReleased(Unknown Source)
> 	at java.awt.AWTEventMulticaster.mouseReleased(Unknown Source)
> 	at java.awt.Component.processMouseEvent(Unknown Source)
> 	at javax.swing.JComponent.processMouseEvent(Unknown Source)
> 	at java.awt.Component.processEvent(Unknown Source)
> 	at java.awt.Container.processEvent(Unknown Source)
> 	at java.awt.Component.dispatchEventImpl(Unknown Source)
> 	at java.awt.Container.dispatchEventImpl(Unknown Source)
> 	at java.awt.Component.dispatchEvent(Unknown Source)
> 	at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
> 	at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
> 	at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
> 	at java.awt.Container.dispatchEventImpl(Unknown Source)
> 	at java.awt.Window.dispatchEventImpl(Unknown Source)
> 	at java.awt.Component.dispatchEvent(Unknown Source)
> 	at java.awt.EventQueue.dispatchEvent(Unknown Source)
> 	at com.iver.andami.ui.AndamiEventQueue.dispatchEvent(Unknown Source)
> 	at java.awt.EventDispatchThread.pumpOneEventForHierarchy(Unknown Source)
> 	at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
> 	at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
> 	at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
> 	at java.awt.EventDispatchThread.run(Unknown Source)
> INFO AWT-EventQueue-1 com.hardcode.gdbms.engine.data.AutomaticDataSource - timer start
> INFO AWT-EventQueue-1 com.hardcode.gdbms.engine.data.AutomaticDataSource - timer reset
> INFO AWT-EventQueue-1 com.hardcode.gdbms.engine.data.AutomaticDataSource - datasource closed
> INFO AWT-EventQueue-1 com.hardcode.gdbms.engine.data.AutomaticDataSource - timer start
> WARN AWT-EventQueue-1 com.iver.andami.PluginServices - Plugin com.iver.core -- No se encontr la traduccin para Gestor de proyectos
> WARN AWT-EventQueue-1 com.iver.andami.PluginServices - Plugin com.iver.core -- No se encontr la traduccin para Gestor de proyectos
> WARN AWT-EventQueue-1 com.iver.andami.PluginServices - Plugin com.iver.core -- No se encontr la traduccin para Activa la ventana
> DEBUG AWT-EventQueue-1 com.iver.core.mdiManager.NewSkin - Activando Gestor de proyectos
> DEBUG AWT-EventQueue-1 com.iver.andami.ui.mdiFrame.MDIFrame - Memoria total: 31 MB
> DEBUG AWT-EventQueue-1 com.iver.core.mdiManager.NewSkin - Activando Gestor de proyectos
> WARN AWT-EventQueue-1 com.iver.andami.PluginServices - Plugin com.iver.core -- No se encontr la traduccin para Vista : cartografia alhaurin el grande
> WARN AWT-EventQueue-1 com.iver.andami.PluginServices - Plugin com.iver.core -- No se encontr la traduccin para Vista : cartografia alhaurin el grande
> WARN AWT-EventQueue-1 com.iver.andami.PluginServices - Plugin com.iver.core -- No se encontr la traduccin para Activa la ventana
> DEBUG AWT-EventQueue-1 com.iver.core.mdiManager.NewSkin - Activando Vista : cartografia alhaurin el grande
> DEBUG AWT-EventQueue-1 com.iver.andami.ui.mdiFrame.MDIFrame - Memoria total: 32 MB
> DEBUG AWT-EventQueue-1 com.iver.core.mdiManager.NewSkin - Activando Vista : cartografia alhaurin el grande
> DEBUG AWT-EventQueue-1 com.iver.andami.ui.mdiFrame.MDIFrame - Memoria total: 32 MB
> DEBUG AWT-EventQueue-1 com.iver.andami.ui.mdiFrame.MDIFrame - Memoria total: 32 MB
> INFO Thread-15 com.hardcode.gdbms.engine.data.AutomaticDataSource - datasource closed
> INFO AWT-EventQueue-1 com.iver.cit.gvsig.fmap.drivers.db.utils.SingleVectorialDBConnectionManager - Successfully closed all connections.
> DEBUG Thread-16 com.iver.andami.messages.NotificationManager - 
> [ FLyrWMS.drawFixedSize() ]  Failed in trying 1/5)
> 
> _______________________________________________
> gvSIG_usuarios mailing list
> gvSIG_usuarios en runas.cap.gva.es
> 
> Para ver histórico de mensajes, editar sus preferencias de usuario o darse de baja en esta lista, acuda a la siguiente dirección:
> 
> http://runas.cap.gva.es/mailman/listinfo/gvsig_usuarios
------------ próxima parte ------------
Se ha borrado un adjunto en formato HTML...
URL: http://runas.cap.gva.es/pipermail/gvsig_usuarios/attachments/20090129/b9ed42b2/attachment.htm