<div dir="ltr"><div style>hello </div><div style><br></div><div>postgresql (9.2.2)<br></div><div><br></div><div style>postgresql-jdbc 9.2</div><div><br></div>here is the result of SELECT postgis_full_version();<br><div><br>
</div><div><div> postgis_full_version </div><div>------------------------------------------------------------------------------------------------------------------------------------------------</div>
<div> POSTGIS="2.1.0SVN r10952" GEOS="3.3.3-CAPI-1.7.4" PROJ="Rel. 4.8.0, 6 March 2012" GDAL="GDAL 1.9.2, released 2012/10/08" LIBXML="2.8.0" RASTER</div></div><div><br></div>
<div><br></div><div style>thank you</div></div><div class="gmail_extra"><br><br><div class="gmail_quote">On Mon, Jun 17, 2013 at 3:45 PM, Paragon Corporation <span dir="ltr"><<a href="mailto:lr@pcorp.us" target="_blank">lr@pcorp.us</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><u></u>
<div>
<div dir="ltr" align="left"><font color="#0000ff" face="Arial"><span>Which JDBC driver are you using and which PostgreSQL
version. You might be affected by the escape/hex change in
9.0</span></font></div>
<div dir="ltr" align="left"><font color="#0000ff" face="Arial"><span></span></font> </div>
<div dir="ltr" align="left"><font color="#0000ff" face="Arial"><span>detailed here: <a href="http://postgis.net/docs/manual-2.0/PostGIS_FAQ.html#id338804" target="_blank">http://postgis.net/docs/manual-2.0/PostGIS_FAQ.html#id338804</a></span></font></div>
<font color="#0000ff" face="Arial"></font><br>
<div lang="en-us" dir="ltr" align="left">
<hr>
<font face="Tahoma"><b>From:</b> <a href="mailto:postgis-users-bounces@lists.osgeo.org" target="_blank">postgis-users-bounces@lists.osgeo.org</a>
[mailto:<a href="mailto:postgis-users-bounces@lists.osgeo.org" target="_blank">postgis-users-bounces@lists.osgeo.org</a>] <b>On Behalf Of </b>Ahmet
Temiz<br><b>Sent:</b> Monday, June 17, 2013 8:32 AM<br><b>To:</b> PostGIS Users
Discussion<br><b>Subject:</b> [postgis-users] ST_AsPNG is problematic in
Java<br></font><br></div><div><div class="h5">
<div></div>
<div dir="ltr"><br clear="all">
<div>hello
<div><br></div>
<div>I am dealing with java-jpa2-postgis(raster)</div>
<div><br></div>
<div>I tried to get an image from postgis(raster) as:</div>
<div><br></div>
<div>
<div>List list_rast = session.createSQLQuery("SELECT ST_AsPNG(rast) As
rastpng <span style="WHITE-SPACE:pre-wrap"> </span>FROM geoslp5 where
rid=184 ;").list();</div>
<div><br></div>
<div>and converting object to byte[]</div>
<div><span style="WHITE-SPACE:pre-wrap">and </span></div></div>
<div><span style="WHITE-SPACE:pre-wrap">with usual java
process<br></span></div>
<div><span style="WHITE-SPACE:pre-wrap">ByteArrayOutputStream bos = new
ByteArrayOutputStream(); </span></div>
<div><span style="WHITE-SPACE:pre-wrap">... //</span></div>
<div><span style="WHITE-SPACE:pre-wrap">bytes = bos.toByteArray
();</span><br></div>
<div><br></div>
<div><br></div>
<div>But resulting image file(png) is defective ?</div>
<div><br></div>
<div>What may the probable problems ?</div>
<div><br></div>
<div>Do you have any recommendations ?</div>
<div><br></div>
<div><span style="FONT-SIZE:12px;FONT-FAMILY:arial,sans-serif">regards</span><br style="FONT-SIZE:12px;FONT-FAMILY:arial,sans-serif" clear="all"></div></div>
<div><span style="FONT-SIZE:12px;FONT-FAMILY:arial,sans-serif"><br></span></div>--
<br>Ahmet Temiz<br>Jeoloji Müh.<br>Afet ve Acil Durum Yönetimi
Başkanlığı<br>Planlama ve Zarar Azaltma Dairesi
Başkanlığı<br><br><br>________________________<br><br>Ahmet Temiz<br>Geological
Eng.<br>Information Systems - GIS Group<br>Disaster and Emergency
Management<br>of Presidency </div></div></div></div>
<br>_______________________________________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users" target="_blank">http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users</a><br>
<br></blockquote></div><br><br clear="all"><div><br></div>-- <br>Ahmet Temiz<br>Jeoloji Müh.<br>Afet ve Acil Durum Yönetimi Başkanlığı<br>Planlama ve Zarar Azaltma Dairesi Başkanlığı<br><br><br>________________________<br>
<br>Ahmet Temiz<br>Geological Eng.<br>Information Systems - GIS Group<br>Disaster and Emergency Management<br>of Presidency
</div>