Re: [Kosmo] Introducir datos en bbdd postgis

[Gabriel Bellido Pérez]

Hola Darío,

Ampliando la información que mi compañero te ha dado:
1) Es posible que el error sea dado por que no has instalado postgis en 
la base de datos. En ese caso te recomendariamos reinstalar teniendo 
cuidado de que instalas la extension PostGIS en Postgres

2) Si tuvieras instalado postgis, la base de datos habría que crearla 
con el template1. Cuando en pgAdmin creas una base de datos hay una 
opcion llamada template. En esa opcion deberias elegir template1.

Parece ser, segun veo por el error, que o bien o no has creado la base 
de datos usando el template1 o  no has dado de alta la nueva tabla en 
"geometry_columns".

Una vez que nos hemos asegurado de que las condiciones 1 y 2 se cumplen, 
un buen truco para crear la tabla, puede ser crear un shape con la misma 
estructura que queremos para la tabla de la base de datos. Cargarlo en 
Kosmo, y sobre el arbol de capas, boton derecho sobre la capa y darle a 
"guardar como...".

Nos aparecera un dialogo y en formato podemos elegir "base de datos". 
Kosmo solo creará la tabla y dara de alta la tabla en "geometry_columns"

Espero que estas indicaciones te sirvan.

Un Saludo


Paco Abato escribió:
Hola Darío:

Ese error está indicando que la base de datos no tiene la extensión 
postgis. Fíjate que cuando una base de datos tiene el esquema postgis 
tiene como mínimo las tablas "geometry_columns" y "spatial_ref_sys".

Un saludo.

Francisco Abato Helguera

Programador
Sistemas Abiertos de Información Geográfica, S.L. (SAIG S.L.)
Teléfonos: + 34 955 567 170, +34 675 903 750
E-mail: fab...@saig.es



Dario Alvarez escribió:
Quiero introducir datos en unas tablas de postgis que de momento están
vacias. Pero cuando intento conectarme a la base de datos me da el 
siguiente
error.
a alguien se le ocurre ¿A qué puede deberse?y ¿Cómo podría 
solucionarlo?.


07/04/2009 09:45:23 ERROR JDBCPropertiesPanel:363 -
org.postgresql.util.PSQLException: ERROR: relation "geometry_columns" 
does
not exist

 at
org.postgresql.util.PSQLException.parseServerError(PSQLException.java:139) 

 at org.postgresql.core.QueryExecutor.executeV3(QueryExecutor.java:152)
 at org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:100)
 at org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:43)
 at
org.postgresql.jdbc1.AbstractJdbc1Statement.execute(AbstractJdbc1Statement.java:517) 

 at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:50) 

 at
org.postgresql.jdbc1.AbstractJdbc1Statement.executeQuery(AbstractJdbc1Statement.java:233) 

 at
org.postgresql.jdbc1.AbstractJdbc1Statement.executeQuery(AbstractJdbc1Statement.java:221) 

 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
 at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) 

 at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) 

 at java.lang.reflect.Method.invoke(Method.java:597)
 at
org.postgresql.jdbc2.optional.PooledConnectionImpl$StatementHandler.invoke(PooledConnectionImpl.java:392) 

 at $Proxy1.executeQuery(Unknown Source)
 at
org.saig.core.dao.datasource.dbdatasource.PostGisDataSource.getAllGeometriesTables(PostGisDataSource.java:2042) 

 at
org.saig.core.dao.datasource.dbdatasource.AbstractJDBCDataSource.getSchemas(AbstractJDBCDataSource.java:1482) 

 at
org.saig.jump.widgets.datasource.JDBCPropertiesPanel.checkConnection(JDBCPropertiesPanel.java:328) 

 at
org.saig.jump.widgets.datasource.JDBCPropertiesPanel.actionPerformed(JDBCPropertiesPanel.java:899) 

 at javax.swing.JComboBox.fireActionEvent(JComboBox.java:1242)
 at javax.swing.JComboBox.contentsChanged(JComboBox.java:1313)
 at
javax.swing.AbstractListModel.fireContentsChanged(AbstractListModel.java:100) 

 at
javax.swing.DefaultComboBoxModel.setSelectedItem(DefaultComboBoxModel.java:88) 

 at javax.swing.JComboBox.actionPerformed(JComboBox.java:1296)
 at
javax.swing.plaf.basic.BasicComboBoxUI$Handler.focusLost(BasicComboBoxUI.java:1725) 

 at java.awt.AWTEventMulticaster.focusLost(AWTEventMulticaster.java:213)
 at java.awt.AWTEventMulticaster.focusLost(AWTEventMulticaster.java:212)
 at java.awt.Component.processFocusEvent(Component.java:5930)
 at java.awt.Component.processEvent(Component.java:5794)
 at java.awt.Container.processEvent(Container.java:2058)
 at java.awt.Component.dispatchEventImpl(Component.java:4410)
 at java.awt.Container.dispatchEventImpl(Container.java:2116)
 at java.awt.Component.dispatchEvent(Component.java:4240)
 at
java.awt.KeyboardFocusManager.redispatchEvent(KeyboardFocusManager.java:1848) 

 at
java.awt.DefaultKeyboardFocusManager.typeAheadAssertions(DefaultKeyboardFocusManager.java:882) 

 at
java.awt.DefaultKeyboardFocusManager.dispatchEvent(DefaultKeyboardFocusManager.java:555) 

 at java.awt.Component.dispatchEventImpl(Component.java:4282)
 at java.awt.Container.dispatchEventImpl(Container.java:2116)
 at java.awt.Component.dispatchEvent(Component.java:4240)
 at java.awt.EventQueue.dispatchEvent(EventQueue.java:599)
 at
java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:273) 

 at
java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:183) 

 at
java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:177) 

 at java.awt.Dialog$1.run(Dialog.java:1039)
 at java.awt.Dialog$3.run(Dialog.java:1091)
 at java.security.AccessController.doPrivileged(Native Method)
 at java.awt.Dialog.show(Dialog.java:1089)
 at java.awt.Component.show(Component.java:1419)
 at java.awt.Component.setVisible(Component.java:1372)
 at java.awt.Window.setVisible(Window.java:801)
 at java.awt.Dialog.setVisible(Dialog.java:979)
 at
com.vividsolutions.jump.workbench.datasource.LoadDatasetPlugIn.execute(LoadDatasetPlugIn.java:135) 

 at
com.vividsolutions.jump.workbench.plugin.AbstractPlugIn$1.actionPerformed(AbstractPlugIn.java:125) 

 at 
javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1995)
 at
javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2318) 

 at
javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:387) 

 at 
javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:242)
 at
javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:236) 

 at 
java.awt.AWTEventMulticaster.mouseReleased(AWTEventMulticaster.java:272)
 at java.awt.Component.processMouseEvent(Component.java:6038)
 at javax.swing.JComponent.processMouseEvent(JComponent.java:3265)
 at java.awt.Component.processEvent(Component.java:5803)
 at java.awt.Container.processEvent(Container.java:2058)
 at java.awt.Component.dispatchEventImpl(Component.java:4410)
 at java.awt.Container.dispatchEventImpl(Container.java:2116)
 at java.awt.Component.dispatchEvent(Component.java:4240)
 at 
java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4322)
 at 
java.awt.LightweightDispatcher.processMouseEvent(Container.java:3986)
 at java.awt.LightweightDispatcher.dispatchEvent(Container.java:3916)
 at java.awt.Container.dispatchEventImpl(Container.java:2102)
 at java.awt.Window.dispatchEventImpl(Window.java:2429)
 at java.awt.Component.dispatchEvent(Component.java:4240)
 at java.awt.EventQueue.dispatchEvent(EventQueue.java:599)
 at
java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:273) 

 at
java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:183) 

 at
java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:173) 

 at 
java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:168)
 at 
java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:160)
 at java.awt.EventDispatchThread.run(EventDispatchThread.java:121)
07/04/2009 09:45:23 ERROR JDBCPropertiesPanel:363 -
org.postgresql.util.PSQLException: ERROR: relation "geometry_columns" 
does
not exist

 at
org.postgresql.util.PSQLException.parseServerError(PSQLException.java:139) 

 at org.postgresql.core.QueryExecutor.executeV3(QueryExecutor.java:152)
 at org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:100)
 at org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:43)
 at
org.postgresql.jdbc1.AbstractJdbc1Statement.execute(AbstractJdbc1Statement.java:517) 

 at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:50) 

 at
org.postgresql.jdbc1.AbstractJdbc1Statement.executeQuery(AbstractJdbc1Statement.java:233) 

 at
org.postgresql.jdbc1.AbstractJdbc1Statement.executeQuery(AbstractJdbc1Statement.java:221) 

 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
 at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) 

 at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) 

 at java.lang.reflect.Method.invoke(Method.java:597)
 at
org.postgresql.jdbc2.optional.PooledConnectionImpl$StatementHandler.invoke(PooledConnectionImpl.java:392) 

 at $Proxy1.executeQuery(Unknown Source)
 at
org.saig.core.dao.datasource.dbdatasource.PostGisDataSource.getAllGeometriesTables(PostGisDataSource.java:2042) 

 at
org.saig.core.dao.datasource.dbdatasource.AbstractJDBCDataSource.getSchemas(AbstractJDBCDataSource.java:1482) 

 at
org.saig.jump.widgets.datasource.JDBCPropertiesPanel.checkConnection(JDBCPropertiesPanel.java:328) 

 at
org.saig.jump.widgets.datasource.JDBCPropertiesPanel.actionPerformed(JDBCPropertiesPanel.java:899) 

 at javax.swing.JComboBox.fireActionEvent(JComboBox.java:1242)
 at javax.swing.JComboBox.actionPerformed(JComboBox.java:1299)
 at
javax.swing.plaf.basic.BasicComboBoxUI$Handler.focusLost(BasicComboBoxUI.java:1725) 

 at java.awt.AWTEventMulticaster.focusLost(AWTEventMulticaster.java:213)
 at java.awt.AWTEventMulticaster.focusLost(AWTEventMulticaster.java:212)
 at java.awt.Component.processFocusEvent(Component.java:5930)
 at java.awt.Component.processEvent(Component.java:5794)
 at java.awt.Container.processEvent(Container.java:2058)
 at java.awt.Component.dispatchEventImpl(Component.java:4410)
 at java.awt.Container.dispatchEventImpl(Container.java:2116)
 at java.awt.Component.dispatchEvent(Component.java:4240)
 at
java.awt.KeyboardFocusManager.redispatchEvent(KeyboardFocusManager.java:1848) 

 at
java.awt.DefaultKeyboardFocusManager.typeAheadAssertions(DefaultKeyboardFocusManager.java:882) 

 at
java.awt.DefaultKeyboardFocusManager.dispatchEvent(DefaultKeyboardFocusManager.java:555) 

 at java.awt.Component.dispatchEventImpl(Component.java:4282)
 at java.awt.Container.dispatchEventImpl(Container.java:2116)
 at java.awt.Component.dispatchEvent(Component.java:4240)
 at java.awt.EventQueue.dispatchEvent(EventQueue.java:599)
 at
java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:273) 

 at
java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:183) 

 at
java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:177) 

 at java.awt.Dialog$1.run(Dialog.java:1039)
 at java.awt.Dialog$3.run(Dialog.java:1091)
 at java.security.AccessController.doPrivileged(Native Method)
 at java.awt.Dialog.show(Dialog.java:1089)
 at java.awt.Component.show(Component.java:1419)
 at java.awt.Component.setVisible(Component.java:1372)
 at java.awt.Window.setVisible(Window.java:801)
 at java.awt.Dialog.setVisible(Dialog.java:979)
 at
com.vividsolutions.jump.workbench.datasource.LoadDatasetPlugIn.execute(LoadDatasetPlugIn.java:135) 

 at
com.vividsolutions.jump.workbench.plugin.AbstractPlugIn$1.actionPerformed(AbstractPlugIn.java:125) 

 at 
javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1995)
 at
javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2318) 

 at
javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:387) 

 at 
javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:242)
 at
javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:236) 

 at 
java.awt.AWTEventMulticaster.mouseReleased(AWTEventMulticaster.java:272)
 at java.awt.Component.processMouseEvent(Component.java:6038)
 at javax.swing.JComponent.processMouseEvent(JComponent.java:3265)
 at java.awt.Component.processEvent(Component.java:5803)
 at java.awt.Container.processEvent(Container.java:2058)
 at java.awt.Component.dispatchEventImpl(Component.java:4410)
 at java.awt.Container.dispatchEventImpl(Container.java:2116)
 at java.awt.Component.dispatchEvent(Component.java:4240)
 at 
java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4322)
 at 
java.awt.LightweightDispatcher.processMouseEvent(Container.java:3986)
 at java.awt.LightweightDispatcher.dispatchEvent(Container.java:3916)
 at java.awt.Container.dispatchEventImpl(Container.java:2102)
 at java.awt.Window.dispatchEventImpl(Window.java:2429)
 at java.awt.Component.dispatchEvent(Component.java:4240)
 at java.awt.EventQueue.dispatchEvent(EventQueue.java:599)
 at
java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:273) 

 at
java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:183) 

 at
java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:173) 

 at 
java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:168)
 at 
java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:160)
 at java.awt.EventDispatchThread.run(EventDispatchThread.java:121)
07/04/2009 09:45:31 ERROR JDBCPropertiesPanel:363 -
org.postgresql.util.PSQLException: ERROR: relation "geometry_columns" 
does
not exist

 at
org.postgresql.util.PSQLException.parseServerError(PSQLException.java:139) 

 at org.postgresql.core.QueryExecutor.executeV3(QueryExecutor.java:152)
 at org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:100)
 at org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:43)
 at
org.postgresql.jdbc1.AbstractJdbc1Statement.execute(AbstractJdbc1Statement.java:517) 

 at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:50) 

 at
org.postgresql.jdbc1.AbstractJdbc1Statement.executeQuery(AbstractJdbc1Statement.java:233) 

 at
org.postgresql.jdbc1.AbstractJdbc1Statement.executeQuery(AbstractJdbc1Statement.java:221) 

 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
 at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) 

 at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) 

 at java.lang.reflect.Method.invoke(Method.java:597)
 at
org.postgresql.jdbc2.optional.PooledConnectionImpl$StatementHandler.invoke(PooledConnectionImpl.java:392) 

 at $Proxy1.executeQuery(Unknown Source)
 at
org.saig.core.dao.datasource.dbdatasource.PostGisDataSource.getAllGeometriesTables(PostGisDataSource.java:2042) 

 at
org.saig.core.dao.datasource.dbdatasource.AbstractJDBCDataSource.getSchemas(AbstractJDBCDataSource.java:1482) 

 at
org.saig.jump.widgets.datasource.JDBCPropertiesPanel.checkConnection(JDBCPropertiesPanel.java:328) 

 at
org.saig.jump.widgets.datasource.JDBCPropertiesPanel.actionPerformed(JDBCPropertiesPanel.java:820) 

 at 
javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1995)
 at
javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2318) 

 at
javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:387) 

 at 
javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:242)
 at
javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:236) 

 at java.awt.Component.processMouseEvent(Component.java:6038)
 at javax.swing.JComponent.processMouseEvent(JComponent.java:3265)
 at java.awt.Component.processEvent(Component.java:5803)
 at java.awt.Container.processEvent(Container.java:2058)
 at java.awt.Component.dispatchEventImpl(Component.java:4410)
 at java.awt.Container.dispatchEventImpl(Container.java:2116)
 at java.awt.Component.dispatchEvent(Component.java:4240)
 at 
java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4322)
 at 
java.awt.LightweightDispatcher.processMouseEvent(Container.java:3986)
 at java.awt.LightweightDispatcher.dispatchEvent(Container.java:3916)
 at java.awt.Container.dispatchEventImpl(Container.java:2102)
 at java.awt.Window.dispatchEventImpl(Window.java:2429)
 at java.awt.Component.dispatchEvent(Component.java:4240)
 at java.awt.EventQueue.dispatchEvent(EventQueue.java:599)
 at
java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:273) 

 at
java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:183) 

 at
java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:177) 

 at java.awt.Dialog$1.run(Dialog.java:1039)
 at java.awt.Dialog$3.run(Dialog.java:1091)
 at java.security.AccessController.doPrivileged(Native Method)
 at java.awt.Dialog.show(Dialog.java:1089)
 at java.awt.Component.show(Component.java:1419)
 at java.awt.Component.setVisible(Component.java:1372)
 at java.awt.Window.setVisible(Window.java:801)
 at java.awt.Dialog.setVisible(Dialog.java:979)
 at
com.vividsolutions.jump.workbench.datasource.LoadDatasetPlugIn.execute(LoadDatasetPlugIn.java:135) 

 at
com.vividsolutions.jump.workbench.plugin.AbstractPlugIn$1.actionPerformed(AbstractPlugIn.java:125) 

 at 
javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1995)
 at
javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2318) 

 at
javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:387) 

 at 
javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:242)
 at
javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:236) 

 at 
java.awt.AWTEventMulticaster.mouseReleased(AWTEventMulticaster.java:272)
 at java.awt.Component.processMouseEvent(Component.java:6038)
 at javax.swing.JComponent.processMouseEvent(JComponent.java:3265)
 at java.awt.Component.processEvent(Component.java:5803)
 at java.awt.Container.processEvent(Container.java:2058)
 at java.awt.Component.dispatchEventImpl(Component.java:4410)
 at java.awt.Container.dispatchEventImpl(Container.java:2116)
 at java.awt.Component.dispatchEvent(Component.java:4240)
 at 
java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4322)
 at 
java.awt.LightweightDispatcher.processMouseEvent(Container.java:3986)
 at java.awt.LightweightDispatcher.dispatchEvent(Container.java:3916)
 at java.awt.Container.dispatchEventImpl(Container.java:2102)
 at java.awt.Window.dispatchEventImpl(Window.java:2429)
 at java.awt.Component.dispatchEvent(Component.java:4240)
 at java.awt.EventQueue.dispatchEvent(EventQueue.java:599)
 at
java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:273) 

 at
java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:183) 

 at
java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:173) 

 at 
java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:168)
 at 
java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:160)
 at java.awt.EventDispatchThread.run(EventDispatchThread.java:121)



__________ Información de NOD32, revisión 3991 (20090407) __________

Este mensaje ha sido analizado con NOD32 antivirus system
http://www.nod32.com

  
------------------------------------------------------------------------

_______________________________________________
Kosmo mailing list
Kosmo@saig.es
http://lists.saig.es/mailman/listinfo/kosmo



__________ Información de NOD32, revisión 3991 (20090407) __________

Este mensaje ha sido analizado con NOD32 antivirus system
http://www.nod32.com
  



__________ Información de ESET NOD32 Antivirus, versión de la base de 
firmas de virus 3991 (20090407) __________

ESET NOD32 Antivirus ha comprobado este mensaje.

http://www.eset.com

_______________________________________________
Kosmo mailing list
Kosmo@saig.es
http://lists.saig.es/mailman/listinfo/kosmo



__________ Información de ESET NOD32 Antivirus, versión de la base de firmas de 
virus 3991 (20090407) __________

ESET NOD32 Antivirus ha comprobado este mensaje.

http://www.eset.com

  

_______________________________________________
Kosmo mailing list
Kosmo@saig.es
http://lists.saig.es/mailman/listinfo/kosmo