<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
Hello.<br>
<br>
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.<br>
<br>
Regards,<br>
Jorge.<br>
<br>
<br>
On 04/23/2010 11:00 AM, Juan Lucas Dominguez Rubio wrote:
<blockquote
cite="mid:E43C32BC5843E34FB4C00CDFAAAAF7D8017B4FD4@australia.prodevelop.local"
type="cite">
<title>[Gvsig_english] Transfering Data to oracle Spatial</title>
<meta http-equiv="Content-Type"
content="text/html; charset=ISO-8859-1">
<meta content="MSHTML 6.00.6000.17023" name="GENERATOR">
<div id="idOWAReplyText11405">
<div><font face="Times New Roman" color="#000000" size="3">Hello,
Rolf.</font></div>
<div> </div>
<div>Yes, I'm afraid the gvSIG Oracle Spatial driver is mistakenly
limiting the length of string attributes. I am fixing that now.</div>
<div> </div>
<div>Anyway, the WFS server you are using is a public one or is only
available inside your local network? What is the URL?</div>
<div> </div>
<div>Regards,</div>
<div> </div>
</div>
<div id="idSignature27019">
<div><font face="Courier New" size="2"><font face="Times New Roman"
size="3">Juan Lucas Domínguez Rubio<br>
</font>---</font></div>
<div><font face="Courier New" size="2"><font face="Courier New"
size="2"><font face="Courier New" size="2">Prodevelop SL, Valencia
(España)</font></font></font></div>
<div>
<div><font face="Courier New" size="2"><font face="Courier New"
size="2"><font face="Courier New" size="2">Tlf.: 96.351.06.12 -- Fax:
96.351.09.68<br>
</font><a moz-do-not-send="true" href="http://www.prodevelop.es/"><font
face="Courier New" size="2">http://www.prodevelop.es</font></a><br>
<font face="Courier New" size="2">---</font></font></font></div>
</div>
</div>
<div><br>
<hr>
<font face="Tahoma" size="2"><b>De:</b>
<a class="moz-txt-link-abbreviated" href="mailto:gvsig_internacional-bounces@listserv.gva.es">gvsig_internacional-bounces@listserv.gva.es</a> en nombre de Rolf Annecke<br>
<b>Enviado el:</b> vie 23/04/2010 9:31<br>
<b>Para:</b> <a class="moz-txt-link-abbreviated" href="mailto:gvsig_internacional@listserv.gva.es">gvsig_internacional@listserv.gva.es</a><br>
<b>Asunto:</b> [Gvsig_english] Transfering Data to oracle Spatial<br>
</font><br>
</div>
<div>
<p><font size="2">Hi List,<br>
my name is Rolf Annecke and I am new in your list.<br>
I am the 3rd user of gvSIG in the Department for Health and Environment<br>
in the City of Munich.<br>
My question deals with the import of datas in Oracle Spatial.<br>
I am connected to an WFS-Server. The field length of one item is more<br>
than 100; it is about 300. I can see the whole content in the table.<br>
Transfering this data to oracle spatial I get a mistake with the<br>
following report:<br>
java.sql.SQLException: ORA-12899: Wert zu groß für Spalte<br>
"T_RGU"."TEST"."listentext" (aktuell: 114, maximal: 100)<br>
It seems, that there is a limitation to 100 characters.<br>
The same mistake occured by transfering the adequate csv-Datas.<br>
<br>
Is this limitation to 100 characters caused by<br>
a) gvSIG or is this caused by<br>
b) the database of oracle spatial?<br>
<br>
If a), do you know a way transfering data to oracle with more than 100<br>
characters by gvSIG?<br>
Thank you for your answers.<br>
Best<br>
Rolf Annecke<br>
<br>
--<br>
_________________________________________________<br>
Rolf Annecke<br>
Referat für Gesundheit und Umwelt<br>
Abteilung Umweltschutz<br>
Gesundheits- und Umweltberichterstattung (GUBE)<br>
RGU-UW112<br>
Bayerstr. 28a<br>
80335 München<br>
<br>
Telefon: +49 - 89 - 233 - 4 77 15<br>
Telefax: +49 - 89 - 233 - 4 77 05<br>
Mailbüro: <a class="moz-txt-link-abbreviated" href="mailto:gube.rgu@muenchen.de">gube.rgu@muenchen.de</a><br>
<br>
Elektronische Kommunikation mit der Landeshauptstadt München:<br>
<a moz-do-not-send="true" href="http://www.muenchen.de/ekomm">http://www.muenchen.de/ekomm</a><br>
<br>
_______________________________________________<br>
Gvsig_internacional mailing list<br>
<a class="moz-txt-link-abbreviated" href="mailto:Gvsig_internacional@listserv.gva.es">Gvsig_internacional@listserv.gva.es</a><br>
<a moz-do-not-send="true"
href="http://listserv.gva.es/cgi-bin/mailman/listinfo/gvsig_internacional">http://listserv.gva.es/cgi-bin/mailman/listinfo/gvsig_internacional</a><br>
</font></p>
</div>
<pre wrap="">
<fieldset class="mimeAttachmentHeader"></fieldset>
_______________________________________________
Gvsig_internacional mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Gvsig_internacional@listserv.gva.es">Gvsig_internacional@listserv.gva.es</a>
<a class="moz-txt-link-freetext" href="http://listserv.gva.es/cgi-bin/mailman/listinfo/gvsig_internacional">http://listserv.gva.es/cgi-bin/mailman/listinfo/gvsig_internacional</a>
</pre>
</blockquote>
<br>
<br>
<pre class="moz-signature" cols="72">--
Jorge Piera Llodrá
gvSIG Development Team
PRODEVELOP
Plaza Don Juan de Villarrasa, 14 - 5
46001 Valencia
Tel: +34 963510612
Fax: +34 963510908
e-mail: <a class="moz-txt-link-abbreviated" href="mailto:jpiera@prodevelop.es">jpiera@prodevelop.es</a>
<a class="moz-txt-link-freetext" href="http://www.prodevelop.es">http://www.prodevelop.es</a>
<a class="moz-txt-link-freetext" href="http://www.gvsig.org">http://www.gvsig.org</a>
</pre>
</body>
</html>