[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgis-users
Subject:    Re: [postgis-users] ST_AsPNG is problematic in Java
From:       Bborie Park <dustymugs () gmail ! com>
Date:       2013-06-17 16:57:37
Message-ID: CAKVfRvEnGfyQJukeXC9wyj8dg_q+h5jheMCsz810mjbH2sk9cA () mail ! gmail ! com
[Download RAW message or body]

Ahmet,

Can you try one of the example code found in the docs?

http://www.postgis.net/docs/manual-dev/using_raster_dataman.html#RT_Raster_Applications


By testing out one of the examples, you should be able to tell if the
problem is in the database or in your java code.

-bborie

On Mon, Jun 17, 2013 at 6:04 AM, Ahmet Temiz <ahmettemiz88@gmail.com> wrote:
> 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@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@lists.osgeo.org
> > [mailto:postgis-users-bounces@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@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
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users@lists.osgeo.org
> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
> 
_______________________________________________
postgis-users mailing list
postgis-users@lists.osgeo.org
http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users


[prev in list] [next in list] [prev in thread] [next in thread]