<!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 text="#000000" bgcolor="#ffffff">
Hi Klaus.<br>
<br>
I've seen this message before, for example when I try to import a
3D or M shapefile to Postgis.<br>
gvSIG Postgis driver doesn't support 3D yet. Maybe these is the
problem. You can send to us the definiton of your table (including
geometry_columns register)?<br>
<br>
Cheers.<br>
<br>
Fran.<br>
<br>
El 14/01/2011 12:57, Klaus Schaefer EH TZA escribió:
<blockquote
cite="mid:000001cbb3e2$44a55da0$cdf018e0$@schaefer4@giz.de"
type="cite">
<meta http-equiv="Content-Type" content="text/html;
charset=ISO-8859-1">
<meta name="Generator" content="Microsoft Word 12 (filtered
medium)">
<style><!--
/* Font Definitions */
@font-face
        {font-family:"Cambria Math";
        panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
        {font-family:Calibri;
        panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
        {margin:0cm;
        margin-bottom:.0001pt;
        font-size:11.0pt;
        font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
        {mso-style-priority:99;
        color:blue;
        text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
        {mso-style-priority:99;
        color:purple;
        text-decoration:underline;}
span.EmailStyle17
        {mso-style-type:personal;
        font-family:"Calibri","sans-serif";
        color:windowtext;}
span.EmailStyle18
        {mso-style-type:personal-reply;
        font-family:"Calibri","sans-serif";
        color:#1F497D;}
.MsoChpDefault
        {mso-style-type:export-only;
        font-size:10.0pt;}
@page WordSection1
        {size:612.0pt 792.0pt;
        margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
        {page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
<div class="WordSection1">
<p class="MsoNormal">Hi folks,<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">I have to complain that gvSIG 1.10 seems
not to work properly with PostgreSQL/PostGIS at all! I’ve
tested it with the versions:<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal" style="margin-left: 36pt;">Windows 7
professional, 64bit <br>
gvSIG 1.10 <o:p></o:p></p>
<p class="MsoNormal" style="margin-left: 36pt;"><br>
PostgreSQL 9.0.2-1, compiled by Visual C++ build 1500, 32-bit
<br>
PostGIS 1.5.2<o:p></o:p></p>
<p class="MsoNormal" style="margin-left: 36pt;"><o:p> </o:p></p>
<p class="MsoNormal" style="margin-left: 36pt;">as well as<o:p></o:p></p>
<p class="MsoNormal" style="margin-left: 36pt;"><o:p> </o:p></p>
<p class="MsoNormal" style="margin-left: 36pt;">PostgreSQL
8.4.6-1, compiled by Visual C++ build 1400, 32-bit
<br>
PostGIS 1.4.2<o:p></o:p></p>
<p class="MsoNormal" style="margin-left: 36pt;">and<o:p></o:p></p>
<p class="MsoNormal" style="margin-left: 36pt;">PostGIS 1.5.2<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Whenever I try to export a vector layer to
PostGIS the following error is issued:<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><span style="font-size: 12pt; font-family:
"Times New Roman","serif"; color: red;">null</span><span
style="font-size: 12pt; font-family: "Times New
Roman","serif";"><br>
<span style="color: maroon;">java.lang.IllegalStateException:
Can't overwrite cause<br>
java.lang.Throwable.initCause(Throwable.java:320)<br>
com.iver.cit.gvsig.exceptions.visitors.ProcessWriterVisitorException.(ProcessWriterVisitorException.java:11)<br>
com.iver.cit.gvsig.fmap.drivers.jdbc.postgis.PostGISWriter.process(PostGISWriter.java:192)<br>
com.iver.cit.gvsig.ExportTo$WriterTask.run(ExportTo.java:200)<br>
com.iver.andami.PluginServices$1.construct(PluginServices.java:405)<br>
com.iver.utiles.swing.threads.SwingWorker$2.run(SwingWorker.java:108)<br>
java.lang.Thread.run(Unknown Source)<br>
</span><span style="color: red;">null</span><span
style="color: maroon;"><br>
java.lang.IllegalStateException: Can't overwrite cause<br>
java.lang.Throwable.initCause(Throwable.java:320)<br>
com.iver.cit.gvsig.exceptions.visitors.ProcessWriterVisitorException.(ProcessWriterVisitorException.java:11)<br>
com.iver.cit.gvsig.fmap.drivers.jdbc.postgis.PostGISWriter.process(PostGISWriter.java:192)<br>
com.iver.cit.gvsig.ExportTo$WriterTask.run(ExportTo.java:200)<br>
com.iver.andami.PluginServices$1.construct(PluginServices.java:405)<br>
com.iver.utiles.swing.threads.SwingWorker$2.run(SwingWorker.java:108)<br>
java.lang.Thread.run(Unknown Source)</span><o:p></o:p></span></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">The result is that the table and the
attributes are created, but no data gets imported! This is due
to “\” –characters being content in some (text field)
attributes. When removing these “\”-characters the export
works. However – the spatial reference (EPSG:32767) is lost,
so the result is of no use in the project.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Using the shapefile to postgis plugin to
import an existing shapefile into PostGIS gives a better
result: The “\”-characters are kept and also the spacial
reference (EPSG:32767) is set properly. This table seems to be
fine when used as layer in gvSIG.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">But finally – in any case - if I export a
shapefile- or postgis-layer to another shapefile, again the
spacial reference is not being set properly there (as in the
previous case, it claims to be EPSG:32767, but the coordinates
refer to some indefinite values…).<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">I will continue experimenting around the
PostGIS interface. Since I’m a gvSIG user only (not a gvSIG
developer), I see much work left for some bug fixing! I’m not
sure if I can use the current gvSIG release in production, as
I’m facing several other unresolved issues which I also posted
here, too. Sorry for saying this..<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Best regards<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Klaus Schäfer<o:p></o:p></p>
<p class="MsoNormal">Advisor Regional Administrative
Secretariat, Water Sector<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">GIZ Tanzania | German Development
Cooperation<o:p></o:p></p>
<p class="MsoNormal">P.O. BOX 324 | Moshi, Kilimanjaro Region,
Tanzania<o:p></o:p></p>
<p class="MsoNormal">Mobile: +255 (767) 500 892<o:p></o:p></p>
<p class="MsoNormal"><a class="moz-txt-link-abbreviated" href="mailto:klaus.schaefer4@giz.de">klaus.schaefer4@giz.de</a> | <a class="moz-txt-link-abbreviated" href="http://www.giz.de">www.giz.de</a><o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<br>
<hr>
<font color="Black" face="Arial" size="1">Deutsche Gesellschaft
fuer Internationale Zusammenarbeit (GIZ) GmbH;<br>
Sitz der Gesellschaft/Registered Office: Bonn und/and Eschborn,
Germany;<br>
Handelsregister/Registered at: Amtsgericht Bonn, Germany, HRB
18384, Amtsgericht Frankfurt am Main, Germany, HRB 12394;<br>
USt-IdNr./VAT ID no.: DE 113891176;<br>
Vorsitzender des Aufsichtsrats/Chairman of the Supervisory
Board: Hans-Juergen Beerfeltz, Staatssekretaer/State Secretary;<br>
Vorstandssprecher/Chairman of the Management Board: Dr. Bernd
Eisenblaetter;<br>
Vorstand/Management Board: Dr. Christoph Beier, Adolf
Kloke-Lesch, Tom Paetz, Dr. Sebastian Paust, Dr. Hans-Joachim
Preuss, Dr. Juergen Wilhelm<br>
</font>
<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>
<pre class="moz-signature" cols="72">--
Fran Peñarrubia
Scolab
<a class="moz-txt-link-abbreviated" href="http://www.scolab.es">www.scolab.es</a>
Asociación gvSIG
<a class="moz-txt-link-abbreviated" href="http://www.gvsig.com">www.gvsig.com</a>
</pre>
</body>
</html>