[mapserver-users] oracle8.1.7 and mapserver

[Yu-Hsin Chen]

Nida:

MapServer's connection to Oracle is taken care of by the underlying SQLNet.  Judging from you did not get any error message I think you're connected to Oracle OK.

How about try to stick the following in your map file in the CLASS section:

      SYMBOL 4
      SIZE 3

right between your NAME and COLOR lines.  Of course you need to have a symbol file and 4 need to be defined.

Yu-Hsin


-----Original Message-----
From:	nida Khan [mailto:nida at webstar.co.uk]
Sent:	Fri 11/15/2002 12:19 PM
To:	Yu-Hsin Chen; mapserver-users at lists.gis.umn.edu
Cc:	
Subject:	Re: [mapserver-users] oracle8.1.7 and mapserver

Hi Again,

my counties table does have a sdo_geometry data type
here is desc of my table
SQL> desc counties
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 GEOM                                               MDSYS.SDO_GEOMETRY
 COUNTY                                             VARCHAR2(31)
 FIPSSTCO                                           VARCHAR2(5)
 STATE                                              VARCHAR2(30)
 STATE_ABRV                                         VARCHAR2(2)
 FIPSST                                             VARCHAR2(2)
 LANDSQMI                                           NUMBER
 TOTPOP                                             NUMBER
 POPPSQMI                                           NUMBER

I am wondering how mapserver knows where the database resides? 
Where do I define my database connection parameters??
IS there any quick test to find out if mapserver is looking into right database?
My database is on remote machine and I'm running mapserver from my machine...
I also have oracle client on my machine talking to same database.

I heartly appreciate your help!
Kind Regards
Nida.

  ----- Original Message ----- 
  From: Yu-Hsin Chen 
  To: nida Khan ; mapserver-users at lists.gis.umn.edu 
  Sent: Friday, November 15, 2002 5:15 PM
  Subject: RE: [mapserver-users] oracle8.1.7 and mapserver


  Nida:

  Judging from your 'counties table with a column geom' it doesn't appear to me you're using Oracle Spacial option.  You will need to have that option to work with MapServer.  Is your 'geom' column of data type SDO_GEOMETRY?

  You have to make sure Oracle Spacial option is in the database.  By default, when spacial option is installed you'll have an MDSYS user id and schema associated with that user.  If you don't see that, you'll have to install it first.  You should have an 'md' directory under $ORACLE_HOME.  Under md there is an admin directory which contains all installation scripts.

  Your map file looks OK if your counties is a table contain geom column which is of SDO_GEOMETRY data type.

  Yu-Hsin
    -----Original Message-----
    From: nida Khan [mailto:nida at webstar.co.uk]
    Sent: Friday, November 15, 2002 9:48 AM
    To: Yu-Hsin Chen; mapserver-users at lists.gis.umn.edu
    Subject: Re: [mapserver-users] oracle8.1.7 and mapserver


    I gave wrong example! :(

    here is the right example
    layer defination
    LAYER
      NAME counties
      TYPE polygon
      STATUS default
      MAXSCALE 1000000
      CONNECTIONTYPE oraclespatial
      CONNECTION 'scott/tiger at PHAR'
      DATA "GEOM from counties"
      CLASS
        NAME 'county'
        COLOR 220 224 230
        OUTLINECOLOR 0 0 0
      END
     END

    where I have counties table with a column geom

    very anxious!
    Regards
    Nida.

      ----- Original Message ----- 
      From: Yu-Hsin Chen 
      To: nida Khan ; mapserver-users at lists.gis.umn.edu 
      Sent: Friday, November 15, 2002 1:34 PM
      Subject: RE: [mapserver-users] oracle8.1.7 and mapserver


      Nida:

      You need to compile MapServer with oraclespacial.

      Your Oracle RDBMS needs to have Spacial option loaded.  Hopefully you've already got this part, it is a good learning curve if you havn't.

      What web server are you using?  You might need to modify the configuration a little.

      Once you have all the correct environment and settings it WILL work.  I'm running MapServer on a Mandrake Linux server accessing Oracle 8.0.5 data on a UnixWare server through CGI.

      Yu-Hsin
        -----Original Message-----
        From: nida Khan [mailto:nida at webstar.co.uk]
        Sent: Friday, November 15, 2002 6:29 AM
        To: mapserver-users at lists.gis.umn.edu
        Subject: [mapserver-users] oracle8.1.7 and mapserver


        Hi Everyone,

        Is there anyway to connect to Oracle 8.1.7 database on Solaris via Mapserver?
        I've compiled Mapserver with Postgress, but have no idea how to do it for Oracle now!

        I would really appreciate if anyone can guide me to right documentation or just give me some codes!!!!

        Looking forward for your replies

        Regards
        Nida.