[prev in list] [next in list] [prev in thread] [next in thread]
List: postgis-users
Subject: [postgis-users] parse error -invalid geometry
From: <paul.malm () lfv ! se>
Date: 2020-10-29 13:01:05
Message-ID: ccfa0f793a5c47fea32c3b5d7690398f () lfv ! se
[Download RAW message or body]
Hi list,
I have installed PostgreSQL/Postgis on a new computer.
All my tables (layers) works ok on the old computer, but when I import them=
in the pgdatabas on the new computor there is a problem when I try to view=
them in my java-graphical-viewer.
I can view the layer in QGIS, no problem.
Caused by: org.postgresql.util.PSQLException: ERROR: parse error - invalid =
geometry (pgjdbc: autodetected server-encoding to be ISO-8859-1, if the mes=
sage is not readable, please check database logs and/or host, port, dbname,=
user, password, pg_hba.conf)
Hint: "POLYGON ((=E2^" <-- parse error at position 12 within geometry
Is there something I forgot to configure?
[Attachment #3 (text/html)]
<html xmlns:v="urn:schemas-microsoft-com:vml" \
xmlns:o="urn:schemas-microsoft-com:office:office" \
xmlns:w="urn:schemas-microsoft-com:office:word" \
xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" \
xmlns="http://www.w3.org/TR/REC-html40"> <head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<meta name="Generator" content="Microsoft Word 15 (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;}
@font-face
{font-family:Consolas;
panose-1:2 11 6 9 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;
mso-fareast-language:EN-US;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:#0563C1;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:#954F72;
text-decoration:underline;}
span.E-postmall17
{mso-style-type:personal-compose;
font-family:"Calibri",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri",sans-serif;
mso-fareast-language:EN-US;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:70.85pt 70.85pt 70.85pt 70.85pt;}
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]-->
</head>
<body lang="SV" link="#0563C1" vlink="#954F72">
<div class="WordSection1">
<p class="MsoNormal" style="text-autospace:none"><span lang="EN-US" \
style="font-size:10.0pt;font-family:Consolas">Hi list,<o:p></o:p></span></p> <p \
class="MsoNormal" style="text-autospace:none"><span lang="EN-US" \
style="font-size:10.0pt;font-family:Consolas">I have installed PostgreSQL/Postgis on \
a new computer.<o:p></o:p></span></p> <p class="MsoNormal" \
style="text-autospace:none"><span lang="EN-US" \
style="font-size:10.0pt;font-family:Consolas">All my tables (layers) works ok on the \
old computer, but when I import them in the pgdatabas on the new computor there is a \
problem when I try to view them in my java-graphical-viewer.<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span lang="EN-US" \
style="font-size:10.0pt;font-family:Consolas">I can view the layer in QGIS, no \
problem.<o:p></o:p></span></p> <p class="MsoNormal" style="text-autospace:none"><span \
lang="EN-US" style="font-size:10.0pt;font-family:Consolas;color:red">Caused by: \
</span><u><span lang="EN-US" \
style="font-size:10.0pt;font-family:Consolas;color:#0066CC">org.postgresql.util.PSQLException</span></u><span \
lang="EN-US" style="font-size:10.0pt;font-family:Consolas;color:red">: ERROR: parse \
error - invalid geometry (pgjdbc: autodetected server-encoding to be ISO-8859-1, if \
the message is not readable, please check database logs and/or host, port, dbname, \
user, password, pg_hba.conf)</span><span lang="EN-US" \
style="font-size:10.0pt;font-family:Consolas"><o:p></o:p></span></p> <p \
class="MsoNormal"><span lang="EN-US" \
style="font-size:10.0pt;font-family:Consolas;color:red"> Hint: "POLYGON \
((â</span><span style="font-size:10.0pt;font-family:Consolas;color:red">ˆ</span><span \
lang="EN-US" style="font-size:10.0pt;font-family:Consolas;color:red">" <-- \
parse error at position 12 within geometry<o:p></o:p></span></p> <p \
class="MsoNormal"><span lang="EN-US" \
style="font-size:10.0pt;font-family:Consolas;color:red"><o:p> </o:p></span></p> \
<p class="MsoNormal"><span lang="EN-US" \
style="font-size:10.0pt;font-family:Consolas;color:red"><o:p> </o:p></span></p> \
<p class="MsoNormal" style="text-autospace:none"><span lang="EN-US" \
style="font-size:10.0pt;font-family:Consolas">Is there something I forgot to \
configure?<o:p></o:p></span></p> <p class="MsoNormal"><span lang="EN-US" \
style="font-size:10.0pt;font-family:Consolas;color:red"><o:p> </o:p></span></p> \
<p class="MsoNormal"><span lang="EN-US" \
style="font-size:10.0pt;font-family:Consolas;color:red"><o:p> </o:p></span></p> \
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p> </div>
</body>
</html>
[Attachment #4 (unknown)]
_______________________________________________
postgis-users mailing list
postgis-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/postgis-users
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic