Hello everyone!
When using a parametric SQL View and trying to escape the viewparams values
with backslashes as described in
http://docs.geoserver.org/stable/en/user/data/database/sqlview.html#using-a-parametric-sql-view
it raises the following ServiceException:
*java.lang.IllegalStateException: The specified String ends with an
incomplete escape sequence.*
When looking closer at the documentation and delimiting the String with "
*\;*" the log entry shows that a "*;*" is added at the end of the
substituted parameter, thus resulting in an invalid SQL and in the
following exception:
*java.io.IOExceptionORA-00911: invalid character*
Am I doing anything wrong here?
working:
http://localhost:8080/geoserver/myWorkspace/wms?service=WMS&version=1.1.0&request=GetMap&layers=myWorkspace:V_MAP_IR_COMPANIES&styles=&bbox=-180.0,-90.0,180.0,90.0&width=660&height=330&srs=EPSG:4326&format=image%2Fjpeg&viewparams=p_where:NAME
= 'ABC Inc'
not working:
http://localhost:8080/geoserver/myWorkspace/wms?service=WMS&version=1.1.0&request=GetMap&layers=myWorkspace:V_MAP_IR_COMPANIES&styles=&bbox=-180.0,-90.0,180.0,90.0&width=660&height=330&srs=EPSG:4326&format=image%2Fjpeg&viewparams=p_where:\NAME
= 'ABC Inc'\;
- Build Information
- Version 2.6.2
- Git Revision d8d01ae1fb41132bc15794670834c5606fdfa991
- Build Date 20-Jan-2015 01:54
- GeoTools Version 12.2 (rev a40c4d86948338d52120588f3ada518e923a57d8)
- GeoWebCache Version 1.6.1 (rev
1.6.x/01bbae5727a8a05babbd06e0dc2d4024e9318362)
Thanks a lot for any suggestions!
BR Paul
------------------------------------------------------------------------------
Dive into the World of Parallel Programming The Go Parallel Website, sponsored
by Intel and developed in partnership with Slashdot Media, is your hub for all
things parallel software development, from weekly thought leadership blogs to
news, videos, case studies, tutorials and more. Take a look and join the
conversation now. http://goparallel.sourceforge.net/
_______________________________________________
Geoserver-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users