The Oracle jdbc plugin does not support the "strToLowerCase" filter function - or, indeed, many of the "org.geotools.filter.function.FilterFunction_" functions.
I have a problem whereby application software is sending valid WFS queries to Geoserver which include the "strToLowerCase" function. For performance reasons (dealing with large datasets) I need to have this filter sent to the underlying Oracle database with a suitable "WHERE" clause: WHERE LOWER(field_name) LIKE 'search_value%' This preferred database filtering is how PostGIS DataStores work when the "Encode functions" option is enabled. *WORKING SOLUTION* I have already confirmed (?) that the code change required to implement this change in the gt-jdbc-oracle extension is minimal: https://github.com/geotools/geotools/compare/22.2...djerrard:djerrard_oracle_filter?expand=1 With these code changes in place I have rebuilt gt-jdbc-oracle-22.2.jar. It is currently installed at a test site (Geoserver 2.16.2) where it's getting a good thrashing - so far so good! *WHAT'S NEXT?* - I have never been here before - I am not a java developer, so unable to provide any useful technical contribution in that capacity - I would obviously like to see this change incorporated into the Geotools code base - possibly augmented with other similar Oracle plugin enhancements (are there any others on the "wish list"?) In the spirit of the "Talk first policy" on the Contributions page, I'd be happy to talk further. (Also, thanks to Jody Garnett for the helpful hints he's provided in that regard already.) Having delved deeper into this space than I've ever been before, I'm now keen to see this through to a happy conclusion. I also feel like I've got some "skin in the game" and would be pleased to contribute in any way possible. I look forward to the journey! Cheers, David
_______________________________________________ GeoTools-Devel mailing list GeoTools-Devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geotools-devel
