[Gvsig_english] Remarks and questions about gvSIG 1.1 (rc2)

Wolfgang Qual wolfgang.qual at gmx.net
Mon Aug 27 11:20:44 CEST 2007 

Hello Sergio, list,
regarding the "export to oracle"-function:
actually, the administrator of the oracle database had to change some of the 
permissions in order to allow me to write on that databse. Ok, so I gave it 
another try wih 1.1 (rc2) and 1.0.2.
1.1 was not successful at all. Nothing was written in the database. Comparing 
this to 1.0.2, I found out, that the export-dialogue of 1.1 seems to be not 
complete yet - at least, there is no dialogue, where I have to choose the 
database connection.

With 1.0.2, I was able to write something on the database. I can see the new 
enrty when using the ogrinfo-command on the command line (shell. The new enry 
is not visible in gvsig, but this another problem. It can be solved by 
creating a view I think). However, there seems to be an error during the 
export - the exported file on the database does not contain any records, only 
the definition of the attribute column. The section from gvSIG.log for the 
export-action:

INFO AWT-EventQueue-1 com.hardcode.gdbms.engine.data.AutomaticDataSource 
- timer start
INFO AWT-EventQueue-1 com.hardcode.gdbms.engine.data.AutomaticDataSource 
- timer reset
INFO AWT-EventQueue-1 com.hardcode.gdbms.engine.data.AutomaticDataSource 
- datasource closed
DEBUG AWT-EventQueue-1 com.iver.andami.ui.mdiFrame.MDIFrame - Memoria 
total: 31723688
DEBUG AWT-EventQueue-1 com.iver.andami.ui.mdiFrame.MDIFrame - Memoria 
total: 31774408
DEBUG AWT-EventQueue-1 com.iver.andami.ui.mdiFrame.MDIFrame - Memoria 
total: 34058504
DEBUG AWT-EventQueue-1 com.iver.andami.ui.mdiFrame.MDIFrame - Execute 
command:EXPORT_TO_ORACLE_SPATIAL
DEBUG AWT-EventQueue-1 
es.prodevelop.cit.gvsig.jdbc_spatial.gui.jdbcwizard.OracleConnectionChooserPanel 
- sel = availableConnectionsComboBox.getSelectedItem();
DEBUG AWT-EventQueue-1 
es.prodevelop.cit.gvsig.jdbc_spatial.gui.jdbcwizard.OracleConnectionChooserPanel 
- sel =
DEBUG AWT-EventQueue-1 
es.prodevelop.cit.gvsig.jdbc_spatial.gui.jdbcwizard.OracleConnectionChooserPanel 
- sel = availableConnectionsComboBox.getSelectedItem();
DEBUG AWT-EventQueue-1 
es.prodevelop.cit.gvsig.jdbc_spatial.gui.jdbcwizard.OracleConnectionChooserPanel 
- sel = [C] teste (Oracle Spatial Database Driver)
DEBUG AWT-EventQueue-1 
es.prodevelop.cit.gvsig.jdbc_spatial.gui.jdbcwizard.OracleConnectionChooserPanel 
- sel = availableConnectionsComboBox.getSelectedItem();
DEBUG AWT-EventQueue-1 
es.prodevelop.cit.gvsig.jdbc_spatial.gui.jdbcwizard.OracleConnectionChooserPanel 
- sel = [C] teste (Oracle Spatial Database Driver)
INFO AWT-EventQueue-1 com.hardcode.gdbms.engine.data.AutomaticDataSource 
- timer start
INFO AWT-EventQueue-1 com.hardcode.gdbms.engine.data.AutomaticDataSource 
- timer reset
INFO Thread-11 com.hardcode.gdbms.engine.data.AutomaticDataSource - 
datasource closed
INFO AWT-EventQueue-1 com.hardcode.gdbms.engine.data.AutomaticDataSource 
- timer start
ERROR AWT-EventQueue-1 
es.prodevelop.cit.gvsig.fmap.drivers.jdbc.oracle.OracleSpatialDriver - 
EPSG code not found in table: 31464
ERROR AWT-EventQueue-1 
es.prodevelop.cit.gvsig.fmap.drivers.jdbc.oracle.OracleSpatialDriver - 
Error with SQL statement. Unknown EPSG: 31464
INFO AWT-EventQueue-1 com.hardcode.gdbms.engine.data.AutomaticDataSource 
- timer start
ERROR AWT-EventQueue-1 
es.prodevelop.cit.gvsig.fmap.drivers.jdbc.oracle.OracleSpatialDriver - 
EPSG code not found in table: 31464
ERROR AWT-EventQueue-1 
es.prodevelop.cit.gvsig.fmap.drivers.jdbc.oracle.OracleSpatialDriver - 
Error with SQL statement. Unknown EPSG: 31464
WARN AWT-EventQueue-1 com.iver.andami.PluginServices - Konnte 
Übersetzung nicht finden für: PluginServices.Procesando
DEBUG AWT-EventQueue-1 com.iver.andami.ui.mdiFrame.MDIFrame - Memoria 
total: 38378624
DEBUG AWT-EventQueue-1 com.iver.andami.ui.mdiFrame.MDIFrame - Memoria 
total: 38429200
INFO Thread-14 com.hardcode.gdbms.engine.data.AutomaticDataSource - 
timer start
ERROR Thread-14 
es.prodevelop.cit.gvsig.fmap.drivers.jdbc.oracle.OracleSpatialDriver - 
EPSG code not found in table: 31464
ERROR Thread-14 
es.prodevelop.cit.gvsig.fmap.drivers.jdbc.oracle.OracleSpatialDriver - 
Error with SQL statement. Unknown EPSG: 31464
INFO Thread-14 
es.prodevelop.cit.gvsig.fmap.drivers.jdbc.oracle.OracleSpatialWriter - 
Table did not exist: DENK1
INFO Thread-14 com.hardcode.gdbms.engine.data.AutomaticDataSource - 
timer start
ERROR Thread-14 
es.prodevelop.cit.gvsig.fmap.drivers.jdbc.oracle.OracleSpatialWriter - 
Error while executing SQL for row insertion: ORA-29875: Routine 
ODCIINDEXINSERT nicht erfolgreich ausgeführt
ORA-13364: Ebenendimensionalität stimmt nicht mit Geometrie-Dimensionen 
überein
ORA-06512: in "MDSYS.SDO_INDEX_METHOD_9I", Zeile 319
ORA-06512: in Zeile 1
 SQL: INSERT INTO DENK1 ( "OGR_FID" , "ETYP" , "EBENE" , "X" , "Y" , 
"DENKFL_P_I" , "GID" , GEOMETRY ) VALUES ( 1.0 , 'FL' , 6.0 , 
4463846.2799 , 5326601.5503 , 1.0 , 0 ,  ? )
java.sql.SQLException: ORA-29875: Routine ODCIINDEXINSERT nicht 
erfolgreich ausgeführt
ORA-13364: Ebenendimensionalität stimmt nicht mit Geometrie-Dimensionen 
überein
ORA-06512: in "MDSYS.SDO_INDEX_METHOD_9I", Zeile 319
ORA-06512: in Zeile 1

    at 
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
    at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
    at 
oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:216)
    at 
oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:955)
    at 
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1168)
    at 
oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3285)
    at 
oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3390)
    at 
es.prodevelop.cit.gvsig.fmap.drivers.jdbc.oracle.OracleSpatialWriter.addRow(OracleSpatialWriter.java:316)
    at 
es.prodevelop.cit.gvsig.fmap.drivers.jdbc.oracle.OracleSpatialWriter.process(OracleSpatialWriter.java:226)
    at 
es.prodevelop.cit.gvsig.jdbc_spatial.OracleWriteTask.run(OracleWriteTask.java:212)
    at com.iver.andami.PluginServices$2.construct(PluginServices.java:382)
    at com.iver.utiles.swing.threads.SwingWorker$2.run(SwingWorker.java:108)
    at java.lang.Thread.run(Thread.java:534)
DEBUG Thread-14 com.iver.andami.messages.NotificationManager -
com.iver.cit.gvsig.fmap.edition.EditionException: ORA-29875: Routine 
ODCIINDEXINSERT nicht erfolgreich ausgeführt
ORA-13364: Ebenendimensionalität stimmt nicht mit Geometrie-Dimensionen 
überein
ORA-06512: in "MDSYS.SDO_INDEX_METHOD_9I", Zeile 319
ORA-06512: in Zeile 1

    at 
es.prodevelop.cit.gvsig.fmap.drivers.jdbc.oracle.OracleSpatialWriter.addRow(OracleSpatialWriter.java:325)
    at 
es.prodevelop.cit.gvsig.fmap.drivers.jdbc.oracle.OracleSpatialWriter.process(OracleSpatialWriter.java:226)
    at 
es.prodevelop.cit.gvsig.jdbc_spatial.OracleWriteTask.run(OracleWriteTask.java:212)
    at com.iver.andami.PluginServices$2.construct(PluginServices.java:382)
    at com.iver.utiles.swing.threads.SwingWorker$2.run(SwingWorker.java:108)
    at java.lang.Thread.run(Thread.java:534)
WARN AWT-EventQueue-1 com.iver.andami.PluginServices - Plugin 
com.iver.core -- Konnte Übersetzung nicht finden für: Informationskonsole
WARN AWT-EventQueue-1 com.iver.andami.PluginServices - Plugin 
com.iver.core -- Konnte Übersetzung nicht finden für: Informationskonsole
WARN AWT-EventQueue-1 com.iver.andami.PluginServices - Plugin 
com.iver.core -- Konnte Übersetzung nicht finden für: Aktiviert das fenster
DEBUG AWT-EventQueue-1 com.iver.core.mdiManager.NewSkin - Activando 
Informationskonsole
DEBUG AWT-EventQueue-1 com.iver.andami.ui.mdiFrame.MDIFrame - Memoria 
total: 41163472
INFO Thread-12 com.hardcode.gdbms.engine.data.AutomaticDataSource - 
datasource closed
INFO Thread-13 com.hardcode.gdbms.engine.data.AutomaticDataSource - 
datasource closed
INFO Thread-15 com.hardcode.gdbms.engine.data.AutomaticDataSource - 
datasource closed
INFO Thread-16 com.hardcode.gdbms.engine.data.AutomaticDataSource - 
datasource closed
DEBUG AWT-EventQueue-1 com.iver.andami.ui.mdiFrame.MDIFrame - Memoria 
total: 38181432
DEBUG AWT-EventQueue-1 com.iver.core.mdiManager.NewSkin$FrameListener - 
Returns focus toAnsicht : Ohne Titel - 0
DEBUG AWT-EventQueue-1 com.iver.andami.ui.mdiFrame.MDIFrame - Memoria 
total: 38352208
INFO AWT-EventQueue-1 
com.iver.cit.gvsig.fmap.drivers.jdbc.utils.SingleJDBCConnectionManager - 
Successfully closed all connections.

I woul be grateful for some comments. Greetings!
Wolfgang

More information about the Gvsig_internacional mailing list