[Gvsig_english] gvSIG, Oracle Spatial and Views

Juan Lucas Dominguez Rubio jldominguez at prodevelop.es
Mon Feb 22 16:14:18 CET 2010 

Hello, Wolfgang:
 
I think you have found a bug. gvSIG should not allow you to choose a view if the view cannot provide a ROWID for its rows, or if at least one of the ROWIDs is null.
 
I'm sorry, but I don't think you can add that view to gvSIG. Only tables and simple views can be added to gvSIG. Perhaps you can create temporary tables using the same SQL that you used to create the view, but of course, editing those temporary tables will not update the original tables.
 
By the way, you have inserted the value 31468 as the SRID, but that's not the Oracle code:
 
EPSG:31468 => SRID = 82032
 
Regards,
 
Juan Lucas Domínguez Rubio
---
Prodevelop SL, Valencia (España)
Tlf.: 96.351.06.12 -- Fax: 96.351.09.68
http://www.prodevelop.es <http://www.prodevelop.es/> 
---

________________________________

De: gvsig_internacional-bounces at listserv.gva.es en nombre de Wolfgang Qual
Enviado el: lun 22/02/2010 15:31
Para: gvsig_internacional at listserv.gva.es
Asunto: Re: [Gvsig_english] gvSIG, Oracle Spatial and Views




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.
_______________________________________________
Gvsig_internacional mailing list
Gvsig_internacional at listserv.gva.es
http://listserv.gva.es/cgi-bin/mailman/listinfo/gvsig_internacional


-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://listserv.gva.es/pipermail/gvsig_internacional/attachments/20100222/ae244bec/attachment.htm

More information about the Gvsig_internacional mailing list