Oracle Woes

[Christopher Condit]

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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/mapserver-users/attachments/20051222/77661091/attachment.html