Hi List,
I'm using GeoServer with debuging on full. I noticed this when getting
the bounding box of an Oracle connection:
04 Jan 14:24:38 DEBUG [org.geotools.jdbc] - CREATE CONNECTION
04 Jan 14:24:38 WARN [org.geotools.jdbc] - Failed to use
SDO_TUNE.EXTENT_OF, falling back on envelope aggregation
java.sql.SQLException: ORA-00942: table or view does not exist
ORA-06512: at "MDSYS.SDO_TUNE", line 817
at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
So investigated out of curiosity. We do actually have the
SDO_TUNE.EXTENT_OF function available, and it does work when I query the
database directly using it (i.e.: SELECT
SDO_TUNE.EXTENT_OF('BOUNDARY_WSHIRE_COUNTY', 'SDO_GEOMETRY') FROM
DUAL; works just fine).
So why would it fail for GeoServer? Given the error is a "table not found"
is the correct table being sent? The logs don't show the actual query being
sent so I can't see whats happening.
I even downloaded the GeoServer source to try and find out what's happening
(I don't do Java, but it should be readable at least), but of course after
searching it couldn't actually find it because its in the Oracle plugin. I
can't seem to find the source for that.
Is this a bug?
Jonathan
This transmission is intended for the named addressee(s) only and may contain
sensitive or protectively marked material up to RESTRICTED and should be
handled accordingly. Unless you are the named addressee (or authorised to
receive it for the addressee) you may not copy or use it, or disclose it to
anyone else. If you have received this transmission in error please notify the
sender immediately. All email traffic sent to or from us, including without
limitation all GCSX traffic, may be subject to recording and/or monitoring in
accordance with relevant legislation.
------------------------------------------------------------------------------
Master HTML5, CSS3, ASP.NET, MVC, AJAX, Knockout.js, Web API and
much more. Get web development skills now with LearnDevNow -
350+ hours of step-by-step video tutorials by Microsoft MVPs and experts.
SALE $99.99 this month only -- learn more at:
http://p.sf.net/sfu/learnmore_122812
_______________________________________________
Geoserver-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users
