oracle spatial

Wed Jun 14 03:06:18 EDT 2006

Hello,

I can say only that I had no problem in connecting to my Oracle 9i database with MS4W installation. I did just the manouvres described in the readme-file, and did not set any new environment variables.
My connection string is like:

CONNECTIONTYPE ORACLESPATIAL
     CONNECTION "USER/PASSWD at DB.WORLD <mailto:USER/PASSWD at DB.WORLD> "
     DATA "GEOLOC FROM GIS_POLYGONS USING UNIQUE MSLINK"

Have you tried to feed the SQL statement from the error message directly to SQL-Plus? Do you get results then?  Is your spatial table OK for Mapserver? I do not know exactly what Mapserver needs, but for Geoserver there must exist a numerical primary key, spatial index and a correct entry in SDO_GEOM_METADATA. In my case if I can connect my data with Geoserver it is available for Mapserver as well.

Good luck,

-Jukka Rahkonen-

________________________________

Lähettäjä: UMN MapServer Users List puolesta: Daniel Goetz
Lähetetty: ti 13.6.2006 17:00
Vastaanottaja: MAPSERVER-USERS at LISTS.UMN.EDU
Aihe: Re: [UMN_MAPSERVER-USERS] oracle spatial

Thanks Wim for your help,

but the syntax in the command-line of the browser didn't bring the solution.

Roundup:
I have installed Oracle 10g Release 1 client on my computer. Then unzipped the latest ms4w package. Did teh .dll swapping for oracle spacial support like described in the redme-file of the ms4w-package.
Then I wrote a mapfile using the native oracle spatial support of the mapserver (not the OGR-Support).

MAP
NAME "Nbg"
#EXTENT 426666.49 466058.21 448321.44 490754.58
EXTENT 433000 478000 434000 479000
#SIZE 1400 1800
SIZE 400 400
SHAPEPATH "/ms4w/Apache/htdocs/raster/daten"
IMAGETYPE PNG
IMAGECOLOR 255 255 255
UNITS METERS
STATUS ON
PROJECTION
"init=epsg:4326"
END

WEB
        IMAGEPATH "c:\ms4w\Apache\htdocs\raster\tmp\"
        IMAGEURL "/raster/tmp/"
        TEMPLATE "test_template.html"  
END

LAYER
        NAME "RWG"
        CONNECTIONTYPE OracleSpatial
        CONNECTION "username/password at service"
        DATA "GEOM FROM RWG_TBL USING SRID 82032"
        TYPE POINT
        STATUS ON
        PROJECTION
"init=epsg:4326"
END
        CLASS
            NAME "Punkte"
            STYLE
                OUTLINECOLOR 128 128 128
                COLOR 225 225 185
            END
        END
END

END

Then I did some settings in the httpd.cong of the apache server like described in the "Using oracle spatial" howto. But I don't really know whether this was right. In the "ENV VARS" column I added the parameter:

SetEnv ORACLE_HOME "c:/ora10gR1_client"
SetEnv TNS_ADMIN "c:/ora10gR1_client/NETWORK/ADMIN"
SetEnv PATH "c:/ora10gr1_client/bin"

I saved this and restarted apache. Then I tried to map the oracle data via umn-mapserver. Therefor I wrote the following in my browser:

http://localhost/cgi-bin/mapserv.exe?map=c:/ms4w/Apache/htdocs/raster/test_os_native.map&layers=all&mode=map

Then I get a error-message from apache:

"Internal Server Error.The server encountered an internal error or misconfiguration and was unable to complete your request."

In the errorlog of the apache the following was  logged:

[Tue Jun 13 15:45:56 2006] [error] [client 127.0.0.1] Premature end of script headers: mapserv.exe

But I don't know what this means. But when I consciously do some mistake in the DATA expression in the .mapfile (giving a tablename that does not exist in the database) I get the following error-message from the mapserver (and not the apache):

msDrawMap(): Image handling error. Failed to draw layer named 'RWG'.
msOracleSpatialLayerWhichShapes(): OracleSpatial error. Error: ORA-00942: Tabelle oder View nicht vorhanden . Query statement: SELECT rownum, GEOM FROM RWG_TBL.g WHERE SDO_FILTER( GEOM, MDSYS.SDO_GEOMETRY(2003, 82032, NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3),MDSYS.SDO_ORDINATE_ARRAY(433000,478000,434000,479000) ),'querytype=window') = 'TRUE' . Check your data statement.

So you can see that mapserver is able to connect to the database, because it says that the Table or View is not available.
The really astonishing is that after doing the .dll swapping for oracle spatial support other mapserver-projects that have worked fine on my computer before the swapping cause the same appache error-message.
Could anybody imagine what might be the problem? Might it be that mapserver and the version of my oracle client (10g Release 1) are not compiled against each other? Or is there another mistake I have done?

Please help me. I would be very glad and thankful for any hint. Thank you so much.

regards

Daniel

-------- Original-Nachricht --------
Datum: Mon, 12 Jun 2006 20:08:22 +0200
Von: Wim Blanken <w.blanken at geon.nl>
An: \'Daniel Goetz\' <madprof at GMX.CH>
Betreff: RE: [UMN_MAPSERVER-USERS] oracle spatial

> Hello Daniel,
>
> I think your solution is simple. You have to specify &mode=map
> on the commandline to make it work. If you don't mapserver needs a
> template
> to show the results of the cgi-call.
>
> http://localhost/cgi-bin/mapserv.exe?map=c:/ms4w/Apache/htdocs/raster/test_o
> s_ogr.map&layers=all&mode=map
>
>
> Regards
>
> Wim Blanken
>
>
> -----Original Message-----
> From: UMN MapServer Users List [mailto:MAPSERVER-USERS at LISTS.UMN.EDU] On
> Behalf Of Daniel Goetz
> Sent: Monday, June 12, 2006 1:54 PM
> To: MAPSERVER-USERS at LISTS.UMN.EDU
> Subject: [UMN_MAPSERVER-USERS] oracle spatial
>
> Hi,
>
> I have the ms4w installed on my computer and I want to map geodata, lying
> in
> a oracle spatial database on a server in the intranet, via umn mapserver.
> Therefor I enabled OGR-OCI support described in the readme-file of the
> ms4w-package (I "installed" 10g oracle instant client on my computer, set
> set windows environmet variable PATH and did the described .dll swapping).
>
> Then I tested, whether OGR now supports the OCI with ogrinfo. Therefor I
> had
> to modify the syntax a littel bit to get information: I wrote "ogrinfo
> "OCI:username/password at host:port/service_name" instead of described on the
> ogr-site/oracle spatial "OCI:username/password at service_name". The result
> was
> that ogrinfo listed me the relevant tables that contain geometric data.
>
> Then I tried to map the data via mapserver. Therefor I wrote the following
> .map-file (therefor I correspond to the example given in the "Vector Data
> Access-Reference-Guide" on the mapserver-site):
>
> MAP
> NAME "Oracle"
> EXTENT 426666.49 466058.21 448321.44 490754.58
> SIZE 1400 1800
> SHAPEPATH "/ms4w/Apache/htdocs/raster/daten"
> IMAGETYPE PNG
> IMAGECOLOR 255 255 255
> UNITS METERS
> STATUS ON
> CONFIG "GDAL_DRIVER_PATH" "C:/ms4w/gdalplugins"
>
> WEB
>       IMAGEPATH "c:\ms4w\Apache\htdocs\raster\tmp\"
>       IMAGEURL "/raster/tmp/"
>       TEMPLATE "test_template.html"
> END
>
> LAYER
>         CONNECTIONTYPE OGR
>         CONNECTION "OCI:username/password at service_name"
>         DATA "RWG_TBS"
>         NAME "RWG_TBS"      
>         TYPE POLYGON
>         STATUS ON
>
>         CLASS
>             NAME "Flaeche"
>             STYLE
>                            OUTLINECOLOR 128 128 128
>                  COLOR 225 225 185
>             END
>         END
> END
> END
>
>
> The template I wrote therefor is very simple:
>
> <html>
>    <head>
>       <title>Erstes Beispiel zum UMN Mapserver</title>
>    </head>
>
>    <body>
>       Mapserver-Version auslesen:<br><br>[version]<br><br><br>
>       Karte einbetten:<br><br>
>       <img src="[img]"><br>
>
>    </body>
> </html>
>
> And I tried to start mapping by writing the following in my browser:
>
> http://localhost/cgi-bin/mapserv.exe?map=c:/ms4w/Apache/htdocs/raster/test_o
> s_ogr.map&layers=all&
>
>
> The result was, that mapserver brought the error-message:
>
> "mapserv(): Web application error. No template provided. "
>
> Then I tested some other mapserver-test-projects, for whom I know that
> they
> have worked properly on my computer before the mentioned .dll swapping for
> OGR-OCI support. The result was the same:
>
> "mapserv(): Web application error. No template provided. "
>
>
> So I have three questions:
>
> How should mapserver know where the database is located without giving him
> any information about the host-address and the port-number. Where can I
> provide this information for the mapserver. In the case of ogrinfo I did
> this by writing "OCI:username/password at host:port/service_name". In the
> .mpa-file example in the "Vector-Data-Reference-Guide" they say under
> CONECTION you should type "OCI:username/password at service_name". Where is
> the
> information about the location of the database?
>
> Second questions is: Is anything wrong with my .map-file, html-template or
> the starting-command in the web-browser?
>
> Third: And why do the other mapserver projects, I tested before .dll
> swapping (for OGR-COI support), work anymore. Why do I always get the
> error-message "mapserv(): Web application error. No template provided."
> although I changed nothing on the .map-files, the template nor the
> command.
>
> I would be very pleased and hayppy and thankful if anybody would help me
> on
> my problem. This would really be very nice. Thank you so much for your
> endeavors.
>
> Regards
>
> Daniel
>
>
> --
>
>
> Der GMX SmartSurfer hilft bis zu 70% Ihrer Onlinekosten zu sparen!
> Ideal für Modem und ISDN: http://www.gmx.net/de/go/smartsurfer
>
>
>
> --
> No virus found in this incoming message.
> Checked by AVG Free Edition.
> Version: 7.1.394 / Virus Database: 268.8.3/361 - Release Date: 6/11/2006
>

--

"Feel free" - 10 GB Mailbox, 100 FreeSMS/Monat ...
Jetzt GMX TopMail testen: http://www.gmx.net/de/go/topmail