Oracle Woes

[Fernando Simon]

Hi Christopher,
    How you added the data in your database? Using shp2sdo, if yes,
after the import did you execute the MIGRATE function?
    If are you trying to do query functions or modes like nquery,
query, querybyattribute... You need to specify the RELATE operator in
your data definition, in your case:
    DATA "SHAPE FROM (SELECT SHAPE, SCIENTIFICNAME FROM SPECIES WHERE
SCIENTIFICNAME ='Some name') USING RELATE"
    Are you already tried to execute the same operations without
projection definition?
    Best regards

------------------------------------------
Fernando Simon
Mapserver and Oracle Spatial developer
------------------------------------------


Citando Christopher Condit <condit at SDSC.EDU>:

> Hi All-
> 
> I'm having tremendous problems getting Oracle 10g Spatial support
> to
> work with MapServer 4.8 (or 4.6 for that matter).
> 
> I've tried both the native driver and the OGR driver and shp2img
> just
> seems to hang - no error message.
> 
> This table has about 2 million records, with SDO point geometry and
> a
> spatial index.  The query returns about 100 records.
> 
> Am I doing something obviously wrong?
> 
> Ogrinfo does work, however, but I can't find any documentation on
> how to
> add the select statement to an OGR layer in the mapfile.  Does
> anyone
> have any idea how to accomplish this?
> 
>  
> 
> Any help would be greatly appreciated!
> 
>  
> 
> Here's my layer definition:
> 
> LAYER #Test of Oracle points
> 
>   NAME oracletest
> 
>   METADATA
> 
>     "wfs_title"    "SimpleOracleTest" ## REQUIRED
> 
>     "wfs_geometry_element_name" "shape"
> 
>     "gml_include_items" "all" 
> 
>   END
> 
>   TYPE POINT
> 
>   STATUS DEFAULT
> 
>   CONNECTIONTYPE oraclespatial
> 
>   CONNECTION "user/password"
> 
> #  CONNECTIONTYPE ogr
> 
> #  CONNECTION "OCI:user/password"
> 
>   DATA "SHAPE FROM (SELECT SHAPE, SCIENTIFICNAME FROM SPECIES
> WHERE
> SCIENTIFICNAME ='Some name')"
> 
>   CLASS
> 
>     COLOR        232 0 0
> 
>     OUTLINECOLOR 0 255 0
> 
>   END
> 
>   DUMP TRUE
> 
>   PROJECTION
> 
>     "init=epsg:4326"
> 
>   END
> 
> END #end of layer
> 
>  
> 
> Thanks,
> 
>  
> 
> Chris
> 
> 




-------------------------------------------------
  Univali - Webmail - http://webmail.univali.br