Hi David,
The error: "OracleSpatial not supported" occurs whne the version of
Mapserver that you are using don't contains the connection with
OracleSpatial enabled. To fix this you have two ways, the first is use a
version with this support, and the second is compile Mapserver by yourself.
The blank image can occur because the objects from your layer was not
inside of the extent that you defined. Another issue can be with
OracleSpatial, how did you imported the data in database? Are you use
shape or library? If yes, did you execute the SDO_MIGRATE.TO_CURRENT
(you can find more info in the section 17 of the OracleSpatial manual)?
I don't recommend to use the "*" in the data definition, like "select *
from".
Best regards.
---------------------------------------------------
Fernando Simon
UMN Mapserver and Oracle spatial developer
Hunter, David - St. Louis Park, MN wrote:
I am trying to set up MapServer CGI to run in Tomcat with Oracle
Spatial support. I got the cgi-bin set up and working, and then
created a test map file and HTML template. I have test data in .TAB
form and in Oracle 10g. When using the default libmap.dll from MS4W
2.2.5, the .TAB layer displays OK, but when I add the Oracle layer it
displays the “OracleSpatial not supported” message. When I copy the
libmap.dll from cgi-bin/ignored-libmap/oracle10g to cgi-bin, a totally
blank page is displayed, no matter what layer (.TAB and/or Oracle) I
use. It’s as if the template is not found or ignored. There are no
messages in the log file or anything else to diagnose the problem.
Anybody have any ideas? Here’s the map file I’m playing with:
MAP
IMAGETYPE PNG24
EXTENT -79.9 40.3 -71.6 45.1
SIZE 650 520
SHAPEPATH "roadbase/"
SYMBOLSET "symbols/symbols35.sym"
FONTSET "fonts/fonts.list"
IMAGECOLOR 255 255 255
UNITS miles
WEB
IMAGEPATH "/Tomcat/webapps/ext-1.0.1/tmp/"
IMAGEURL "/ext-1.0.1/tmp/"
TEMPLATE "oratest.htm"
LOG "/Tomcat/logs/mapserver.log"
END
LAYER
NAME "Counties_Labels"
CONNECTIONTYPE ogr
CONNECTION "NYxxxxcb.tab"
STATUS DEFAULT
TYPE ANNOTATION
LABELITEM "countyname"
CLASS
LABEL
TYPE TRUETYPE
FONT arial
SIZE 10
COLOR 128 128 128
OUTLINECOLOR 255 255 255
ANTIALIAS TRUE
ANGLE auto
FORCE false
POSITION auto
OFFSET 0 0
MINDISTANCE 335
END
END
END
LAYER
NAME "Counties"
CONNECTIONTYPE ogr
CONNECTION "NYxxxxcb.tab"
STATUS DEFAULT
TYPE POLYGON
CLASS
NAME "Counties"
OUTLINECOLOR 128 128 128
SYMBOL "circle"
SIZE 3
END
END
LAYER
NAME "FireDistricts"
STATUS DEFAULT
TYPE POLYGON
CONNECTIONTYPE oraclespatial
CONNECTION "data/[EMAIL PROTECTED]"
#DATA "GEOLOC FROM (SELECT * FROM locppc.us_1007 WHERE state = 'NY')
USING VERSION 10g"
DATA "GEOLOC FROM locppc.us_1007 USING VERSION 10g"
DUMP TRUE
CLASS
STYLE
OUTLINECOLOR 0 0 0
COLOR 0 128 128
SYMBOL "circle"
SIZE 1
END
END
END
END
*David S. Hunter*
/Sr. Software Engineer
Fidelity National Geographic Solutions
division of Fidelity National Financial
5353 Gamble Drive, Suite 201
St. Louis Park, MN 55416
Email: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
Phone: 952.542.1440 ext. 256
Fax: 952.542.3859///
