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
