All
I have recently been handed the reins of a GeoServer 2.0.2 installation (I'm a
newbie) and I am currently migrating this installation to new hardware
architecture. During our initial testing our Oracle DBA noticed that the
SDO_FILTER is being used in potentially incompatible way (Oracle 11gR2 being
used);
SDO_FILTER is being written as follows:
SDO_FILTER(GEOM, :1, 'mask=anyinteract querytype=WINDOW') = 'TRUE'
Extract from GeoServer Log -
2011-04-15 09:19:50,724 DEBUG [geotools.jdbc] - SELECT ..... WHERE
(SDO_FILTER(GEOM, ?, 'mask=anyinteract querytype=WINDOW') = 'TRUE' AND (THEME
!= ? OR (THEME = ? AND MAKE = ?) OR (THEME = ? AND MAKE = ?)))
I am informed by my DBA that the SDO_FILTER should not have a mask defined. The
DBA is actually surprised that Oracle is not falling over with an "incorrect
parameters/arguments being used" error. The DBA also informs me that the
querytype=WINDOW is deprecated and no longer required but it is not an issue as
Oracle ignores it. Oracle is quietly ignoring the mask=anyinteract argument
instead of raising an error and executing the SDO_FILTER operation.
DBA informs me that the SDO_FILTER should look like
SDO_FILTER(GEOM, :1) = 'TRUE'
The question the DBA raised to me which I need some help on is whether
GeoServer is actually trying to execute an ANYINTERACT mask against the data as
this would returns fewer rows than SDO_FILTER?
The DBA suggested that if GeoServer is trying to execute an ANYINTERACT mask
then this should be using either SDO_RELATE with mask=anyinteract or
SDO_ANYINTERACT.
SDO_RELATE(GEOM, :1, 'mask=anyinteract') = 'TRUE'
OR
SDO_ANYINTERACT(GEOM, :1) = 'TRUE'
It came to light as Oracle has released a performance improvement patch for the
ANYINTERACT spatial operations and our DBA was searching to see if GeoServer
utilised the ANYINTERACT capability.
Please could I have some feedback?
* Especially if this would be resolved by upgrading to 2.0.3
* Is it potentially fixed in 2.1.*
* Have I posted this to the incorrect mailing list and it should have
been the Developer List for review
Regards
Russel
Russel Tinnion
GIS Architect & Key IT Account Manager
Direct dial 01793 714817
Mobile 07977 256809
Email [email protected]
Fax 0844 2499201
Helpdesk 0844 249 9200
TM Group (UK) Limited
200 Delta Business Park l Swindon l Wiltshire l SN5 7XD
www.tmgroup.co.uk<http://www.tmgroup.co.uk/><http://www.tmgroup.co.uk/>
TM Group includes
TM Property Searches Limited
www.tmpropertysearches.co.uk<http://www.tmpropertysearches.co.uk/>
TM Search Choice Limited
www.tmsearchchoice.co.uk<http://www.tmsearchchoice.co.uk/>
TM Property Searches Limited (company number 03775703) and TM Search Choice
Limited (company number 05281723) are wholly owned subsidiaries of TM Group
(UK) Limited (company number 05278187). TM Group and its subsidiaries are
registered in England: 200 Delta Business Park, Swindon, Wiltshire, SN5 7XD and
are appointed representatives of First Title Insurance plc which is authorised
and regulated by the Financial Services Authority.
>From time to time we would like to contact you with details of products,
>services and other events that may be of interest to you. We respect your
>privacy and will not share your personal data with any third parties outside
>TM Group. If you do NOT wish to receive such information please email
>[email protected]<mailto:[email protected]>.
The information in this email is confidential and is intended solely for the
addressee. Access to this email by anyone else is unauthorised. If you are not
the intended recipient, any use, disclosure, copying, distribution or retention
of any part of it is prohibited and may be unlawful.
Any views or opinions expressed are solely those of the author and do not
necessarily represent those of TM Group Limited. If you have received this
communication in error please notify us by email or by telephone 0844 2499200
and then delete the email and any copies.
________________________________________________________________________
This e-mail has been scanned for all viruses by Star. The
service is powered by MessageLabs. For more information on a proactive
anti-virus service working around the clock, around the globe, visit:
http://www.star.net.uk
________________________________________________________________________
------------------------------------------------------------------------------
Benefiting from Server Virtualization: Beyond Initial Workload
Consolidation -- Increasing the use of server virtualization is a top
priority.Virtualization can reduce costs, simplify management, and improve
application availability and disaster protection. Learn more about boosting
the value of server virtualization. http://p.sf.net/sfu/vmware-sfdev2dev
_______________________________________________
Geoserver-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users
