ORA-13373: Element of type Extent is not supported for Geodetic data
--------------------------------------------------------------------
Key: GEOT-3869
URL: https://jira.codehaus.org/browse/GEOT-3869
Project: GeoTools
Issue Type: Bug
Components: jdbc-oracle plugin
Affects Versions: 8.0-M1, 2.7.2
Environment: Oracle 9.2
Reporter: Eduardo Riesco
Assignee: Andrea Aime
Fix For: 2.7.3, 8.0-M2
Attachments: Oracle9.patch, TestOracle.java
Oracle's ORA-13373 message has different meanings for each Oracle version
(http://ora-messages.adgoogy.com/ORA-13373).
Geotool's BBOX Filter doesn't work with Oracle 9i. This make impossible to
connect Geoserver with Oracle 9i since Geoserver always use this filter.
I'm trying to connect using the TestOracle.java file attached.
This problem and it's solution is explained in
https://forums.oracle.com/forums/thread.jspa?threadID=218341
I've attached a patch to solve the problem. It's dirty and I don't know if it
works with Oracle 10i (I only have Oracle 9.2), but it gives an idea about
where the problem is and the possible solution.
The patch modifies two files. In both we should check 2 conditions to do
different things for Oracle9 or Oracle10. We should check if the geometry
attribute is geodetic and de Oracle version. Really, in the patch, I'm checking
only one of this conditions.
Adding this patch to my Geoserver now I'm been able to connect it with an
Oracle 9.2 database.
I hope this helps.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
All the data continuously generated in your IT infrastructure contains a
definitive record of customers, application performance, security
threats, fraudulent activity and more. Splunk takes this data and makes
sense of it. Business sense. IT sense. Common sense.
http://p.sf.net/sfu/splunk-d2dcopy1
_______________________________________________
Geotools-devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geotools-devel
