[Gvsig_english] Transfering Data to oracle Spatial

[Jorge Piera Llodrá]

Hello.

When you are loading a WFS layer in gvSIG, you can see the WFS request 
that the application is sending to the server by the console. Just copy 
this url in a browser and have a look to the length of the retrieved fields.

Regards,
Jorge.


On 04/23/2010 11:00 AM, Juan Lucas Dominguez Rubio wrote:
> 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
>
>
> _______________________________________________
> Gvsig_internacional mailing list
> Gvsig_internacional at listserv.gva.es
> http://listserv.gva.es/cgi-bin/mailman/listinfo/gvsig_internacional
>    


-- 
Jorge Piera Llodrá
gvSIG Development Team
PRODEVELOP
Plaza Don Juan de Villarrasa, 14 - 5
46001 Valencia
Tel: +34 963510612
Fax: +34 963510908
e-mail: jpiera at prodevelop.es
http://www.prodevelop.es
http://www.gvsig.org

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