<HTML><HEAD><TITLE>Re: [Gvsig_english] gvSIG, Oracle Spatial and Views</TITLE>
<META http-equiv=Content-Type content="text/html; charset=unicode">
<META content="MSHTML 6.00.6000.16981" name=GENERATOR></HEAD>
<BODY>
<DIV id=idOWAReplyText90238>
<DIV><FONT face="Times New Roman" color=#000000 size=3>Hello, Wolfgang:</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV>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.</DIV>
<DIV>&nbsp;</DIV>
<DIV>I'm sorry, but I don't think you can add that view to gvSIG. Only tables and&nbsp;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.</DIV>
<DIV>&nbsp;</DIV>
<DIV>By the way, you have inserted the value 31468 as the SRID, but that's not the Oracle code:</DIV>
<DIV>&nbsp;</DIV>
<DIV>EPSG:31468 =&gt; SRID = 82032</DIV>
<DIV><FONT face="Times New Roman" color=#000000 size=3></FONT>&nbsp;</DIV>
<DIV>Regards,</DIV>
<DIV>&nbsp;</DIV></DIV>
<DIV id=idSignature14315>
<DIV><FONT face="Courier New" size=2><FONT face="Times New Roman" size=3>Juan Lucas Domínguez Rubio<BR></FONT>---</FONT></DIV>
<DIV><FONT face="Courier New" size=2><FONT face="Courier New" size=2><FONT face="Courier New" size=2>Prodevelop SL, Valencia (España)</FONT></DIV>
<DIV>
<DIV><FONT face="Courier New" size=2>Tlf.: 96.351.06.12 -- Fax: 96.351.09.68<BR></FONT><A href="http://www.prodevelop.es/"><FONT face="Courier New" size=2>http://www.prodevelop.es</FONT></A><BR><FONT face="Courier New" size=2>---</FONT></DIV></FONT></DIV></FONT></DIV>
<DIV><BR>
<HR>
<FONT face=Tahoma size=2><B>De:</B> gvsig_internacional-bounces@listserv.gva.es en nombre de Wolfgang Qual<BR><B>Enviado el:</B> lun 22/02/2010 15:31<BR><B>Para:</B> gvsig_internacional@listserv.gva.es<BR><B>Asunto:</B> Re: [Gvsig_english] gvSIG, Oracle Spatial and Views<BR></FONT><BR></DIV>
<DIV><BR>
<P><FONT size=2>Dear Juan Lucas,<BR>first of all: thank you very much for the detailed reply.<BR><BR>My colleague did the following:<BR><BR>1) select rowid from&nbsp; UIS_GIS_MUC_MOBILFUNKANL_V_R<BR>and he got<BR>NULL<BR>NULL<BR>NULL<BR>...<BR><BR>2) insert into user_sdo_geom_metadata values(<BR>'UIS_GIS_MUC_MOBILFUNKANL_V_R','GEOM',mdsys.sdo_dim_array(mdsys.sdo_dim_element(<BR>'X', 4356000, 4612000, 0.0005),mdsys.sdo_dim_element( 'Y', 5240000, 5496000,<BR>0.0005),mdsys.sdo_dim_element( 'Z', -1000, 1000, 0.0005)),31468)<BR>/<BR><BR>Afterwards, I tried to load that view again. now, the table (view) is listed<BR>under "add layer" &gt; geoBD, .. tables. However, when I click on the layers<BR>name in order to activate it (still within the add-layer dialogue), an error<BR>message appears<BR><BR>on the error console:<BR>java.lang.NullPointerException java.lang.NullPointerException: null Â Â Â Â<BR>com.prodevelop.cit.gvsig.vectorialdb.wizard.TablesListItem.activate(TablesListItem.java:92)<BR>   Â<BR>com.prodevelop.cit.gvsig.vectorialdb.wizard.AvailableTablesCheckBoxList$1.mousePressed(AvailableTablesCheckBoxList.java:91)<BR>    java.awt.AWTEventMulticaster.mousePressed(Unknown Source) Â Â Â Â<BR>java.awt.Component.processMouseEvent(Unknown Source) Â Â Â Â<BR>javax.swing.JComponent.processMouseEvent(Unknown Source) Â Â Â Â<BR>java.awt.Component.processEvent(Unknown Source) Â Â Â Â<BR>java.awt.Container.processEvent(Unknown Source) Â Â Â Â<BR>java.awt.Component.dispatchEventImpl(Unknown Source) Â Â Â Â<BR>java.awt.Container.dispatchEventImpl(Unknown Source) Â Â Â Â<BR>java.awt.Component.dispatchEvent(Unknown Source) Â Â Â Â<BR>java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source) Â Â Â Â<BR>java.awt.LightweightDispatcher.processMouseEvent(Unknown Source) Â Â Â Â<BR>java.awt.LightweightDispatcher.dispatchEvent(Unknown Source) Â Â Â Â<BR>java.awt.Container.dispatchEventImpl(Unknown Source) Â Â Â Â<BR>java.awt.Window.dispatchEventImpl(Unknown Source) Â Â Â Â<BR>java.awt.Component.dispatchEvent(Unknown Source) Â Â Â Â<BR>java.awt.EventQueue.dispatchEvent(Unknown Source) Â Â Â Â<BR>com.iver.andami.ui.AndamiEventQueue.dispatchEvent(AndamiEventQueue.java:58)<BR>    java.awt.EventDispatchThread.pumpOneEventForHierarchy(Unknown<BR>Source) Â Â Â Â java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown<BR>Source) Â Â Â Â java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown<BR>Source) Â Â Â Â java.awt.Dialog$1.run(Unknown Source) Â Â Â Â<BR>java.awt.Dialog$2.run(Unknown Source) Â Â Â Â<BR>java.security.AccessController.doPrivileged(Native Method) Â Â Â Â<BR>java.awt.Dialog.show(Unknown Source) Â Â Â Â java.awt.Component.show(Unknown<BR>Source) Â Â Â Â java.awt.Component.setVisible(Unknown Source) Â Â Â Â<BR>com.iver.core.mdiManager.NewSkin.addJDialog(NewSkin.java:447) Â Â Â Â<BR>com.iver.core.mdiManager.NewSkin.addWindow(NewSkin.java:234) Â Â Â Â<BR>com.iver.cit.gvsig.AddLayer.addLayers(AddLayer.java:277) Â Â Â Â<BR>com.iver.cit.gvsig.AddLayer.execute(AddLayer.java:178) Â Â Â Â<BR>com.iver.andami.plugins.ExtensionDecorator.execute(ExtensionDecorator.java:89)<BR>   Â<BR>com.iver.andami.ui.mdiFrame.MDIFrame.actionPerformed(MDIFrame.java:673) Â Â<BR>  javax.swing.AbstractButton.fireActionPerformed(Unknown Source) Â Â Â Â<BR>javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source) Â Â Â Â<BR>javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source) Â Â Â Â<BR>javax.swing.DefaultButtonModel.setPressed(Unknown Source) Â Â Â Â<BR>javax.swing.plaf.basic.BasicButtonListener.mouseReleased(Unknown Source) Â Â<BR>  java.awt.AWTEventMulticaster.mouseReleased(Unknown Source) Â Â Â Â<BR>java.awt.AWTEventMulticaster.mouseReleased(Unknown Source) Â Â Â Â<BR>java.awt.Component.processMouseEvent(Unknown Source) Â Â Â Â<BR>javax.swing.JComponent.processMouseEvent(Unknown Source) Â Â Â Â<BR>java.awt.Component.processEvent(Unknown Source) Â Â Â Â<BR>java.awt.Container.processEvent(Unknown Source) Â Â Â Â<BR>java.awt.Component.dispatchEventImpl(Unknown Source) Â Â Â Â<BR>java.awt.Container.dispatchEventImpl(Unknown Source) Â Â Â Â<BR>java.awt.Component.dispatchEvent(Unknown Source) Â Â Â Â<BR>java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source) Â Â Â Â<BR>java.awt.LightweightDispatcher.processMouseEvent(Unknown Source) Â Â Â Â<BR>java.awt.LightweightDispatcher.dispatchEvent(Unknown Source) Â Â Â Â<BR>java.awt.Container.dispatchEventImpl(Unknown Source) Â Â Â Â<BR>java.awt.Window.dispatchEventImpl(Unknown Source) Â Â Â Â<BR>java.awt.Component.dispatchEvent(Unknown Source) Â Â Â Â<BR>java.awt.EventQueue.dispatchEvent(Unknown Source) Â Â Â Â<BR>com.iver.andami.ui.AndamiEventQueue.dispatchEvent(AndamiEventQueue.java:58)<BR>    java.awt.EventDispatchThread.pumpOneEventForHierarchy(Unknown<BR>Source) Â Â Â Â java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown<BR>Source) Â Â Â Â java.awt.EventDispatchThread.pumpEvents(Unknown Source) Â Â<BR>  java.awt.EventDispatchThread.pumpEvents(Unknown Source) Â Â Â Â<BR>java.awt.EventDispatchThread.run(Unknown Source)<BR><BR><BR><BR>and on the command line:<BR>java.sql.SQLException: Listener refused the connection with the following<BR>error:<BR>ORA-12505, TNS:listener does not currently know of SID given in connect<BR>descriptor<BR>The Connection descriptor used by the client was:<BR>stones.rgu.muenchen.de:1521:uis_gis_muc_mobilfunkanl_v_r<BR><BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at<BR>oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at<BR>oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:261)<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:387)<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at<BR>oracle.jdbc.driver.PhysicalConnection.&lt;init&gt;(PhysicalConnection.java:414)<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at oracle.jdbc.driver.T4CConnection.&lt;init&gt;(T4CConnection.java:165)<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at<BR>oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:35)<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:801)<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at java.sql.DriverManager.getConnection(Unknown Source)<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at java.sql.DriverManager.getConnection(Unknown Source)<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at<BR>com.iver.cit.gvsig.fmap.drivers.ConnectionJDBC.setDataConnection(ConnectionJDBC.java:126)<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at<BR>com.iver.cit.gvsig.fmap.drivers.ConnectionFactory.createConnection(ConnectionFactory.java:78)<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at<BR>com.iver.cit.gvsig.fmap.drivers.db.utils.ConnectionWithParams.connect(ConnectionWithParams.java:144)<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at<BR>com.prodevelop.cit.gvsig.vectorialdb.wizard.WizardVectorialDB.tryToConnect(WizardVectorialDB.java:513)<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at<BR>com.prodevelop.cit.gvsig.vectorialdb.wizard.WizardVectorialDB.actionPerformed(WizardVectorialDB.java:471)<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at javax.swing.JComboBox.fireActionEvent(Unknown Source)<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at javax.swing.JComboBox.setSelectedItem(Unknown Source)<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at javax.swing.JComboBox.setSelectedIndex(Unknown Source)<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at<BR>javax.swing.plaf.basic.BasicComboPopup$Handler.mouseReleased(Unknown Source)<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at java.awt.AWTEventMulticaster.mouseReleased(Unknown Source)<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at java.awt.Component.processMouseEvent(Unknown Source)<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at javax.swing.JComponent.processMouseEvent(Unknown Source)<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at<BR>javax.swing.plaf.basic.BasicComboPopup$1.processMouseEvent(Unknown Source)<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at java.awt.Component.processEvent(Unknown Source)<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at java.awt.Container.processEvent(Unknown Source)<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at java.awt.Component.dispatchEventImpl(Unknown Source)<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at java.awt.Container.dispatchEventImpl(Unknown Source)<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at java.awt.Component.dispatchEvent(Unknown Source)<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at java.awt.Container.dispatchEventImpl(Unknown Source)<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at java.awt.Component.dispatchEvent(Unknown Source)<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at java.awt.EventQueue.dispatchEvent(Unknown Source)<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at<BR>com.iver.andami.ui.AndamiEventQueue.dispatchEvent(AndamiEventQueue.java:58)<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at java.awt.EventDispatchThread.pumpOneEventForHierarchy(Unknown<BR>Source)<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown<BR>Source)<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown<BR>Source)<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at java.awt.Dialog$1.run(Unknown Source)<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at java.awt.Dialog$2.run(Unknown Source)<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at java.security.AccessController.doPrivileged(Native Method)<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at java.awt.Dialog.show(Unknown Source)<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at java.awt.Component.show(Unknown Source)<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at java.awt.Component.setVisible(Unknown Source)<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at com.iver.core.mdiManager.NewSkin.addJDialog(NewSkin.java:447)<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at com.iver.core.mdiManager.NewSkin.addWindow(NewSkin.java:234)<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at com.iver.cit.gvsig.AddLayer.addLayers(AddLayer.java:277)<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at com.iver.cit.gvsig.AddLayer.execute(AddLayer.java:178)<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at<BR>com.iver.andami.plugins.ExtensionDecorator.execute(ExtensionDecorator.java:89)<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at<BR>com.iver.andami.ui.mdiFrame.MDIFrame.actionPerformed(MDIFrame.java:673)<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at javax.swing.AbstractButton.fireActionPerformed(Unknown Source)<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at javax.swing.AbstractButton$Handler.actionPerformed(Unknown<BR>Source)<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown<BR>Source)<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at javax.swing.DefaultButtonModel.setPressed(Unknown Source)<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(Unknown<BR>Source)<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at java.awt.AWTEventMulticaster.mouseReleased(Unknown Source)<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at java.awt.AWTEventMulticaster.mouseReleased(Unknown Source)<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at java.awt.Component.processMouseEvent(Unknown Source)<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at javax.swing.JComponent.processMouseEvent(Unknown Source)<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at java.awt.Component.processEvent(Unknown Source)<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at java.awt.Container.processEvent(Unknown Source)<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at java.awt.Component.dispatchEventImpl(Unknown Source)<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at java.awt.Container.dispatchEventImpl(Unknown Source)<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at java.awt.Component.dispatchEvent(Unknown Source)<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at java.awt.Container.dispatchEventImpl(Unknown Source)<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at java.awt.Window.dispatchEventImpl(Unknown Source)<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at java.awt.Component.dispatchEvent(Unknown Source)<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at java.awt.EventQueue.dispatchEvent(Unknown Source)<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at<BR>com.iver.andami.ui.AndamiEventQueue.dispatchEvent(AndamiEventQueue.java:58)<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at java.awt.EventDispatchThread.pumpOneEventForHierarchy(Unknown<BR>Source)<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown<BR>Source)<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at java.awt.EventDispatchThread.pumpEvents(Unknown Source)<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at java.awt.EventDispatchThread.pumpEvents(Unknown Source)<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at java.awt.EventDispatchThread.run(Unknown Source)<BR>DEBUG [AWT-EventQueue-1] (MDIFrame.java:1057) - Memory usage 54762 KB<BR>DEBUG [AWT-EventQueue-1] (MDIFrame.java:1057) - Memory usage 54831 KB<BR>DEBUG [AWT-EventQueue-1] (MDIFrame.java:672) - Execute<BR>command:GESTOR_VECTORIALDB<BR>&nbsp;INFO [AWT-EventQueue-1] (SingleVectorialDBConnectionManager.java:246) -<BR>Connection successfully closed.<BR>DEBUG [AWT-EventQueue-1] (MDIFrame.java:1057) - Memory usage 56240 KB<BR>DEBUG [AWT-EventQueue-1] (MDIFrame.java:1057) - Memory usage 56311 KB<BR>DEBUG [AWT-EventQueue-1] (MDIFrame.java:672) - Execute command:<BR>DRIVER 0 : PostGIS JDBC Driver<BR>DRIVER CLASS 0 : interface<BR>com.iver.cit.gvsig.fmap.drivers.VectorialFileDriver<BR>DRIVER 1 : odbc<BR>DRIVER 2 : GDBMS HSQLDB driver<BR>DRIVER 3 : gdbms dbf driver<BR>DRIVER 4 : gvSIG DGN Memory Driver<BR>DRIVER 5 : mysql<BR>DRIVER 6 : gvSIG shp driver<BR>DRIVER 7 : gvSIG GML Memory Driver<BR>DRIVER 8 : postgresql<BR>DRIVER 9 : gvSIG DWG Memory Driver<BR>DRIVER 10 : mySQL JDBC Driver<BR>DRIVER 11 : Oracle Spatial Database Driver<BR>DRIVER 12 : gvSIG DXF Memory Driver<BR>DRIVER 13 : oracle<BR>DRIVER 14 : csv string<BR>DRIVER 15 : gvSIG KML Memory Driver<BR>&nbsp;WARN [AWT-EventQueue-1] (ServiceNamesPanel.java:378) - Property<BR>'arcims-servers' not found in XML file.<BR>&nbsp;WARN [AWT-EventQueue-1] (PluginServices.java:309) - Cannot find translation<BR>for wfs<BR>&nbsp;WARN [AWT-EventQueue-1] (PluginServices.java:309) - Cannot find translation<BR>for wfs<BR>&nbsp;WARN [AWT-EventQueue-1] (PluginServices.java:309) - Cannot find translation<BR>for wfs<BR>&nbsp;WARN [AWT-EventQueue-1] (PluginServices.java:309) - Cannot find translation<BR>for wfs<BR>&nbsp;WARN [AWT-EventQueue-1] (PluginServices.java:309) - Cannot find translation<BR>for wfs<BR>&nbsp;WARN [AWT-EventQueue-1] (PluginServices.java:309) - Cannot find translation<BR>for wfs<BR>DEBUG [AWT-EventQueue-1] (OracleSpatialDriver.java:2844) -<BR>======================================================<BR>DEBUG [AWT-EventQueue-1] (OracleSpatialDriver.java:2845) - =&nbsp;&nbsp;&nbsp;<BR>ALL_SDO_GEOM_METADATA&nbsp; (1 EVERY 10 TABLES) ========<BR>DEBUG [AWT-EventQueue-1] (OracleSpatialDriver.java:2846) -<BR>======================================================<BR>DEBUG [AWT-EventQueue-1] (OracleSpatialDriver.java:2857) - OWNER: UMSYS,<BR>TABLE_NAME: UIS_GIS_MUC_MOBILFUNKANL_V_R, COLUMN_NAME: GEOM, SRID: 31468<BR>DEBUG [AWT-EventQueue-1] (OracleSpatialDriver.java:2864) - DIMINFO:<BR>DIMENSIONS: 3<BR>DIMENSION 0: , NAME: X, MIN: 4356000, MAX: 4612000, TOL: 0.0005<BR>DIMENSION 1: , NAME: Y, MIN: 5240000, MAX: 5496000, TOL: 0.0005<BR>DIMENSION 2: , NAME: Z, MIN: -1000, MAX: 1000, TOL: 0.0005<BR>DEBUG [AWT-EventQueue-1] (OracleSpatialDriver.java:2865) - =========<BR>&nbsp;WARN [AWT-EventQueue-1] (PluginServices.java:309) - Cannot find translation<BR>for no_indexes_on_declared_geo_fields<BR>ERROR [AWT-EventQueue-1] (OracleSpatialDriver.java:2161) - Oracle Spatial<BR>code not found in table: 31468<BR>ERROR [AWT-EventQueue-1] (OracleSpatialDriver.java:2191) - Error with SQL<BR>statement. Unknown Oracle code: 31468<BR>DEBUG [AWT-EventQueue-1] (NotificationManager.java:104) -<BR>java.lang.NullPointerException<BR>java.lang.NullPointerException<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at<BR>com.prodevelop.cit.gvsig.vectorialdb.wizard.TablesListItem.activate(TablesListItem.java:92)<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at<BR>com.prodevelop.cit.gvsig.vectorialdb.wizard.AvailableTablesCheckBoxList$1.mousePressed(AvailableTablesCheckBoxList.java:91)<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at java.awt.AWTEventMulticaster.mousePressed(Unknown Source)<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at java.awt.Component.processMouseEvent(Unknown Source)<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at javax.swing.JComponent.processMouseEvent(Unknown Source)<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at java.awt.Component.processEvent(Unknown Source)<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at java.awt.Container.processEvent(Unknown Source)<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at java.awt.Component.dispatchEventImpl(Unknown Source)<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at java.awt.Container.dispatchEventImpl(Unknown Source)<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at java.awt.Component.dispatchEvent(Unknown Source)<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at java.awt.Container.dispatchEventImpl(Unknown Source)<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at java.awt.Window.dispatchEventImpl(Unknown Source)<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at java.awt.Component.dispatchEvent(Unknown Source)<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at java.awt.EventQueue.dispatchEvent(Unknown Source)<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at<BR>com.iver.andami.ui.AndamiEventQueue.dispatchEvent(AndamiEventQueue.java:58)<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at java.awt.EventDispatchThread.pumpOneEventForHierarchy(Unknown<BR>Source)<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown<BR>Source)<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown<BR>Source)<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at java.awt.Dialog$1.run(Unknown Source)<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at java.awt.Dialog$2.run(Unknown Source)<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at java.security.AccessController.doPrivileged(Native Method)<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at java.awt.Dialog.show(Unknown Source)<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at java.awt.Component.show(Unknown Source)<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at java.awt.Component.setVisible(Unknown Source)<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at com.iver.core.mdiManager.NewSkin.addJDialog(NewSkin.java:447)<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at com.iver.core.mdiManager.NewSkin.addWindow(NewSkin.java:234)<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at com.iver.cit.gvsig.AddLayer.addLayers(AddLayer.java:277)<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at com.iver.cit.gvsig.AddLayer.execute(AddLayer.java:178)<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at<BR>com.iver.andami.plugins.ExtensionDecorator.execute(ExtensionDecorator.java:89)<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at<BR>com.iver.andami.ui.mdiFrame.MDIFrame.actionPerformed(MDIFrame.java:673)<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at javax.swing.AbstractButton.fireActionPerformed(Unknown Source)<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at javax.swing.AbstractButton$Handler.actionPerformed(Unknown<BR>Source)<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown<BR>Source)<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at javax.swing.DefaultButtonModel.setPressed(Unknown Source)<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(Unknown<BR>Source)<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at java.awt.AWTEventMulticaster.mouseReleased(Unknown Source)<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at java.awt.AWTEventMulticaster.mouseReleased(Unknown Source)<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at java.awt.Component.processMouseEvent(Unknown Source)<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at javax.swing.JComponent.processMouseEvent(Unknown Source)<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at java.awt.Component.processEvent(Unknown Source)<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at java.awt.Container.processEvent(Unknown Source)<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at java.awt.Component.dispatchEventImpl(Unknown Source)<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at java.awt.Container.dispatchEventImpl(Unknown Source)<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at java.awt.Component.dispatchEvent(Unknown Source)<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at java.awt.Container.dispatchEventImpl(Unknown Source)<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at java.awt.Window.dispatchEventImpl(Unknown Source)<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at java.awt.Component.dispatchEvent(Unknown Source)<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at java.awt.EventQueue.dispatchEvent(Unknown Source)<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at<BR>com.iver.andami.ui.AndamiEventQueue.dispatchEvent(AndamiEventQueue.java:58)<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at java.awt.EventDispatchThread.pumpOneEventForHierarchy(Unknown<BR>Source)<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown<BR>Source)<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at java.awt.EventDispatchThread.pumpEvents(Unknown Source)<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at java.awt.EventDispatchThread.pumpEvents(Unknown Source)<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at java.awt.EventDispatchThread.run(Unknown Source)<BR>&nbsp;WARN [AWT-EventQueue-1] (PluginServices.java:136) - Plugin com.iver.core --<BR>Cannot find translation for Information console<BR>&nbsp;WARN [AWT-EventQueue-1] (PluginServices.java:136) - Plugin com.iver.core --<BR>Cannot find translation for Activate the window<BR>DEBUG [AWT-EventQueue-1] (NewSkin.java:411) - Activando Information console<BR>DEBUG [AWT-EventQueue-1] (MDIFrame.java:1057) - Memory usage 70127 KB<BR>DEBUG [AWT-EventQueue-1] (MDIFrame.java:1057) - Memory usage 71338 KB<BR>DEBUG [AWT-EventQueue-1] (MDIFrame.java:1057) - Memory usage 71338 KB<BR><BR><BR>It would be great, if you (or others) could threw a glance on this. I am<BR>lost.<BR><BR><BR>Best.<BR>Wolfgang<BR><BR><BR>--<BR>View this message in context: <A href="http://n2.nabble.com/gvSIG-Oracle-Spatial-and-Views-tp4611156p4612388.html">http://n2.nabble.com/gvSIG-Oracle-Spatial-and-Views-tp4611156p4612388.html</A><BR>Sent from the gvSIG international mailing list archive at Nabble.com.<BR>_______________________________________________<BR>Gvsig_internacional mailing list<BR>Gvsig_internacional@listserv.gva.es<BR><A href="http://listserv.gva.es/cgi-bin/mailman/listinfo/gvsig_internacional">http://listserv.gva.es/cgi-bin/mailman/listinfo/gvsig_internacional</A><BR></FONT></P></DIV></BODY></HTML>