Currently working on a PR to get testing Oracle up to par with other databases in https://github.com/geotools/geotools/pull/2890 so "not having an oracle server" will no longer be an excuse ;-)
Mark Op do 23 apr. 2020 om 08:48 schreef Jody Garnett <jody.garn...@gmail.com>: > Welcome to the deep end of the pool, and thank you for starting the email > thread. > > GeoTools is in an odd spot where we like to support new developers > (including those new to Java) but for this specific issue not many folks > have an oracle server to test against. > > — > Jody > > On Wed, Apr 22, 2020 at 6:06 PM David Jerrard <djerr...@gmail.com> wrote: > >> 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 >> > -- > -- > Jody Garnett > _______________________________________________ > GeoTools-Devel mailing list > GeoTools-Devel@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/geotools-devel > -- Disclaimer; This message is just a reflection of what I thought at the time of sending. The message may contain information that is not intended for you or that you don't understand.
_______________________________________________ GeoTools-Devel mailing list GeoTools-Devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geotools-devel
