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

[Wolfgang Qual]

Hi Juan,
thank you very much for your efforts, I really appreciate this. And yes: I 
have contacted the administrator. He'll check on that, too.

Best regards,
Wolfgang

----8<---------
Am Montag 18 Februar 2008 10:04:18 schrieb 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.ad
> > >dR ow(Unknown Source) Â Â Â Â
> > > es.prodevelop.cit.gvsig.fmap.drivers.jdbc.oracle.OracleSpatialWriter.pr
> > >oc 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.ad
> > >dR ow(Unknown Source) Â Â Â Â
> > > es.prodevelop.cit.gvsig.fmap.drivers.jdbc.oracle.OracleSpatialWriter.pr
> > >oc 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