On Thu, Feb 14, 2013 at 4:00 PM, Robert Nix <[email protected]> wrote:
> Sorry, I might be misunderstanding filters. I was thinking of
> this<http://docs.geoserver.org/stable/en/user/filter/function_reference.html>
> :
>
> Unless otherwise specified, none of the filter functions in this reference
> are understood natively by the data stores, and thus expressions using them
> will be evaluated in-memory.
>
>
> So i assumed that other types of filters (except SQLViews) would simply be
> translations to this type of filtering. Sorry for my newbie assumptions.
>
>
>
> Also, when i try to create a SQLView, i get an error:
>
>
> - Failed to create SQL view: ERROR: syntax error at or near ")"
> Position: 88
> -
>
>
> My view is simply:
>
> select id, fid, the_geom from mytable where fid = %fid%
>
>
>
Did you declare the fid parameter in the params table, and set a proper
default value for it?
> If i remove the where clause (which makes the SQLVIew useless?), i can
> create it but accessing it with the &viewparams=fid:102376549 i get:
>
> <?xml version="1.0" encoding="UTF-8" standalone="no"?><!DOCTYPE
> ServiceExceptionReport SYSTEM "
> http://localhost:8080/geoserver/schemas/wms/1.1.1/WMS_exception_1_1_1.dtd";>
> <ServiceExceptionReport version="1.1.1" > <ServiceException
> code="internalError">
> Rendering process failed
> java.io.IOException
> null
> java.util.ArrayList cannot be cast to java.lang.String
> </ServiceException></ServiceExceptionReport>
>
>
This one does not help, we need the full stack trace to make head or tails
of it.
Please enable "verbose exception reporting" in the server config panel and
try again
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
-------------------------------------------------------
------------------------------------------------------------------------------
The Go Parallel Website, sponsored by Intel - in partnership with Geeknet,
is your hub for all things parallel software development, from weekly thought
leadership blogs to news, videos, case studies, tutorials, tech docs,
whitepapers, evaluation guides, and opinion stories. Check out the most
recent posts - join the conversation now. http://goparallel.sourceforge.net/
_______________________________________________
Geoserver-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users
