I think this is fixed is the nightly build? The problem stems from
Oracle not providing boolean values as true/false - they need be
specified as 1/0. Hence TRUE AND TRUE does not work however 1 = 1 does.
Regards,
Miles
Justin Deoliveira <> wrote:
Hi,
I don't see anything obviously wrong with the syntax of the query...
My
guess would be perhaps that its something to with version... and maybe
a
function not supported in a particular version. Just a guess.
More information about the version of Oracle you are using might be
helpful. Also which context are you making this request. It sounds
like
you are making a WMS request and getting a blank map back?
-Justin
aureate820 wrote:
I converted some shapfile data into ORACLE using shp2sdo,then i
config
them in GEOSERVER. When i show them,it is blank.
The Error is:
Caused by: org.geotools.data.DataSourceException: Error Performing
SQL query: SE
LECT "GEOM" FROM "ZCXZCW_P" WHERE ((TRUE AND TRUE) AND
SDO_RELATE("GEOM",MDSYS.S
DO_GEOMETRY(2003,2437,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3),MDSYS.SDO
_ORDINAT
E_ARRAY(495489.6889135856,481643.29620508687,512910.36619871506,499776.3
43193325
7)),'mask=anyinteract querytype=WINDOW') = 'TRUE' )
___________________________________________________________________________
Australian Antarctic Division - Commonwealth of Australia
IMPORTANT: This transmission is intended for the addressee only. If you are not the
intended recipient, you are notified that use or dissemination of this communication is
strictly prohibited by Commonwealth law. If you have received this transmission in error,
please notify the sender immediately by e-mail or by telephoning +61 3 6232 3209 and
DELETE the message.
Visit our web site at http://www.antarctica.gov.au/
___________________________________________________________________________
Cool, thanks Miles :).
aureate (sorry, you didn't sign your original mail :)): Could you grab a nightly build from here:
http://gridlock.openplans.org/geoserver/
and verify for us. Thanks.
-Justin
Miles Jordan wrote:
I think this is fixed is the nightly build? The problem stems from
Oracle not providing boolean values as true/false - they need be
specified as 1/0. Hence TRUE AND TRUE does not work however 1 = 1 does.
Regards,
Miles
Justin Deoliveira <> wrote:
Hi,
I don't see anything obviously wrong with the syntax of the query...
My
guess would be perhaps that its something to with version... and maybe
a
function not supported in a particular version. Just a guess.
More information about the version of Oracle you are using might be
helpful. Also which context are you making this request. It sounds
like
you are making a WMS request and getting a blank map back?
-Justin
aureate820 wrote:
I converted some shapfile data into ORACLE using shp2sdo,then i
config
them in GEOSERVER. When i show them,it is blank.
The Error is:
Caused by: org.geotools.data.DataSourceException: Error Performing
SQL query: SE
LECT "GEOM" FROM "ZCXZCW_P" WHERE ((TRUE AND TRUE) AND
SDO_RELATE("GEOM",MDSYS.S
DO_GEOMETRY(2003,2437,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3),MDSYS.SDO
_ORDINAT
E_ARRAY(495489.6889135856,481643.29620508687,512910.36619871506,499776.3
43193325
7)),'mask=anyinteract querytype=WINDOW') = 'TRUE' )
___________________________________________________________________________
Australian Antarctic Division - Commonwealth of Australia
IMPORTANT: This transmission is intended for the addressee only. If you are not the
intended recipient, you are notified that use or dissemination of this communication is
strictly prohibited by Commonwealth law. If you have received this transmission in error,
please notify the sender immediately by e-mail or by telephoning +61 3 6232 3209 and
DELETE the message.
Visit our web site at http://www.antarctica.gov.au/
___________________________________________________________________________
-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
!DSPAM:4007,4889390d83901849620573!
--
Justin Deoliveira
The Open Planning Project
jdeolive@anonymised.com