Hi, I came across this problem now too with GeoServer 2.14.0 against an Oracle 12.1.0.2 database with geoserver-2.14.0-oracle-plugin and ojdbc8.jar.
The problem seems to be that the generated SQL is missing a space between the table name and the "WHERE". If I run the SQL as per the log file I get the ORA-00907. Add a space and it works. The same query works on a different environment with GeoServer 2.13.1, so I'm going to first try upgrading the problem environment forwards to 2.14.1. If that doesn't work I'll go backwards to 2.13.1. John -- Sent from: http://osgeo-org.1560.x6.nabble.com/GeoServer-User-f3786390.html _______________________________________________ Geoserver-users mailing list Please make sure you read the following two resources before posting to this list: - Earning your support instead of buying it, but Ian Turton: http://www.ianturton.com/talks/foss4g.html#/ - The GeoServer user list posting guidelines: http://geoserver.org/comm/userlist-guidelines.html If you want to request a feature or an improvement, also see this: https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer [email protected] https://lists.sourceforge.net/lists/listinfo/geoserver-users
