[postgis-users] ST_AsPNG is problematic in Java

[Ahmet Temiz]

hello

postgresql (9.2.2)

postgresql-jdbc 9.2

here is the result of SELECT postgis_full_version();


postgis_full_version

------------------------------------------------------------------------------------------------------------------------------------------------
 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


thank you


On Mon, Jun 17, 2013 at 3:45 PM, Paragon Corporation <lr at pcorp.us> wrote:

> **
> Which JDBC driver are you using and which PostgreSQL version.  You might
> be affected by the escape/hex change in 9.0
>
> detailed here:
> http://postgis.net/docs/manual-2.0/PostGIS_FAQ.html#id338804
>
>  ------------------------------
> *From:* postgis-users-bounces at lists.osgeo.org [mailto:
> postgis-users-bounces at lists.osgeo.org] *On Behalf Of *Ahmet Temiz
> *Sent:* Monday, June 17, 2013 8:32 AM
> *To:* PostGIS Users Discussion
> *Subject:* [postgis-users] ST_AsPNG is problematic in Java
>
>
> hello
>
> I am dealing with java-jpa2-postgis(raster)
>
> I tried to get an image from postgis(raster) as:
>
>  List list_rast = session.createSQLQuery("SELECT ST_AsPNG(rast) As
> rastpng  FROM geoslp5 where rid=184 ;").list();
>
> and converting object to byte[]
> and
> with usual java process
> ByteArrayOutputStream bos = new ByteArrayOutputStream();
> ... //
> bytes = bos.toByteArray ();
>
>
> But resulting image file(png) is defective ?
>
> What may the probable problems ?
>
> Do you have any recommendations ?
>
> regards
>
> --
> Ahmet Temiz
> Jeoloji Müh.
> Afet ve Acil Durum Yönetimi Başkanlığı
> Planlama ve Zarar Azaltma Dairesi Başkanlığı
>
>
> ________________________
>
> Ahmet Temiz
> Geological Eng.
> Information Systems - GIS Group
> Disaster and Emergency Management
> of Presidency
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
>
>


-- 
Ahmet Temiz
Jeoloji Müh.
Afet ve Acil Durum Yönetimi Başkanlığı
Planlama ve Zarar Azaltma Dairesi Başkanlığı


________________________

Ahmet Temiz
Geological Eng.
Information Systems - GIS Group
Disaster and Emergency Management
of Presidency
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20130617/2a5acfe9/attachment.html>