[Geotools-devel] [jira] (GEOT-4357) Oracle optimisation not compatible with

Thu, 20 Dec 2012 23:17:50 -0800

Issue Type: Bug Bug
Assignee: Unassigned
Created: 21/Dec/12 1:16 AM
Description:

In looking at GEOS-5516 GetFeatureInfo manages to produce a query we cannot handle:

Caused by: java.sql.SQLException: ORA-29902: error in executing ODCIIndexStart() routine
ORA-13243: specified operator is not supported for 3- or higher-dimensional R-tree
ORA-06512: at "MDSYS.SDO_INDEX_METHOD_10I", line 333

Stack trace is so deep there is not much context for us:

at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
at org.geotools.jdbc.JDBCDataStore.getAggregateValue(JDBCDataStore.java:1298)
... 95 more



Which has us in this block of code:




if ( dialect instanceof PreparedStatementSQLDialect ) {
   st = selectAggregateSQLPS(function, att, featureType, query, cx);
   rs = ((PreparedStatement)st).executeQuery();
}





Context:



    
	
  • function: count
    • 
	
  • query:

    

    Query:
    
   feature type: POINT_TEST
    
   filter: [ GEOMETRY intersects POLYGON ((130.89027224999998 -16.448910635807145, 130.890813984375 -16.448910635807145, 130.890813984375 -16.449452365218924, 130.89027224999998 -16.449452365218924, 130.89027224999998 -16.448910635807145)) ]
    
   [properties: UFI, SUB_CLASS, NAME, PLACENAME_ID, SCALE, RELIABILITY_DATE, ACCURACY_HORIZONTAL, ACCURACY_VERTICAL, SOURCE, GEOMETRY]
    

    • 





And the sql produced by selectAggregateSQLPS is:




SELECT count AS gt_result_ FROM (SELECT * FROM (SELECT * FROM POINT_TEST WHERE  SDO_RELATE(GEOMETRY, ?, 'mask=anyinteract querytype=WINDOW') = 'TRUE' ) WHERE ROWNUM <= 50) gt_limited_
Project: GeoTools
Priority: Major Major
Reporter: Jody Garnett
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators.
For more information on JIRA, see: http://www.atlassian.com/software/jira 
------------------------------------------------------------------------------
LogMeIn Rescue: Anywhere, Anytime Remote support for IT. Free Trial
Remotely access PCs and mobile devices and provide instant support
Improve your efficiency, and focus on delivering more value-add services
Discover what IT Professionals Know. Rescue delivers
http://p.sf.net/sfu/logmein_12329d2d
_______________________________________________
GeoTools-Devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geotools-devel

Reply via email to