[mapserver-users] Mapserver's configuration - Support Oracle Spatial
Hello! I installed the MapServer 5.0.2 (in Debian) with support for Oracle Spatial (--with-oraclespatial=$ORACLE_HOME). However, it does not work yet. Errors are appearing in the logfile: [Tue May 4 11:47:45 2010].697128 msDrawMap(): Image handling error. Failed to draw layer named 'mapa_base'. [Tue May 4 11:47:45 2010].700221 msOracleSpatialLayerClose(): OracleSpatial error. OracleSpatial is not supported --- MapServer version 5.0.2 OUTPUT=GIF OUTPUT=PNG OUTPUT=JPEG OUTPUT=WBMP OUTPUT=SVG SUPPORTS=PROJ SUPPORTS=FREETYPE SUPPORTS=WMS_SERVER SUPPORTS=WMS_CLIENT SUPPORTS=WFS_SERVER SUPPORTS=WCS_SERVER SUPPORTS=THREADS SUPPORTS=GEOS INPUT=EPPL7 INPUT=ORACLESPATIAL INPUT=OGR INPUT=GDAL INPUT=SHAPEFILE --- It worked on Windows! Any idea...? NOTE: MapServer did not find the files libnnz10.so and libclntsh.so.10.1, so I created symbolic links to files in the folder $ORACLE_HOME/lib. Is this a problem? Thanks! -- Daiane Fraga ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
[mapserver-users] Query functions with Oracle Spatial
Mike, I'm using version 5.0.2. This version is the one that works in the application I'm using (incompatibilities...). But if this is the problem, so I at least know what direction to take. This explains why the tables that do not contain the field SE_ANNO_CAD_DATA have no trouble. Thank you for your help! Note: Sorry for my errors in the English ... I am new in this language... -- Daiane ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
[mapserver-users] Query functions with Oracle Spatial
Hello! I tried to execute a query function through an interface. Appeared in the logfile: [Mon Apr 05 11:09:19 2010] msOracleSpatialLayerGetShape .621000 (): OracleSpatial error. Error parsing OracleSpatial DATA is variable query. To execute query functions you need to define one unique column [USING UNIQUE # column] I added the ID column, and now appears in the logfile: [Mon Apr 05 11:11:47 2010] .358000 msOracleSpatialLayerGetShape (): OracleSpatial error. Error: ORA-00932: inconsistent datatypes: expected %s returned %s. Query statement: SELECT ID, NBLOCK, SECTOR, BLOCK, ORIGIN, TYPE, NAME, SUPERCOURT, COURTS, OBSERVATION, AREA, REASON, DATA, REGISTRATION, SE_ANNO_CAD_DATA, SHAPE FROM LOTS WHERE ID = 43,192. Check your statement date. What can it be? It worked in some cases. The columns are apparently right... There may be some incompatibility factor? Thanks! -- Daiane ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
[mapserver-users] ANGLE [attribute]
Thanks Daniel! I'm trying to get the database an angle to the text of a layer of type 'annotation', but is not working. The LABLEITEM (database) works, but not the angle. -- Daiane Daiane Azevedo de Fraga wrote: * Hello everyone! ** ** I wonder if ANGLE accepts an attribute that comes from a table in a ** database, eg Oracle Spatial? Either he accepts only one attribute of a DBF? ** * Yes, that should work for all connection types (but I didn't test oracle spatial specifically myself). Daniel -- Daniel Morissette http://www.mapgears.com/ ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
[mapserver-users] Re: ANGLE [attribute]
That's a consolation! ;) Thanks for the info! Can be a detail... If I find out what's happening, I will publish here! Thank you! -- Daiane ANGLE does work with Oracle Spatial. Mike -- Michael Smith RSGIS Center US Army Corps of Engineers On 3/30/10 7:56 PM, Daniel Morissette dmorissette at mapgears.com http://lists.osgeo.org/mailman/listinfo/mapserver-users wrote: * Daiane Azevedo de Fraga wrote: ** Hello everyone! ** ** I wonder if ANGLE accepts an attribute that comes from a table in a ** database, eg Oracle Spatial? Either he accepts only one attribute of a DBF? ** ** ** Yes, that should work for all connection types (but I didn't test oracle ** spatial specifically myself). ** ** Daniel * ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] ANGLE [attribute]
Exactly! Thank you very much!! I was using a TrueType font (Arial), but the software that I use as the interface was changing to Bitmap, because I was not stating explicitly that it was TrueType. Another detail: using TrueType, it should be explicit FONT attribute. Thanks, thanks, thanks David! -- Daiane 2010/3/31 Fawcett, David (MPCA) david.fawc...@state.mn.us Are you using TrueType fonts for your label? My memory could be bad, but I believe that you can only do label rotation with TrueType fonts, not with the default bitmap fonts. David. *From:* mapserver-users-boun...@lists.osgeo.org [mailto: mapserver-users-boun...@lists.osgeo.org] *On Behalf Of *Daiane Azevedo de Fraga *Sent:* Wednesday, March 31, 2010 8:07 AM *To:* mapserver-users@lists.osgeo.org *Subject:* [mapserver-users] ANGLE [attribute] Thanks Daniel! I'm trying to get the database an angle to the text of a layer of type 'annotation', but is not working. The LABLEITEM (database) works, but not the angle. -- Daiane Daiane Azevedo de Fraga wrote: * Hello everyone! ** ** I wonder if ANGLE accepts an attribute that comes from a table in a * * * * database, eg Oracle Spatial? Either he accepts only one attribute of a DBF? ** * Yes, that should work for all connection types (but I didn't test oracle spatial specifically myself). Daniel -- Daniel Morissette http://www.mapgears.com/ ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
[mapserver-users] ANGLE [attribute]
Hello everyone! I wonder if ANGLE accepts an attribute that comes from a table in a database, eg Oracle Spatial? Either he accepts only one attribute of a DBF? Thanks! -- Daiane ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users