Hi Tim, I had the same problem - even a few "timeouts" on the server side (I know, with IIS ...).
>From my experience, WFS worked fine with a few features, but it proved to be "more difficult" to use when there were to many of them due 1) to the size of the GML file returned and 2) to the time it takes to read all the information from Oracle. I found no solution to this problem ... ______________________________________________________ JAMES LÉVEILLÉ Service des systèmes de Mission Direction des technologies de l'information Ministère des Transports du Québec 5833, boul. Pierre-Bertrand, 2ième étage Québec (Québec) G2K 1K7 Téléphone: (418) 380-2005 poste 227 Télécopieur: (418) 644-6653 [EMAIL PROTECTED] -----Message d'origine----- De : Nolte, Tim [mailto:[EMAIL PROTECTED] Envoyé : 4 août 2008 14:23 À : Léveillé, James; [email protected] Objet : RE: RE : [mapserver-users] MapServer + Database + WFS James, Thanks for the info. After a bunch of trial and error I was able to finally able to get WFS working, and our WFS client actually having the objects. One problem that I did run into was with the size of the data. I had around 1800 or so features each with around 15 attributes of data. This proved to take like 20 minutes for the entire amount of data to load. I'm not sure if you have any suggestions with that one. The only thing I found was to break up the data into smaller chunks, while not the most ideal solution it at least helped to reduce some of the load time feel. - Tim ---- Timothy J Nolte - [EMAIL PROTECTED] Network Planning Engineer iPCS Wireless, Inc. 4717 Broadmoor Ave, Suite G Kentwood, MI 49512 Office: 616-656-5163 PCS: 616-706-2438 Fax: 616-554-6484 Web: www.ipcswirelessinc.com > -----Original Message----- > From: Léveillé, James [mailto:[EMAIL PROTECTED] > Sent: Monday, August 04, 2008 2:08 PM > To: Nolte, Tim; [email protected] > Subject: RE : [mapserver-users] MapServer + Database + WFS > > Hi Tim, > > If it's not too late (I'm coming back from vacation), here is a > working example with MapServer 5 (on Windows) and Oracle 10g. > I'm also using a custom projection. > > Hope it helps. > > > --- > MAP > > NAME "Prototype" > CONFIG PROJ_LIB "D:/mapserver5_orcl/ms4w/proj/nad" > > PROJECTION > "init=epsg:42105" > END > WEB > METADATA > "wfs_title" "Prototype" > "wfs_onlineresource" > "http://server_name/MapServer5_orcl/mapserv.exe?map=D:\project > \my_wfs_mapfil > e.map" > "wfs_srs" "EPSG:42105" # *** > Contrary to WMS, > I think that the OGC WFS specification doesn't allow a layer > (feature type) > to be advertized in more than one SRS. > "wfs_abstract" "My prototype ..." > "wfs_geometry_element_name" "MS_GEOMETRY" > END > END > STATUS ON > > EXTENT 30000 75000 1710000 2120000 # > Custom projection > # SHAPEPATH "D:/systemes/dds/donnees/" > UNITS METERS > > # MY LAYER > > LAYER > > NAME "layer name" > PROJECTION > "init=EPSG:42105" # Custom projection > END > METADATA > "wfs_title" "Layer Name" > "wfs_name" "Layer Name" > "wfs_abstract" "Layer Name" > "wfs_srs" "EPSG:42105" # Custom projection > > "wfs_geometry_element_name" "MS_GEOMETRY" > "wfs_version" "1.0.0" > "wfs_request_method" "GET" > "wfs_connectiontimeout" "600" > > "wfs_featureid" "ide_segmn_ferrv" > "gml_exclude_items" "all" > "gml_include_items" "ide_segmn_ferrv" > #,num_rtss,authr_respn,indct_sourc_ctq_mtq,topnm,clasf_res_camng" > END > STATUS ON > DUMP TRUE > > EXTENT 30000 75000 1700000 2120000 # > Custom projection > > CONNECTIONTYPE oraclespatial > CONNECTION "user/[EMAIL PROTECTED]" > PROCESSING "CLOSE_CONNECTION=DEFER" > DATA "geo_segmn_ferrv FROM > bgr_segmn_ferrv USING UNIQUE > ide_segmn_ferrv SRID 1557057 " > TYPE LINE > > END > > END > > > > > > > > > > > > ______________________________________________________ > JAMES LÉVEILLÉ > Service des systèmes de Mission > Direction des technologies de l'information > Ministère des Transports du Québec > 5833, boul. Pierre-Bertrand, 2ième étage > Québec (Québec) G2K 1K7 > Téléphone: (418) 380-2005 poste 227 > Télécopieur: (418) 644-6653 > [EMAIL PROTECTED] > > > > > -----Message d'origine----- > De : [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] De la part de Nolte, > Tim Envoyé : 30 juillet 2008 10:55 > À : [email protected] > Objet : [mapserver-users] MapServer + Database + WFS > > > Is no one out there using Oracle Spatial, or any other DB, with > MapServer and WFS? There is pretty much a huge lack of documentation > for serving WFS > from MapServer. It would be nice to know if what I'm > attempting is even > possible or not. Thanks if someone does actually respond. > > - Tim > > ---- > Timothy J Nolte - [EMAIL PROTECTED] > Network Planning Engineer > > iPCS Wireless, Inc. > 4717 Broadmoor Ave, Suite G > Kentwood, MI 49512 > > Office: 616-656-5163 > PCS: 616-706-2438 > Fax: 616-554-6484 > Web: www.ipcswirelessinc.com > _______________________________________________ > mapserver-users mailing list > [email protected] > http://lists.osgeo.org/mailman/listinfo/mapserver-users > > _______________________________________________ mapserver-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapserver-users
