[MAPSERVER-USERS] Query using template and WFS errorred on POSTGIS

G. Tiemens Gerben.Tiemens at grontmij.nl
Thu Oct 16 05:04:12 PDT 2008


Hello List,

I want to try to get certain features-attribute information back from my
postgis database via Mapserver.

I tried this in 2 ways:
Enabeling WFS in the mapfile and making a query layer.

Both requests generate errors on the Postgis Database and i can't discover
what is going wrong.

This is the error I get: 
DECLARE CURSOR can only be used in transaction blocks

When doing a WFS request, i get a bounding box (envelope), but no features
back
Error is in the logfile of the postgis.

When doing a Query (nquery)  i get the error in html back:
Content-type: text/html writeLog(): Unable to access file. hierzo.log
msPOSTGISLayerGetShape(): Query error. Error executing POSTGIS SQL statement
(in FETCH ALL): DECLARE mycursor2 BINARY CURSOR FOR SELECT
"gid"::text,"provincie"::text,"oid"::text,asbinary(force_collection(force_2d(the_geom)),'NDR')
from prov2007 WHERE OID = 1 -ERROR: DECLARE CURSOR can only be used in
transaction blocks More Help: msPOSTGISLayerRetrievePGVersion(): Query
error. Error executing POSTGIS statement
(msPOSTGISLayerRetrievePGVersion():select substring(version() from 12 for
(position('on' in version()) - 13)) msPOSTGISLayerRetrievePGVersion(): Query
error. Error executing POSTGIS statement
(msPOSTGISLayerRetrievePGVersion():select substring(version() from 12 for
(position('on' in version()) - 13)) msPOSTGISLayerRetrievePGVersion(): Query
error. Error executing POSTGIS statement
(msPOSTGISLayerRetrievePGVersion():select substring(version() from 12 for
(position('on' in version()) - 13)) msPOSTGISLayerRetrievePGVersion(): Query
error. Error executing POSTGIS statement
(msPOSTGISLayerRetrievePGVersion():select substring(version() from 12 for
(position('on' in version()) - 13)) msPOSTGISLayerRetrievePGVersion(): Query
error. Error executing POSTGIS statement
(msPOSTGISLayerRetrievePGVersion():select substring(version() from 12 for
(position('on' in version()) - 13)) 


Both queries are also done with shapefile data, and that works fine. I get
features back (wfs) or the template (nquery) is filled in correctly


Below the parts of my mapfile and templates.

Mapfile: 
LAYER     NAME 'pr2007'     TYPE POLYGON     CONNECTIONTYPE postgis    
CONNECTION 'host=127.0.0.1 user=***** dbname=*****'     DATA 'the_geom FROM
pr2007'     #DATA 'C:\Project\Downloads\OSM\Data\pr\pr2007'     PROCESSING
"CLOSE_CONNECTION=DEFER"  	METADATA       'ows_title' 'prov2007' 	 
"ows_abstract" "" 	  "ows_keywordlist" "" 	  "gml_featureid" "gid" ##
REQUIRED 	  "gml_include_items" "all"  ## Optional (serves all attributes
for layer) 	  "ows_srs" "EPSG:28992" 	 # "queryable" "true" 	 
"wfs_geometry_element_name" "the_geom" 	  "wfs_extent" "12500 380000 280000
550000"      END 	#DUMP TRUE     STATUS ON #DEFAULT     #opacity 100    
PROJECTION 		"init=epsg:28992"     END 	HEADER "imapheader.html" 	FOOTER
"imapfooter.html" 	CLASS 		COLOR 0 0 0  		TEMPLATE "bodytemplate.html" 		 
END   END


query template:
<area shape="poly" coords="[shpxy precision=0 proj=image]"
href="http://www.*****.nl/pr.hml?ID=[pr]>



Versions i use:
PostgreSQL + postgis 8.3
Mapserver:  MS4W :  5.2.0
Or FWtools:  5.3-dev

All on localhost, so no firewall/security issues whatsoever.


What is the possible mistake i make? Any possible plugins or settings wrong
in database?


Greetings and thanks for help.

Gerben



-- 
View this message in context: http://www.nabble.com/Query-using-template-and-WFS-errorred-on-POSTGIS-tp20012197p20012197.html
Sent from the Mapserver - User mailing list archive at Nabble.com.




More information about the MapServer-users mailing list