[Gvsig_english] Export to Oracle Spatial::not possible with 1.1.1?

[Juan Lucas Dominguez Rubio]

Hello, Wolfgang:
 
I can export vector layers to Oracle Spatial without problems in gvSIG 1.1.1. At first sight, that error message seems to be caused by some problem in your database. Have you shown that to your DB administrator?
 
If you want to test exactly the SQL sentences executed by the driver, see attached file EXPORT_TO_ORACLE.TXT. You can execute them one by one and see if any of them causes an Oracle error message (the first one will cause an error message, but that is ok, the exception is caught by the application.)
 
I don't think it has anything to do with the shapefile, but you can send it to me if you want.
 
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 Wolfgang Qual
Enviado el: lun 18/02/2008 9:42
Para: gvsig_internacional at runas.cap.gva.es
Asunto: Re: [Gvsig_english] Export to Oracle Spatial::not possible with 1.1.1?



Hi Sergio,
thanks for your message. I will test it again and also cointact the
administrator of the database. I will keep you all informed.

Best regards,
Wolfgang


Am Montag 18 Februar 2008 09:23:28 schrieb Sergio Clark:
> Hi Wolfgang,
>
> I've just tested the export of a shape to an Oracle database in gvSIG
> version 1.1.1, and it works well for me.  Maybe any developer could tell
> us anything else about your attached message.
>
> Regards,
>
> Sergio.
>
> Wolfgang Qual escribió:
> > Hi list,
> > sorry for this subject, sounds horrible. I am using gvSIG 1.1.1 and I
> > would like to export a shapefile to an oracle spatial database. I have
> > been successful before (some months ago, when using an older version of
> > gvSIG), but it does not work anymore. I am not sure, were the problem is
> > located - maybe database-based, or maybe within gvSIG? This error message
> > appears, when trying to export the layer:
> >
> > "null com.iver.cit.gvsig.fmap.edition.EditionException: ORA-29861:
> > Domänenindex ist als LOADING/FAILED/UNUSABLE markiert     Â
> > es.prodevelop.cit.gvsig.fmap.drivers.jdbc.oracle.OracleSpatialWriter.addR
> >ow(Unknown Source) Â Â Â Â
> > es.prodevelop.cit.gvsig.fmap.drivers.jdbc.oracle.OracleSpatialWriter.proc
> >ess(Unknown Source) Â Â Â Â
> > es.prodevelop.cit.gvsig.jdbc_spatial.OracleWriteTask.run(Unknown Source)
> > Â Â Â Â
> > com.iver.andami.PluginServices$1.construct(PluginServices.java:400) Â Â Â
> > Â com.iver.utiles.swing.threads.SwingWorker$2.run(Unknown Source) Â Â Â Â
> > java.lang.Thread.run(Unknown Source) null
> > com.iver.cit.gvsig.fmap.edition.EditionException: ORA-00942: Tabelle oder
> > View nicht vorhanden  Â Â Â Â
> > es.prodevelop.cit.gvsig.fmap.drivers.jdbc.oracle.OracleSpatialWriter.addR
> >ow(Unknown Source) Â Â Â Â
> > es.prodevelop.cit.gvsig.fmap.drivers.jdbc.oracle.OracleSpatialWriter.proc
> >ess(Unknown Source) Â Â Â Â
> > es.prodevelop.cit.gvsig.jdbc_spatial.OracleWriteTask.run(Unknown Source)
> > Â Â Â !
>
>  Â !
>
> >  com.iver.andami.PluginServices$1.construct(PluginServices.java:400) Â Â
> > Â Â com.iver.utiles.swing.threads.SwingWorker$2.run(Unknown Source) Â Â Â
> > Â java.lang.Thread.run(Unknown Source)"
> >
> > Comments are more than welcome. Best regards,
> > Wolfgang



_______________________________________________
Gvsig_internacional mailing list
Gvsig_internacional at runas.cap.gva.es
http://runas.cap.gva.es/mailman/listinfo/gvsig_internacional


-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/ms-tnef
Size: 7867 bytes
Desc: not available
Url : http://runas.cap.gva.es/pipermail/gvsig_internacional/attachments/20080218/7b263163/attachment-0001.bin