<HTML><HEAD><TITLE>[Gvsig_english] Transfering Data to oracle Spatial</TITLE>
<META http-equiv=Content-Type content="text/html; charset=unicode">
<META content="MSHTML 6.00.6000.17023" name=GENERATOR></HEAD>
<BODY>
<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><FONT face="Times New Roman" color=#000000 size=3></FONT> </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></DIV>
<DIV>
<DIV><FONT face="Courier New" size=2>Tlf.: 96.351.06.12 -- Fax: 96.351.09.68<BR></FONT><A 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></DIV></FONT></DIV></FONT></DIV>
<DIV><BR>
<HR>
<FONT face=Tahoma size=2><B>De:</B> gvsig_internacional-bounces@listserv.gva.es en nombre de Rolf Annecke<BR><B>Enviado el:</B> vie 23/04/2010 9:31<BR><B>Para:</B> gvsig_internacional@listserv.gva.es<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: gube.rgu@muenchen.de<BR><BR>Elektronische Kommunikation mit der Landeshauptstadt München:<BR><A href="http://www.muenchen.de/ekomm">http://www.muenchen.de/ekomm</A><BR><BR>_______________________________________________<BR>Gvsig_internacional mailing list<BR>Gvsig_internacional@listserv.gva.es<BR><A 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></BODY></HTML>