[Gvsig_english] Issues with Oracle Expatial export

[Diego Guidi]

looks that the operations are the same.
Monday I could try with your data and see if in my system (gvSIG 1.1.2
+ Oracle Spatial 10g r2) the issue is reproducible.
Thanks for support.

On Fri, Apr 18, 2008 at 2:46 PM, Juan Lucas Dominguez Rubio
<jldominguez at prodevelop.es> wrote:
> Hello, Diego
>
>  I have tried what you mention without a problem. This is what I have done with gvSIG 1.1.2. Please tell me if this is not what you meant:
>
>  - I have a 3d shapefile (attached baleares_3d.zip). and a copy of it (you can simply select the three files and use copy-paste to get a "Copy of baleares_3d.shp", which is a new valid shapefile.
>
>  - I have created a view in gvSIG and added both files (the view is in EPSG:23030).
>
>  - I select one of the layers and export it to Oracle. When I am asked whether the table should be added to the view, I say yes.
>
>  - I click on the other layer that comes from a shapefile and export it again to Oracle. When I am asked whether the table should be added to the view, I say yes.
>
>  - The four layers show without a problem, and I can see with another application that the geometries are truly 3d in the database.
>
>  Is this what you are trying to do? Can you repeat what I have done with the attached zipfile, and tell me what happens, please? Can you send me one of the shapefiles you are using?
>
>  Best 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 runas.cap.gva.es en nombre de Diego Guidi
>  Enviado el: vie 18/04/2008 10:54
>  Para: Users and Developers mailing list
>  Asunto: [Gvsig_english] Issues with Oracle Expatial export
>
>
>
>
>
>  I'm experiencing a strange issue with layer export from a shapefile to
>  a Oracle Spatial DB.
>  When open gvSIG, I launch a export from a shapefile to oracle spatial,
>  all works OK and I could show correctly the data
>  If I launch a second export from a different shapefile to oracle
>  spatial, when I try to open the data, the data generated is corrupted
>  and the console shows a log message:
>  ERROR Thread-62
>  es.prodevelop.cit.gvsig.fmap.drivers.jdbc.oracle.OracleSpatialDriver -
>  Tablename: SCOTT.ST01TE01CL14PTS. Error while getting main cursor:
>  ORA-29902: errore durante l'esecuzione della routine ODCIIndexStart()
>  ORA-13033: Dati non validi nell'oggetto SDO_ELEM_INFO_ARRAY in SDO_GEOMETRY
>  ORA-06512: a "MDSYS.SDO_INDEX_METHOD_10I", line 286
>
>  java.sql.SQLException: ORA-29902: errore durante l'esecuzione della
>  routine ODCIIndexStart()
>  ORA-13033: Dati non validi nell'oggetto SDO_ELEM_INFO_ARRAY in SDO_GEOMETRY
>  ORA-06512: a "MDSYS.SDO_INDEX_METHOD_10I", line 286
>
>         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.T4CStatement.doOall8(T4CStatement.java:207)
>         at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:790)
>         at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1031)
>         at oracle.jdbc.driver.T4CStatement.executeMaybeDescribe(T4CStatement.java:830)
>         at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1124)
>         at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1264)
>         at es.prodevelop.cit.gvsig.fmap.drivers.jdbc.oracle.OracleSpatialDriver.getViewResultSet(Unknown
>  Source)
>         at es.prodevelop.cit.gvsig.fmap.drivers.jdbc.oracle.OracleSpatialDriver.getFeatureIterator(Unknown
>  Source)
>         at es.prodevelop.cit.gvsig.fmap.drivers.jdbc.oracle.OracleSpatialDriver.getFeatureIterator(Unknown
>  Source)
>         at com.iver.cit.gvsig.fmap.layers.VectorialDBAdapter.getFeatureIterator(Unknown
>  Source)
>         at com.iver.cit.gvsig.fmap.operations.strategies.DBStrategy.draw(Unknown
>  Source)
>         at com.iver.cit.gvsig.fmap.layers.FLyrVect.draw(Unknown Source)
>         at com.iver.cit.gvsig.fmap.layers.FLayers.draw(Unknown Source)
>         at com.iver.cit.gvsig.fmap.layers.FLayers.draw(Unknown Source)
>         at com.iver.cit.gvsig.fmap.MapContext.draw(Unknown Source)
>         at com.iver.cit.gvsig.fmap.MapControl$PaintingRequest.paint(Unknown Source)
>         at com.iver.cit.gvsig.fmap.MapControl$Drawer2$Worker.run(Unknown Source)
>         at java.lang.Thread.run(Unknown Source)
>
>
>  The best way to do this kind of operations correctly is to stop and
>  restart gvSIG after any export to Oracle Spatial.
>
>  This kind of behavior happens every time I launch a second export, and
>  looks not related to the data in the shapefile 8from 1 mega to 200
>  mega).
>  All shapefiles I'm using are with Z and M, and the generated
>  SDO_GEMOETRIES are 3D geoms.
>
>
>  --
>  Diego Guidi
>  _______________________________________________
>  Gvsig_internacional mailing list
>  Gvsig_internacional at runas.cap.gva.es
>  http://runas.cap.gva.es/mailman/listinfo/gvsig_internacional
>
>
>
> _______________________________________________
>  Gvsig_internacional mailing list
>  Gvsig_internacional at runas.cap.gva.es
>  http://runas.cap.gva.es/mailman/listinfo/gvsig_internacional
>
>



-- 
Diego Guidi
http://lacorrente.blogspot.com