<HTML><HEAD><TITLE>[Gvsig_english] Error loading a big oracle spatial layer</TITLE>
<META http-equiv=Content-Type content="text/html; charset=unicode">
<META content="MSHTML 6.00.6000.17023" name=GENERATOR></HEAD>
<BODY>
<DIV id=idOWAReplyText49874>
<DIV><FONT face="Times New Roman" color=#000000 size=3>Hello, Wolfgang.</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face="Times New Roman" color=#000000 size=3>Sorry, I think there is a bug in the Oracle Spatial driver. I need to know the structure of the geometry the driver has been unable to read, so could you please do this test? </FONT></DIV>
<DIV> </DIV>
<DIV><FONT face="Times New Roman" color=#000000 size=3>- Close gvSIG if it's running.</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face="Times New Roman" color=#000000 size=3>- Download this file and unzip it somewhere in your computer:</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face="Times New Roman" color=#000000 size=3><A href="http://www.prodevelop.es/files/fm/public/downloads/oracle_test_jar.zip">http://www.prodevelop.es/files/fm/public/downloads/oracle_test_jar.zip</A></FONT></DIV>
<DIV> </DIV>
<DIV><FONT face="Times New Roman" color=#000000 size=3>- In your installation of gvSIG 1.9, rename the files 'oracle_spatial.jar' like this:</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face="Times New Roman" color=#000000 size=3>Rename:</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face="Times New Roman" color=#000000 size=3>.../ gvSIG_1.9 / bin / gvSIG / extensiones / com.iver.cit.gvsig / drivers / jdbc_spatial / oracle_spatial.jar</FONT></DIV>
<DIV><FONT face="Times New Roman" color=#000000 size=3>.../ gvSIG_1.9 / bin / gvSIG / extensiones / com.iver.cit.gvsig / lib / oracle_spatial.jar</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face="Times New Roman" color=#000000 size=3>to:</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face="Times New Roman" color=#000000 size=3>.../ gvSIG_1.9 / bin / gvSIG / extensiones / com.iver.cit.gvsig / drivers / jdbc_spatial / oracle_spatial.jar.old</FONT></DIV>
<DIV><FONT face="Times New Roman" color=#000000 size=3>.../ gvSIG_1.9 / bin / gvSIG / extensiones / com.iver.cit.gvsig / lib / oracle_spatial.jar.old</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face="Times New Roman" color=#000000 size=3>(or move them to a temporary folder)</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face="Times New Roman" color=#000000 size=3>- Copy the file 'oracle_spatial.jar' contained in the zip file to those two folders (yes, the same file in two folders)</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face="Times New Roman" color=#000000 size=3>- Delete all the gvSIG log files:</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face="Times New Roman" color=#000000 size=3>C:\Documents and settings\<user>\gvSIG\*log*</FONT></DIV>
<DIV><FONT face="Times New Roman" color=#000000 size=3>or</FONT></DIV>
<DIV><FONT face="Times New Roman" color=#000000 size=3>$HOME/gvSIG/*log*</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face="Times New Roman" color=#000000 size=3>- Start gvSIG and try the Oracle Spatial table that caused the problem (this time, the geometries of interest should not be painted, and will be described in the log file)</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face="Times New Roman" color=#000000 size=3>- Close gvSIG and send the new log files in a zip file</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face="Times New Roman" color=#000000 size=3>C:\Documents and settings\<user>\gvSIG\*log*</FONT></DIV>
<DIV><FONT face="Times New Roman" color=#000000 size=3>or</FONT></DIV>
<DIV><FONT face="Times New Roman" color=#000000 size=3>$HOME/gvSIG/*log*</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face="Times New Roman" color=#000000 size=3>You can finally restore the .old files. Perhaps you can do this test in a spare computer, so we can repeat them until we find the solution.</FONT></DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV><FONT face="Times New Roman" color=#000000 size=3>Regards,</DIV>
<DIV></FONT><FONT face="Times New Roman" color=#000000 size=3></FONT> </DIV></DIV>
<DIV id=idSignature32109>
<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 Wolfgang Qual<BR><B>Enviado el:</B> mié 21/04/2010 17:00<BR><B>Para:</B> Users and Developers mailing list<BR><B>Asunto:</B> [Gvsig_english] Error loading a big oracle spatial layer<BR></FONT><BR></DIV>
<DIV>
<P><FONT size=2>Dear developers,<BR>I just observed a strange error when loading an oracle spatial layer<BR>(see logfile enclosed). Until now, I did not have these kind of<BR>messages. Very huge datasets were loaded into gvSIG without problems.<BR>When I load that special layer, an error message appears saying java<BR>stack overflow...<BR><BR>Any ideas? Comments would be great<BR>Best,<BR>Wolfgang<BR><BR>btw, tested with gvSIG 1.9 build 1253 (normal installation _and_ debian<BR>package)<BR><BR>--<BR>Wolfgang Qual<BR><BR>Landeshauptstadt München<BR>Referat für Gesundheit und Umwelt<BR>Umweltschutz, Umweltvorsorge<BR>RGU-UW 11<BR>Team Klimaschutz, Energie<BR><BR>Bayerstraße 28a<BR>80335 München<BR><BR>Telefon: +49 - 89 - 233 - 4 77 17<BR>Telefax: +49 - 89 - 233 - 4 77 05<BR>E-Mail: wolfgang.qual@muenchen.de<BR>Internet: <A href="http://www.muenchen.de/rgu">http://www.muenchen.de/rgu</A><BR><BR>Bitte beachten Sie die Hinweise zur elektronischen<BR>Kommunikation mit der Landeshauptstadt München:<BR><A href="http://www.muenchen.de/ekomm">http://www.muenchen.de/ekomm</A><BR><BR></FONT></P></DIV></BODY></HTML>