Re: [Geoserver-users] Error when creating SQL view with parameters via REST

2017-02-09 Thread Andrea Aime
Hi, I have made a quick test on the UI and I cannot seem to set the "escapeSql" to true... have you tried flipping that switch off? It caught my attention because I did not remember about it, and indeed I was not the one to add that functionality. Cheers Andrea On Wed, Feb 8, 2017 at 9:00 PM, Dav

Re: [Geoserver-users] Database pooling for clustered Geoserver configuration

2017-02-09 Thread dimmihel
Hi Andrea, Apologies for not making crystal clear my purpose in my previous post. It is probably because I don't fully understand how the database pooling technique works. I was aiming using one database pool for the whole cluster (by the way I have multiple stores and not only one) but you are s

[Geoserver-users] Developping WPS that send PNG: Java returning RenderedImage?

2017-02-09 Thread Gabriel Vatin
Hello all, I already sent a question regarding bulding a custom WPS that sends PNG images, but without any answers. I try with some new details, maybe someone will have info about it. The things I made with success : > using GDAL with sucessive Java Runtimes (3 commands) > generating a PNG

Re: [Geoserver-users] Style Editor Preview Legend Errors

2017-02-09 Thread sikeoka
I am testing GeoServer 2.10.1. -- View this message in context: http://osgeo-org.1560.x6.nabble.com/Style-Editor-Preview-Legend-Errors-tp5307064p5307200.html Sent from the GeoServer - User mailing list archive at Nabble.com. -

Re: [Geoserver-users] Error when creating SQL view with parameters via REST

2017-02-09 Thread David Haynes II
I tried set the escape sql property to false, still have the same error "escapeSql": false 2017-02-09 09:23:50,963 WARN [geoserver.catalog] - Error while getting feature type, flushing cache and retrying: Error looking up primary key 2017-02-09 09:23:50,979 WARN [geoserver.rest] - Could not res

Re: [Geoserver-users] Error when creating SQL view with parameters via REST

2017-02-09 Thread David Haynes II
The log is showing the same syntax error 2017-02-07 09:27:14 CST [1564-1] terrapop_v1_94_01032017_demo_green ERROR: syntax error at or near "%" at character 166 2017-02-07 09:27:14 CST [1564-2] terrapop_v1_94_01032017_demo_green STATEMENT: select * from (select gi_id::text || '_0'::text as fake_

Re: [Geoserver-users] Error when creating SQL view with parameters via REST

2017-02-09 Thread Andrea Aime
Hi David, it sort of seems the parameter is not being replaced but... I see a "id" value in there, and your previous definition had "sgl_id". >From your json, in readable form (took the payload and pasted it at http://jsonprettyprint.com/ , extracted the interesting part of the formatted result):