Re: [Geotools-devel] On org.postgresql.util.PSQLException: This ResultSet is closed

[carlo c. <car...@ge...>]

Andrea,
 the queried layer is an SQL view:

select uuid_area,
       uuid_nocs, uuid_gaul,
       da.ia_name,
       ia_listname,
       dn.at_iso3,
       at_iso2,
       at_admlevel,
       '${resolver.getMeasureName(''' || uuid_area || ''')}' AS
measure_name,
       '${resolver.getValue(''' || uuid_area || ''')}' AS measure_value,
       '${resolver.getExtendedValue(''' || uuid_area || ''')}' AS
extended_value,
       at_geom
  from gaul.dt_gaul dg
       left join nocs.dt_nocs dn on dg.bk_gaul = dn.at_gaul
       left join faostat.dt_area da on dn.at_faostat = da.bk_area
 where 1 = 1
   and at_admlevel = 0
   and (((bk_area < 300 or bk_area in (351)) and bk_area not in (261, 266,
268, 269)) or bk_area is null)

We are going to perform tests using an older version of GeoServer 2.2.x to
understand if it is a regression (as it seems).

Cheers,
Carlo


2013/3/4 Andrea Aime <and...@ge...>

> On Mon, Mar 4, 2013 at 3:23 PM, carlo cancellieri <
> car...@ge...> wrote:
>
>> Recently I'm having some random resultset problems on postgis layers in
>> geoserver 2.2.5 (geotools 8.7).
>>
>> May be related to this https://jira.codehaus.org/browse/GEOT-4204 ?
>>
>
> Seems unlikely... are you using complex features or joins of any kind?
> By the stack trace, it does not seem you do
>
> Cheers
> Andrea
>
>
> --
> ==
> Our support, Your Success! Visit http://opensdi.geo-solutions.it for more
> information.
> ==
>
> Ing. Andrea Aime
> @geowolf
> Technical Lead
>
> GeoSolutions S.A.S.
> Via Poggio alle Viti 1187
> 55054  Massarosa (LU)
> Italy
> phone: +39 0584 962313
> fax: +39 0584 1660272
> mob: +39  339 8844549
>
> http://www.geo-solutions.it
> http://twitter.com/geosolutions_it
>
> -------------------------------------------------------
>



-- 
==
Our support, Your Success! Visit http://opensdi.geo-solutions.it for more
information.
==

Dott. Carlo Cancellieri
@cancellieric
Software Engineer

GeoSolutions S.A.S.
Via Poggio alle Viti 1187
55054  Massarosa (LU)
Italy
phone: +39 0584 962313
mobile: +39 3371094494
fax:   +39 0584 1660272

http://www.geo-solutions.it
http://twitter.com/geosolutions_it

-------------------------------------------------------