Failed to draw layer error with mysql points

Wed Jul 12 10:46:56 PDT 2006

Hi,

 I'm trying to get point data out of mysql to display on a map. I'm using
the following .ovf file, which I've tested using ogrinfo and seems to work
fine.

<OGRVRTDataSource>
    <OGRVRTLayer name="test_gis">
        <SrcDataSource>MYSQL:test_gis,user=root,password=mypword,host=
127.0.0.1,port=3306,tables=boxes</SrcDataSource>
        <SrcSQL>SELECT fid, x, y FROM boxes</SrcSQL>
        <GeometryType>wkbPoint</GeometryType>
        <GeometryField encoding="PointFromColumns" x="x" y="y" z="z"  />
    </OGRVRTLayer>
</OGRVRTDataSource>

When I go to the jsp that draws the map I get these errors:

description The server encountered an internal error () that prevented it
from fulfilling this request.

exception

org.apache.jasper.JasperException: Failed to draw layer named 'test_gis'.
    org.apache.jasper.servlet.JspServletWrapper.handleJspException(
JspServletWrapper.java:510)
    org.apache.jasper.servlet.JspServletWrapper.service(
JspServletWrapper.java:375)
    org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
    org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
    javax.servlet.http.HttpServlet.service(HttpServlet.java:802)

root cause

javax.servlet.ServletException: Failed to draw layer named 'test_gis'.
    org.apache.jasper.runtime.PageContextImpl.doHandlePageException(
PageContextImpl.java:858)
    org.apache.jasper.runtime.PageContextImpl.handlePageException(
PageContextImpl.java:791)
    org.apache.jsp.boxes.dartmoor_005fpoints_jsp._jspService
(dartmoor_005fpoints_jsp.java:74)
    org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
    javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
    org.apache.jasper.servlet.JspServletWrapper.service(
JspServletWrapper.java:332)
    org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
    org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
    javax.servlet.http.HttpServlet.service(HttpServlet.java:802)

root cause

java.lang.UnknownError: Failed to draw layer named 'test_gis'.
    edu.umn.gis.mapscript.mapscriptJNI.mapObj_draw(Native Method)
    edu.umn.gis.mapscript.mapObj.draw(mapObj.java:382)
    org.apache.jsp.boxes.dartmoor_005fpoints_jsp._jspService
(dartmoor_005fpoints_jsp.java:56)
    org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
    javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
    org.apache.jasper.servlet.JspServletWrapper.service(
JspServletWrapper.java:332)
    org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
    org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
    javax.servlet.http.HttpServlet.service(HttpServlet.java:802)

I've tried loads of different things in the .map file (below) but I still
end up with the same problem. Does anyone know what I'm going wrong?

Thanks,
Sarah

Map file:

MAP
    NAME DARTMOOR_POINTS
    STATUS ON
    SHAPEPATH "/usr/local/apache-tomcat-5.5.17/webapps/ROOT/boxes/"
    EXTENT 250000.000000 57000.000000 260000.000000 70000.000000
    SIZE 400 400

    WEB
        IMAGEPATH "/usr/local/apache-tomcat-5.5.17/webapps/ROOT/temp/"
        IMAGEURL "/temp/"
    END

    LAYER
        NAME "test_gis"
        STATUS ON
        TYPE POINT
            PROJECTION
                "proj=latlong"
                "ellps=WGS84"
                "datum=WGS84"
            END
        CONNECTIONTYPE OGR
        CONNECTION "test_gis.ovf"
        DATA "test_gis"
        CLASS
            NAME "boxes"
            SYMBOL 0
            COLOR 0 0 0
            OUTLINECOLOR 255 0 0
        END
    END
END

----------------------------------------------------------------------------------------------------------------------------

JSP File:

<%@ page language="java" contentType="text/html; charset=ISO-8859-1"
    pageEncoding="ISO-8859-1"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<%@ page import = "edu.umn.gis.mapscript.mapObj" %>
<%@ page import = "edu.umn.gis.mapscript.imageObj" %>

<%     mapObj vMap;
    String vMapName = "/usr/local/apache-tomcat-5.5.17
/webapps/ROOT/boxes/dartmoor_points.map";
    vMap = new mapObj(vMapName);
    String vMapFile = "/usr/local/apache-tomcat-5.5.17
/webapps/ROOT/boxes/dartmoor_points.mapfile";
    vMap.setMappath(vMapName);
    imageObj img = vMap.draw();
    img.save(vMapFile,vMap);

%>
<head>
</head>
<body>
Image:<br>
<image src="dartmoor_points.mapfile">
</body>
</html>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20060712/8ec9d995/attachment.htm>