I created a new empty table in PostgreSQL then imported that into a gvSIG project. I started editing the table insert a few rows wrote some values into fields then stopped the editing. After answering Yes to save the changes I got No se pudo guardar la edicion BR java.lang. IllegalStateException Can"t overwrite cause BR java.lang.Throwable.initCause(Unknown Source) BR com.iver.cit.gvsig.exceptions.visitors. ProcessWriterVisitorException. BR ( ProcessWriterVisitorException.java 11)
| OperatingSystem | None |
| BuildNumber | other |
| Resolution | Fixed |
| Severity | None |
| SubprojectName | gvSIG |
| Component | gvSIG - Tables |
| Version | gvSIG - 1.9.0 |
| SubprojectVersion | gvSIG - 1.9.0 |
| SubprojectResolveVersion | None |
| Has patch | None |
Category
Bugs
Login or create an account to comment.
Comments
Logged In: YES user_id=1799 2009-11-10 changed by mmadrid Do yo always get this message only sometimes only that time -------------------------------------------- 2009-11-10 changed by bducke I always get this message. I have tried this with different tables in different databases but always running on the same machine (PostgreSQL 8.4 on Ubuntu 9.10). Saving layers into a PostGIS-enabled DB works OK. But not simple PostgreSQL tables. Below are the last lines from my gvSIG.log file. It looks like there was a problem converting one of the field types. The table I used is very simple and only has two fields (no primary key auto values or any other constraints) pkey integer data character (100) --- DEBUG AWT- EventQueue-1 com.iver.andami.ui.mdiFrame.MDIFrame - Memory usage 62078 KB BR DEBUG AWT- EventQueue-1 com.iver.andami.ui.mdiFrame.MDIFrame - Execute command STOPEDITING BR DEBUG AWT- EventQueue-1 com.iver.andami.messages. NotificationManager - No se pudo guardar la edicion BR java.lang. ClassCastException com.hardcode.gdbms.engine.values. IntValue BR at com.iver.cit.gvsig.fmap.drivers.XTypes.updateValue( XTypes.java 205) BR at com.iver.cit.gvsig.fmap.edition.writers. JdbcWriter.process( JdbcWriter.java 77) BR at com.iver.cit.gvsig.fmap.edition. EditableAdapter.saveEdits( EditableAdapter.java 365) BR at com.iver.cit.gvsig.fmap.edition. EditableAdapter.stopEdition( EditableAdapter.java 272) BR at com.iver.cit.gvsig.project.documents.table.gui.Table.stopEditing( Table.java 730) BR at com.iver.cit.gvsig. TableEditStopExtension.stopEditing( TableEditStopExtension.java 71) BR at com.iver.cit.gvsig. TableEditStopExtension.execute( TableEditStopExtension.java 49) BR at com.iver.andami.plugins. ExtensionDecorator.execute( ExtensionDecorator.java 89) BR at com.iver.andami.ui.mdiFrame.MDIFrame.actionPerformed( MDIFrame.java 673) BR at javax.swing. AbstractButton.fire ActionPerformed(Unknown Source) BR at javax.swing. AbstractButton Handler.actionPerformed(Unknown Source) BR at javax.swing. DefaultButtonModel.fire ActionPerformed(Unknown Source) BR at javax.swing. DefaultButtonModel.setPressed(Unknown Source) BR at javax.swing. AbstractButton.doClick(Unknown Source) BR at javax.swing.plaf.basic.BasicMenuItemUI.doClick(Unknown Source) BR at javax.swing.plaf.basic.BasicMenuItemUI Handler.mouseReleased(Unknown Source) BR at java.awt.AWT EventMulticaster.mouseReleased(Unknown Source) BR at java.awt.Component.process MouseEvent(Unknown Source) BR at javax.swing.JComponent.process MouseEvent(Unknown Source) BR at java.awt.Component.processEvent(Unknown Source) BR at java.awt.Container.processEvent(Unknown Source) BR at java.awt.Component.dispatch EventImpl(Unknown Source) BR at java.awt.Container.dispatch EventImpl(Unknown Source) BR at java.awt.Component.dispatchEvent(Unknown Source) BR at java.awt. LightweightDispatcher.retarget MouseEvent(Unknown Source) BR at java.awt. LightweightDispatcher.process MouseEvent(Unknown Source) BR at java.awt. LightweightDispatcher.dispatchEvent(Unknown Source) BR at java.awt.Container.dispatch EventImpl(Unknown Source) BR at java.awt.Component.dispatchEvent(Unknown Source) BR at java.awt. EventQueue.dispatchEvent(Unknown Source) BR at com.iver.andami.ui. AndamiEventQueue.dispatchEvent( AndamiEventQueue.java 58) BR at java.awt. EventDispatchThread.pump OneEventForHierarchy(Unknown Source) BR at java.awt. EventDispatchThread.pump EventsForHierarchy(Unknown Source) BR at java.awt. EventDispatchThread.pumpEvents(Unknown Source) BR at java.awt. EventDispatchThread.pumpEvents(Unknown Source) BR at java.awt. EventDispatchThread.run(Unknown Source) BR DEBUG AWT- EventQueue-1 com.iver.core.mdiManager. NewSkin - Activando Information console BR DEBUG AWT- EventQueue-1 com.iver.andami.ui.mdiFrame.MDIFrame - Memory usage 65813 KB -------------------------------------------- 2009-11-10 changed by bducke OK I used type text instead of character for the data field and now saving works Give me a moment and I will try some more PostgreSQL data types. -------------------------------------------- 2009-11-10 changed by bducke It seems that both types character and character varying prevent gvSIG from saving a table. Although there is type text which works I think this should be treated as a bug since varchar is a very common field type and needs to be supported. -------------------------------------------- 2010-02-03 changed by pmercade owner changed from pmercade to vcaballero --------------------------------------------
Logged In: YES user_id=1799 Se corresponde con el ticket del iti 2740 Reported by bducke in date 2009-11-09
I self-aasigned this ticket as part of the EIEL-Pontevedra project, whose contribution hopefully will be consolidated in gvSIG 1.12
Unable to reproduce this bug after postgis-related improvements. Probably solved, needs tests.
Closing ticket. Unable to reproduce this bug after postgis-related improvements.