On 10/09/18 19:39, O'Mara, John wrote:
Geoserver version, Oracle Extension version compatible with Oracle Version
Can someone point me to where I can find out what version of Oracle is
compatible for each version of GeoServer’s (Oracle Extension).
We are running Geoserver *2.13.1, *and are planning to upgrade to
Oracle 18.x.x.x in the next 6 months*. *
I have done some reading on this and the answer may be to use the
Oracle JDBC driver for the Oracle version you are on.
not the best advice, jdbc drivers are (at least) backwards and mostly
upward compatible and Oracle have released various driver versions that
have horrendous bugs such as an 8000byte limit for a string.
see:
https://www.oracle.com/technetwork/database/enterprise-edition/jdbc-faq-090281.html#01_02
We have the best experience with ojdbc8 v12.2.0.1 and ojdbc6 v11.2.0.4
(patch level is important, 12.1.0.2.0 (both ojdbc7 and ojdbc6 should be
avoided at all cost if using prepared statements)
I've recently upgraded some test suites to ojdbc8 18.3.0.0 running
against some 12.1 and 12.2 DB, and so-far-so-good.
I'd start upgrading to 2.14.x first though, if something is amiss
there's a much better chance of fixing.
Mark
_______________________________________________
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
