<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2900.2995" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2>
<DIV><FONT face=Arial size=2>Hi all.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>I am trying to do a test application with mapscript
java (servlets) with oracle 9i in windows (MS4W), the test was done with a
mapfile.</FONT></DIV>
<DIV> </DIV>
<DIV>I installed ms4w in c:\ as indicated in the instructions, then I copied the
core dll to windows\system32 to make then avaivable to tomcat 5 and the
mapscript.jar in the application context, the applications works well in tomcat
because I can see a map created with a mapfile includinh shape layers.</DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>When I try an oracle layer there is not an error
message, simply it does not work.</FONT></DIV>
<DIV> </DIV>
<DIV>The ms4w is configured to work with oracle spatial ?, </DIV>
<DIV> </DIV>
<DIV>This is the mapfile</DIV>
<DIV>------------------------------------------------------------------------------------------------------------------------------------------------------------------------</DIV>
<DIV> </DIV>
<DIV>MAP<BR> NAME USA1<BR> STATUS
ON<BR> SIZE 800 500<BR> IMAGETYPE
PNG<BR> IMAGECOLOR 240 240 240<BR> SHAPEPATH
"D:\u01\data\maps\V1.5"<BR> EXTENT -78 -4 -70
10<BR> UNITS dd<BR>
PROJECTION<BR> "proj=latlong" "ellps=WGS84"
"datum=WGS84"<BR> END<BR>
WEB<BR> IMAGEPATH
"/var/www/html/tmp/"<BR> IMAGEURL
"/tmp/"<BR> END <BR>
LAYER<BR> NAME CAJEROS<BR> TYPE
POINT<BR> CONNECTIONTYPE oraclespatial<BR>
CONNECTION <A
href="mailto:user/pwd@service">user/pwd@service</A><BR> DATA
"EPR_GEOLOC FROM SELECT EPR_GEOLOC FROM ELEMENTOS_PORTAL WHERE EPR_TEP_ID = 2
USING SRID 8307"<BR> DUMP TRUE<BR> CLASS
<BR> STYLE<BR>
OUTLINECOLOR 0 0 0<BR> COLOR 0 128
128<BR> END<BR> END <BR>
END <BR>END</DIV>
<DIV> </DIV>
<DIV>------------------------------------------------------------------------------------------------------------------------------------------------------------------------</DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Thanks in advance.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Juan Camilo Velàsquez L.</FONT></DIV>
<DIV><FONT face=Arial size=2>Mapas y Datos
S.A.</FONT></DIV></FONT></DIV></BODY></HTML>