[Gvsig_english] gvSIG, Oracle Spatial and Views
Wolfgang Qual
Wolfgang.Qual at gmx.net
Mon Feb 22 15:31:07 CET 2010
Dear Juan Lucas,
first of all: thank you very much for the detailed reply.
My colleague did the following:
1) select rowid from UIS_GIS_MUC_MOBILFUNKANL_V_R
and he got
NULL
NULL
NULL
...
2) insert into user_sdo_geom_metadata values(
'UIS_GIS_MUC_MOBILFUNKANL_V_R','GEOM',mdsys.sdo_dim_array(mdsys.sdo_dim_element(
'X', 4356000, 4612000, 0.0005),mdsys.sdo_dim_element( 'Y', 5240000, 5496000,
0.0005),mdsys.sdo_dim_element( 'Z', -1000, 1000, 0.0005)),31468)
/
Afterwards, I tried to load that view again. now, the table (view) is listed
under "add layer" > geoBD, .. tables. However, when I click on the layers
name in order to activate it (still within the add-layer dialogue), an error
message appears
on the error console:
java.lang.NullPointerException java.lang.NullPointerException: null    Â
com.prodevelop.cit.gvsig.vectorialdb.wizard.TablesListItem.activate(TablesListItem.java:92)
   Â
com.prodevelop.cit.gvsig.vectorialdb.wizard.AvailableTablesCheckBoxList$1.mousePressed(AvailableTablesCheckBoxList.java:91)
    java.awt.AWTEventMulticaster.mousePressed(Unknown Source)    Â
java.awt.Component.processMouseEvent(Unknown Source) Â Â Â Â
javax.swing.JComponent.processMouseEvent(Unknown Source) Â Â Â Â
java.awt.Component.processEvent(Unknown Source) Â Â Â Â
java.awt.Container.processEvent(Unknown Source) Â Â Â Â
java.awt.Component.dispatchEventImpl(Unknown Source) Â Â Â Â
java.awt.Container.dispatchEventImpl(Unknown Source) Â Â Â Â
java.awt.Component.dispatchEvent(Unknown Source) Â Â Â Â
java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source) Â Â Â Â
java.awt.LightweightDispatcher.processMouseEvent(Unknown Source) Â Â Â Â
java.awt.LightweightDispatcher.dispatchEvent(Unknown Source) Â Â Â Â
java.awt.Container.dispatchEventImpl(Unknown Source) Â Â Â Â
java.awt.Window.dispatchEventImpl(Unknown Source) Â Â Â Â
java.awt.Component.dispatchEvent(Unknown Source) Â Â Â Â
java.awt.EventQueue.dispatchEvent(Unknown Source) Â Â Â Â
com.iver.andami.ui.AndamiEventQueue.dispatchEvent(AndamiEventQueue.java:58)
    java.awt.EventDispatchThread.pumpOneEventForHierarchy(Unknown
Source) Â Â Â Â java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown
Source) Â Â Â Â java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown
Source) Â Â Â Â java.awt.Dialog$1.run(Unknown Source) Â Â Â Â
java.awt.Dialog$2.run(Unknown Source) Â Â Â Â
java.security.AccessController.doPrivileged(Native Method) Â Â Â Â
java.awt.Dialog.show(Unknown Source) Â Â Â Â java.awt.Component.show(Unknown
Source) Â Â Â Â java.awt.Component.setVisible(Unknown Source) Â Â Â Â
com.iver.core.mdiManager.NewSkin.addJDialog(NewSkin.java:447) Â Â Â Â
com.iver.core.mdiManager.NewSkin.addWindow(NewSkin.java:234) Â Â Â Â
com.iver.cit.gvsig.AddLayer.addLayers(AddLayer.java:277) Â Â Â Â
com.iver.cit.gvsig.AddLayer.execute(AddLayer.java:178) Â Â Â Â
com.iver.andami.plugins.ExtensionDecorator.execute(ExtensionDecorator.java:89)
   Â
com.iver.andami.ui.mdiFrame.MDIFrame.actionPerformed(MDIFrame.java:673) Â Â
  javax.swing.AbstractButton.fireActionPerformed(Unknown Source)    Â
javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source) Â Â Â Â
javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source) Â Â Â Â
javax.swing.DefaultButtonModel.setPressed(Unknown Source) Â Â Â Â
javax.swing.plaf.basic.BasicButtonListener.mouseReleased(Unknown Source) Â Â
  java.awt.AWTEventMulticaster.mouseReleased(Unknown Source)    Â
java.awt.AWTEventMulticaster.mouseReleased(Unknown Source) Â Â Â Â
java.awt.Component.processMouseEvent(Unknown Source) Â Â Â Â
javax.swing.JComponent.processMouseEvent(Unknown Source) Â Â Â Â
java.awt.Component.processEvent(Unknown Source) Â Â Â Â
java.awt.Container.processEvent(Unknown Source) Â Â Â Â
java.awt.Component.dispatchEventImpl(Unknown Source) Â Â Â Â
java.awt.Container.dispatchEventImpl(Unknown Source) Â Â Â Â
java.awt.Component.dispatchEvent(Unknown Source) Â Â Â Â
java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source) Â Â Â Â
java.awt.LightweightDispatcher.processMouseEvent(Unknown Source) Â Â Â Â
java.awt.LightweightDispatcher.dispatchEvent(Unknown Source) Â Â Â Â
java.awt.Container.dispatchEventImpl(Unknown Source) Â Â Â Â
java.awt.Window.dispatchEventImpl(Unknown Source) Â Â Â Â
java.awt.Component.dispatchEvent(Unknown Source) Â Â Â Â
java.awt.EventQueue.dispatchEvent(Unknown Source) Â Â Â Â
com.iver.andami.ui.AndamiEventQueue.dispatchEvent(AndamiEventQueue.java:58)
    java.awt.EventDispatchThread.pumpOneEventForHierarchy(Unknown
Source) Â Â Â Â java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown
Source) Â Â Â Â java.awt.EventDispatchThread.pumpEvents(Unknown Source) Â Â
  java.awt.EventDispatchThread.pumpEvents(Unknown Source)    Â
java.awt.EventDispatchThread.run(Unknown Source)
and on the command line:
java.sql.SQLException: Listener refused the connection with the following
error:
ORA-12505, TNS:listener does not currently know of SID given in connect
descriptor
The Connection descriptor used by the client was:
stones.rgu.muenchen.de:1521:uis_gis_muc_mobilfunkanl_v_r
at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:261)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:387)
at
oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:414)
at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:165)
at
oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:35)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:801)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at
com.iver.cit.gvsig.fmap.drivers.ConnectionJDBC.setDataConnection(ConnectionJDBC.java:126)
at
com.iver.cit.gvsig.fmap.drivers.ConnectionFactory.createConnection(ConnectionFactory.java:78)
at
com.iver.cit.gvsig.fmap.drivers.db.utils.ConnectionWithParams.connect(ConnectionWithParams.java:144)
at
com.prodevelop.cit.gvsig.vectorialdb.wizard.WizardVectorialDB.tryToConnect(WizardVectorialDB.java:513)
at
com.prodevelop.cit.gvsig.vectorialdb.wizard.WizardVectorialDB.actionPerformed(WizardVectorialDB.java:471)
at javax.swing.JComboBox.fireActionEvent(Unknown Source)
at javax.swing.JComboBox.setSelectedItem(Unknown Source)
at javax.swing.JComboBox.setSelectedIndex(Unknown Source)
at
javax.swing.plaf.basic.BasicComboPopup$Handler.mouseReleased(Unknown Source)
at java.awt.AWTEventMulticaster.mouseReleased(Unknown Source)
at java.awt.Component.processMouseEvent(Unknown Source)
at javax.swing.JComponent.processMouseEvent(Unknown Source)
at
javax.swing.plaf.basic.BasicComboPopup$1.processMouseEvent(Unknown Source)
at java.awt.Component.processEvent(Unknown Source)
at java.awt.Container.processEvent(Unknown Source)
at java.awt.Component.dispatchEventImpl(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.EventQueue.dispatchEvent(Unknown Source)
at
com.iver.andami.ui.AndamiEventQueue.dispatchEvent(AndamiEventQueue.java:58)
at java.awt.EventDispatchThread.pumpOneEventForHierarchy(Unknown
Source)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown
Source)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown
Source)
at java.awt.Dialog$1.run(Unknown Source)
at java.awt.Dialog$2.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.awt.Dialog.show(Unknown Source)
at java.awt.Component.show(Unknown Source)
at java.awt.Component.setVisible(Unknown Source)
at com.iver.core.mdiManager.NewSkin.addJDialog(NewSkin.java:447)
at com.iver.core.mdiManager.NewSkin.addWindow(NewSkin.java:234)
at com.iver.cit.gvsig.AddLayer.addLayers(AddLayer.java:277)
at com.iver.cit.gvsig.AddLayer.execute(AddLayer.java:178)
at
com.iver.andami.plugins.ExtensionDecorator.execute(ExtensionDecorator.java:89)
at
com.iver.andami.ui.mdiFrame.MDIFrame.actionPerformed(MDIFrame.java:673)
at javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
at javax.swing.AbstractButton$Handler.actionPerformed(Unknown
Source)
at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown
Source)
at javax.swing.DefaultButtonModel.setPressed(Unknown Source)
at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(Unknown
Source)
at java.awt.AWTEventMulticaster.mouseReleased(Unknown Source)
at java.awt.AWTEventMulticaster.mouseReleased(Unknown Source)
at java.awt.Component.processMouseEvent(Unknown Source)
at javax.swing.JComponent.processMouseEvent(Unknown Source)
at java.awt.Component.processEvent(Unknown Source)
at java.awt.Container.processEvent(Unknown Source)
at java.awt.Component.dispatchEventImpl(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Window.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.EventQueue.dispatchEvent(Unknown Source)
at
com.iver.andami.ui.AndamiEventQueue.dispatchEvent(AndamiEventQueue.java:58)
at java.awt.EventDispatchThread.pumpOneEventForHierarchy(Unknown
Source)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown
Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.run(Unknown Source)
DEBUG [AWT-EventQueue-1] (MDIFrame.java:1057) - Memory usage 54762 KB
DEBUG [AWT-EventQueue-1] (MDIFrame.java:1057) - Memory usage 54831 KB
DEBUG [AWT-EventQueue-1] (MDIFrame.java:672) - Execute
command:GESTOR_VECTORIALDB
INFO [AWT-EventQueue-1] (SingleVectorialDBConnectionManager.java:246) -
Connection successfully closed.
DEBUG [AWT-EventQueue-1] (MDIFrame.java:1057) - Memory usage 56240 KB
DEBUG [AWT-EventQueue-1] (MDIFrame.java:1057) - Memory usage 56311 KB
DEBUG [AWT-EventQueue-1] (MDIFrame.java:672) - Execute command:
DRIVER 0 : PostGIS JDBC Driver
DRIVER CLASS 0 : interface
com.iver.cit.gvsig.fmap.drivers.VectorialFileDriver
DRIVER 1 : odbc
DRIVER 2 : GDBMS HSQLDB driver
DRIVER 3 : gdbms dbf driver
DRIVER 4 : gvSIG DGN Memory Driver
DRIVER 5 : mysql
DRIVER 6 : gvSIG shp driver
DRIVER 7 : gvSIG GML Memory Driver
DRIVER 8 : postgresql
DRIVER 9 : gvSIG DWG Memory Driver
DRIVER 10 : mySQL JDBC Driver
DRIVER 11 : Oracle Spatial Database Driver
DRIVER 12 : gvSIG DXF Memory Driver
DRIVER 13 : oracle
DRIVER 14 : csv string
DRIVER 15 : gvSIG KML Memory Driver
WARN [AWT-EventQueue-1] (ServiceNamesPanel.java:378) - Property
'arcims-servers' not found in XML file.
WARN [AWT-EventQueue-1] (PluginServices.java:309) - Cannot find translation
for wfs
WARN [AWT-EventQueue-1] (PluginServices.java:309) - Cannot find translation
for wfs
WARN [AWT-EventQueue-1] (PluginServices.java:309) - Cannot find translation
for wfs
WARN [AWT-EventQueue-1] (PluginServices.java:309) - Cannot find translation
for wfs
WARN [AWT-EventQueue-1] (PluginServices.java:309) - Cannot find translation
for wfs
WARN [AWT-EventQueue-1] (PluginServices.java:309) - Cannot find translation
for wfs
DEBUG [AWT-EventQueue-1] (OracleSpatialDriver.java:2844) -
======================================================
DEBUG [AWT-EventQueue-1] (OracleSpatialDriver.java:2845) - =
ALL_SDO_GEOM_METADATA (1 EVERY 10 TABLES) ========
DEBUG [AWT-EventQueue-1] (OracleSpatialDriver.java:2846) -
======================================================
DEBUG [AWT-EventQueue-1] (OracleSpatialDriver.java:2857) - OWNER: UMSYS,
TABLE_NAME: UIS_GIS_MUC_MOBILFUNKANL_V_R, COLUMN_NAME: GEOM, SRID: 31468
DEBUG [AWT-EventQueue-1] (OracleSpatialDriver.java:2864) - DIMINFO:
DIMENSIONS: 3
DIMENSION 0: , NAME: X, MIN: 4356000, MAX: 4612000, TOL: 0.0005
DIMENSION 1: , NAME: Y, MIN: 5240000, MAX: 5496000, TOL: 0.0005
DIMENSION 2: , NAME: Z, MIN: -1000, MAX: 1000, TOL: 0.0005
DEBUG [AWT-EventQueue-1] (OracleSpatialDriver.java:2865) - =========
WARN [AWT-EventQueue-1] (PluginServices.java:309) - Cannot find translation
for no_indexes_on_declared_geo_fields
ERROR [AWT-EventQueue-1] (OracleSpatialDriver.java:2161) - Oracle Spatial
code not found in table: 31468
ERROR [AWT-EventQueue-1] (OracleSpatialDriver.java:2191) - Error with SQL
statement. Unknown Oracle code: 31468
DEBUG [AWT-EventQueue-1] (NotificationManager.java:104) -
java.lang.NullPointerException
java.lang.NullPointerException
at
com.prodevelop.cit.gvsig.vectorialdb.wizard.TablesListItem.activate(TablesListItem.java:92)
at
com.prodevelop.cit.gvsig.vectorialdb.wizard.AvailableTablesCheckBoxList$1.mousePressed(AvailableTablesCheckBoxList.java:91)
at java.awt.AWTEventMulticaster.mousePressed(Unknown Source)
at java.awt.Component.processMouseEvent(Unknown Source)
at javax.swing.JComponent.processMouseEvent(Unknown Source)
at java.awt.Component.processEvent(Unknown Source)
at java.awt.Container.processEvent(Unknown Source)
at java.awt.Component.dispatchEventImpl(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Window.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.EventQueue.dispatchEvent(Unknown Source)
at
com.iver.andami.ui.AndamiEventQueue.dispatchEvent(AndamiEventQueue.java:58)
at java.awt.EventDispatchThread.pumpOneEventForHierarchy(Unknown
Source)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown
Source)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown
Source)
at java.awt.Dialog$1.run(Unknown Source)
at java.awt.Dialog$2.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.awt.Dialog.show(Unknown Source)
at java.awt.Component.show(Unknown Source)
at java.awt.Component.setVisible(Unknown Source)
at com.iver.core.mdiManager.NewSkin.addJDialog(NewSkin.java:447)
at com.iver.core.mdiManager.NewSkin.addWindow(NewSkin.java:234)
at com.iver.cit.gvsig.AddLayer.addLayers(AddLayer.java:277)
at com.iver.cit.gvsig.AddLayer.execute(AddLayer.java:178)
at
com.iver.andami.plugins.ExtensionDecorator.execute(ExtensionDecorator.java:89)
at
com.iver.andami.ui.mdiFrame.MDIFrame.actionPerformed(MDIFrame.java:673)
at javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
at javax.swing.AbstractButton$Handler.actionPerformed(Unknown
Source)
at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown
Source)
at javax.swing.DefaultButtonModel.setPressed(Unknown Source)
at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(Unknown
Source)
at java.awt.AWTEventMulticaster.mouseReleased(Unknown Source)
at java.awt.AWTEventMulticaster.mouseReleased(Unknown Source)
at java.awt.Component.processMouseEvent(Unknown Source)
at javax.swing.JComponent.processMouseEvent(Unknown Source)
at java.awt.Component.processEvent(Unknown Source)
at java.awt.Container.processEvent(Unknown Source)
at java.awt.Component.dispatchEventImpl(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Window.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.EventQueue.dispatchEvent(Unknown Source)
at
com.iver.andami.ui.AndamiEventQueue.dispatchEvent(AndamiEventQueue.java:58)
at java.awt.EventDispatchThread.pumpOneEventForHierarchy(Unknown
Source)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown
Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.run(Unknown Source)
WARN [AWT-EventQueue-1] (PluginServices.java:136) - Plugin com.iver.core --
Cannot find translation for Information console
WARN [AWT-EventQueue-1] (PluginServices.java:136) - Plugin com.iver.core --
Cannot find translation for Activate the window
DEBUG [AWT-EventQueue-1] (NewSkin.java:411) - Activando Information console
DEBUG [AWT-EventQueue-1] (MDIFrame.java:1057) - Memory usage 70127 KB
DEBUG [AWT-EventQueue-1] (MDIFrame.java:1057) - Memory usage 71338 KB
DEBUG [AWT-EventQueue-1] (MDIFrame.java:1057) - Memory usage 71338 KB
It would be great, if you (or others) could threw a glance on this. I am
lost.
Best.
Wolfgang
--
View this message in context: http://n2.nabble.com/gvSIG-Oracle-Spatial-and-Views-tp4611156p4612388.html
Sent from the gvSIG international mailing list archive at Nabble.com.
More information about the Gvsig_internacional
mailing list