[Gvsig_english] Transfering Data to oracle Spatial

[Juan Lucas Dominguez Rubio]

Hello, Rolf.
 
Yes, I'm afraid the gvSIG Oracle Spatial driver is mistakenly limiting the length of string attributes. I am fixing that now.
 
Anyway, the WFS server you are using is a public one or is only available inside your local network? What is the URL?
 
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 listserv.gva.es en nombre de Rolf Annecke
Enviado el: vie 23/04/2010 9:31
Para: gvsig_internacional at listserv.gva.es
Asunto: [Gvsig_english] Transfering Data to oracle Spatial



Hi List,
my name is Rolf Annecke and I am new in your list.
I am the 3rd user of gvSIG in the Department for Health and Environment
in the City of Munich.
My question deals with the import of datas in Oracle Spatial.
I am connected to an WFS-Server.  The field length of one item is more
than 100; it is  about 300. I can see the whole content in the table.
Transfering this data to oracle spatial I get a mistake with the
following report:
   java.sql.SQLException: ORA-12899: Wert zu groß für Spalte
"T_RGU"."TEST"."listentext" (aktuell: 114, maximal: 100)
It seems, that there is a limitation to 100 characters.
The same mistake occured by transfering the adequate csv-Datas.

Is this limitation to 100 characters caused by
    a) gvSIG or is this caused by
    b) the database of oracle spatial?

If a), do you know a way transfering data to oracle with more than 100
characters by gvSIG?
Thank you for your answers.
Best
Rolf Annecke

--
_________________________________________________
Rolf Annecke
Referat für Gesundheit und Umwelt
Abteilung Umweltschutz
Gesundheits- und Umweltberichterstattung (GUBE)
RGU-UW112
Bayerstr. 28a
80335 München

Telefon: +49 - 89 - 233 - 4 77 15
Telefax: +49 - 89 - 233 - 4 77 05
Mailbüro: gube.rgu at muenchen.de

Elektronische Kommunikation mit der Landeshauptstadt München:
http://www.muenchen.de/ekomm

_______________________________________________
Gvsig_internacional mailing list
Gvsig_internacional at listserv.gva.es
http://listserv.gva.es/cgi-bin/mailman/listinfo/gvsig_internacional


-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://listserv.gva.es/pipermail/gvsig_internacional/attachments/20100423/52d886ae/attachment.htm