[ms4w-users] Using Oracle with ms4w

[Jeff McKenna]

actually i'm not a java mapscript user, so I'm really of no help.

jeff




Juan Camilo Velásquez Londoño wrote:
> Hi all.
>  
> 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.
>  
> 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.
>  
> When I try an oracle layer there is not an error message, simply it does 
> not work.
>  
> The ms4w is configured to work with oracle spatial ?,
>  
> This is the mapfile
> ------------------------------------------------------------------------------------------------------------------------------------------------------------------------
>  
> MAP
>     NAME USA1
>     STATUS ON
>     SIZE 800 500
>     IMAGETYPE PNG
>     IMAGECOLOR 240 240 240
>     SHAPEPATH "D:\u01\data\maps\V1.5"
>     EXTENT -78 -4 -70 10
>     UNITS dd
>     PROJECTION
>   "proj=latlong"  "ellps=WGS84"  "datum=WGS84"
>     END
>     WEB
>         IMAGEPATH "/var/www/html/tmp/"
>         IMAGEURL "/tmp/"
>     END 
>     LAYER
>     NAME CAJEROS
>     TYPE POINT
>     CONNECTIONTYPE oraclespatial
>     CONNECTION user/pwd at service <mailto:user/pwd at service>
>     DATA "EPR_GEOLOC FROM SELECT EPR_GEOLOC FROM ELEMENTOS_PORTAL WHERE 
> EPR_TEP_ID = 2 USING SRID 8307"
>     DUMP TRUE
>     CLASS
>      STYLE
>        OUTLINECOLOR 0 0 0
>        COLOR 0 128 128
>      END
>     END
>   END 



-- 
Jeff McKenna
DM Solutions Group Inc.
http://www.dmsolutions.ca