Introducir datos en bbdd postgis

classic Classic list List threaded Threaded
4 messages Options
Reply | Threaded
Open this post in threaded view
|

Introducir datos en bbdd postgis

Dario Alvarez
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)


_______________________________________________
Kosmo mailing list
[hidden email]
http://lists.saig.es/mailman/listinfo/kosmo
Reply | Threaded
Open this post in threaded view
|

Re: Introducir datos en bbdd postgis

Paco Abato
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: [hidden email]



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
> [hidden email]
> 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
>  

_______________________________________________
Kosmo mailing list
[hidden email]
http://lists.saig.es/mailman/listinfo/kosmo

fabato.vcf (441 bytes) Download Attachment
Reply | Threaded
Open this post in threaded view
|

Re: 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: [hidden email]
>
>
>
> 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
>> [hidden email]
>> 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
> [hidden email]
> 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
[hidden email]
http://lists.saig.es/mailman/listinfo/kosmo
Reply | Threaded
Open this post in threaded view
|

RE: Introducir datos en bbdd postgis

Espeso Álvarez, Ricardo
In reply to this post by Dario Alvarez
Muchas gracias,
Parece que el problema es el que me indicais en el punto 2 pues postgis está instalado, pero no ha creado las tablas correspondientes a la geometría. Voy a intentar crear la bbdd de nuevo.

Gracias y un saludo


-----Mensaje original-----
De: [hidden email] [mailto:[hidden email]]En nombre de
Gabriel Bellido Pérez
Enviado el: martes, 07 de abril de 2009 11:38
Para: Lista de Kosmo
Asunto: Re: [Kosmo] Introducir datos en bbdd postgis


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: [hidden email]
>
>
>
> 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
>> [hidden email]
>> 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
> [hidden email]
> 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
[hidden email]
http://lists.saig.es/mailman/listinfo/kosmo
_______________________________________________
Kosmo mailing list
[hidden email]
http://lists.saig.es/mailman/listinfo/kosmo