Update, doesn't work.................................................................. Notice the identification of the object in the post request to Geoserver: ..... Notice the where condition in the sql statement UPDATE "PARKER"."v_greg_linier" SET "hoejde" = 9.88 WHERE 0 = 1 Geoserver log for update transaction (set a field called "hoejde" to a value of: 9.88 in layer v_greg_linier o 2019-03-29 13:28:07,391 INFO [org.geoserver.filters] - 10.10.1.51 "POST /geoserver/wfs" "" "" "text/xml" request-size: 959 body: Greg-Odense-Parker-Kursus:hoejde9.88 2019-03-29 13:28:07,391 DEBUG [org.geoserver.security.IncludeQueryStringAntPathRequestMatcher] - Checking match of request : 'Path: /wfs, QueryString: null'; against '/web/**' 2019-03-29 13:28:07,391 DEBUG [org.geoserver.security.IncludeQueryStringAntPathRequestMatcher] - Checking match of request : 'Path: /wfs, QueryString: null'; against '/gwc/rest/web/**' 2019-03-29 13:28:07,391 DEBUG [org.geoserver.security.IncludeQueryStringAntPathRequestMatcher] - Checking match of request : 'Path: /wfs, QueryString: null'; against '/' 2019-03-29 13:28:07,391 DEBUG [org.geoserver.security.IncludeQueryStringAntPathRequestMatcher] - Checking match of request : 'Path: /wfs, QueryString: null'; against '/j_spring_security_check' 2019-03-29 13:28:07,391 DEBUG [org.geoserver.security.IncludeQueryStringAntPathRequestMatcher] - Checking match of request : 'Path: /wfs, QueryString: null'; against '/j_spring_security_check/' 2019-03-29 13:28:07,391 DEBUG [org.geoserver.security.IncludeQueryStringAntPathRequestMatcher] - Checking match of request : 'Path: /wfs, QueryString: null'; against '/j_spring_security_logout' 2019-03-29 13:28:07,391 DEBUG [org.geoserver.security.IncludeQueryStringAntPathRequestMatcher] - Checking match of request : 'Path: /wfs, QueryString: null'; against '/j_spring_security_logout/' 2019-03-29 13:28:07,391 DEBUG [org.geoserver.security.IncludeQueryStringAntPathRequestMatcher] - Checking match of request : 'Path: /wfs, QueryString: null'; against '/rest/**' 2019-03-29 13:28:07,391 DEBUG [org.geoserver.security.IncludeQueryStringAntPathRequestMatcher] - Checking match of request : 'Path: /wfs, QueryString: null'; against '/gwc/rest/**' 2019-03-29 13:28:07,391 DEBUG [org.geoserver.security.IncludeQueryStringAntPathRequestMatcher] - Checking match of request : 'Path: /wfs, QueryString: null'; against '/**' 2019-03-29 13:28:07,391 DEBUG [org.geoserver.security.IncludeQueryStringAntPathRequestMatcher] - Request matched by universal pattern '/**' 2019-03-29 13:28:07,391 DEBUG [org.geoserver.security.IncludeQueryStringAntPathRequestMatcher] - Matched Path: /wfs, QueryString: null with /** 2019-03-29 13:28:07,391 DEBUG [org.geoserver.security] - AuthenticationCache found an entry for basic, OdenseKommune:4464f1565c67b38e5165d33c00c02b89 2019-03-29 13:28:07,391 DEBUG [org.geoserver.gwc.controller.GwcWmtsRestUrlHandlerMapping] - Looking up handler method for path /wfs 2019-03-29 13:28:07,391 DEBUG [org.geoserver.gwc.controller.GwcWmtsRestUrlHandlerMapping] - Did not find handler method for [/wfs] 2019-03-29 13:28:07,391 TRACE [org.geoserver.ows.OWSHandlerMapping] - No handler mapping found for [/wfs] 2019-03-29 13:28:07,391 TRACE [org.geoserver.ows.OWSHandlerMapping] - No handler mapping found for [/wfs] 2019-03-29 13:28:07,391 TRACE [org.geoserver.ows.OWSHandlerMapping] - No handler mapping found for [/wfs] 2019-03-29 13:28:07,391 TRACE [org.geoserver.ows.OWSHandlerMapping] - No handler mapping found for [/wfs] 2019-03-29 13:28:07,391 DEBUG [org.geoserver.ows.OWSHandlerMapping] - Mapping [/wfs] to HandlerExecutionChain with handler [org.geoserver.ows.Dispatcher@1aeed65b] and 1 interceptor 2019-03-29 13:28:07,407 DEBUG [org.vfny.geoserver.requests] - First 4 bytes of XML doc are : 3C ('<') 54 ('T') 72 ('r') 61 ('a') 2019-03-29 13:28:07,407 DEBUG [org.vfny.geoserver.requests] - Charset detection phase 1. Inferred encoding: UTF-8 2019-03-29 13:28:07,407 DEBUG [org.vfny.geoserver.requests] - Invalid(?) XML declaration: Greg-Odense-Parker-Kursus:hoejde9.88 2019-03-29 13:28:07,422 INFO [org.geoserver.wfs] - Request: getServiceInfo 2019-03-29 13:28:07,438 DEBUG [org.geoserver.wfs.xml] - Assuming hostname service-ok.lifa.dk does not refer to self. If this is wrong may lead to deadlock. 2019-03-29 13:28:07,438 INFO [org.geoserver.filters] - 10.10.1.51 "GET /geoserver/Greg-Odense-Parker-Kursus/wfs?servicename=Greg-Odense-Parker-Kursus&SERVICE=WFS&REQUEST=DescribeFeatureType&VERSION=1.0.0&TYPENAME=Greg-Odense-Parker-Kursus:v_greg_linier" "" "" "" 2019-03-29 13:28:07,438 DEBUG [org.geoserver.security.IncludeQueryStringAntPathRequestMatcher] - Checking match of request : 'Path: /greg-odense-parker-kursus/wfs, QueryString: servicename=Greg-Odense-Parker-Kursus&SERVICE=WFS&REQUEST=DescribeFeatureType&VERSION=1.0.0&TYPENAME=Greg-Odense-Parker-Kursus:v_greg_linier'; against '/web/**' 2019-03-29 13:28:07,438 DEBUG [org.geoserver.security.IncludeQueryStringAntPathRequestMatcher] - Checking match of request : 'Path: /greg-odense-parker-kursus/wfs, QueryString: servicename=Greg-Odense-Parker-Kursus&SERVICE=WFS&REQUEST=DescribeFeatureType&VERSION=1.0.0&TYPENAME=Greg-Odense-Parker-Kursus:v_greg_linier'; against '/gwc/rest/web/**' 2019-03-29 13:28:07,438 DEBUG [org.geoserver.security.IncludeQueryStringAntPathRequestMatcher] - Checking match of request : 'Path: /greg-odense-parker-kursus/wfs, QueryString: servicename=Greg-Odense-Parker-Kursus&SERVICE=WFS&REQUEST=DescribeFeatureType&VERSION=1.0.0&TYPENAME=Greg-Odense-Parker-Kursus:v_greg_linier'; against '/' 2019-03-29 13:28:07,438 DEBUG [org.geoserver.security.IncludeQueryStringAntPathRequestMatcher] - Checking match of request : 'Path: /greg-odense-parker-kursus/wfs, QueryString: servicename=Greg-Odense-Parker-Kursus&SERVICE=WFS&REQUEST=DescribeFeatureType&VERSION=1.0.0&TYPENAME=Greg-Odense-Parker-Kursus:v_greg_linier'; against '/j_spring_security_check' 2019-03-29 13:28:07,438 DEBUG [org.geoserver.security.IncludeQueryStringAntPathRequestMatcher] - Checking match of request : 'Path: /greg-odense-parker-kursus/wfs, QueryString: servicename=Greg-Odense-Parker-Kursus&SERVICE=WFS&REQUEST=DescribeFeatureType&VERSION=1.0.0&TYPENAME=Greg-Odense-Parker-Kursus:v_greg_linier'; against '/j_spring_security_check/' 2019-03-29 13:28:07,438 DEBUG [org.geoserver.security.IncludeQueryStringAntPathRequestMatcher] - Checking match of request : 'Path: /greg-odense-parker-kursus/wfs, QueryString: servicename=Greg-Odense-Parker-Kursus&SERVICE=WFS&REQUEST=DescribeFeatureType&VERSION=1.0.0&TYPENAME=Greg-Odense-Parker-Kursus:v_greg_linier'; against '/j_spring_security_logout' 2019-03-29 13:28:07,438 DEBUG [org.geoserver.security.IncludeQueryStringAntPathRequestMatcher] - Checking match of request : 'Path: /greg-odense-parker-kursus/wfs, QueryString: servicename=Greg-Odense-Parker-Kursus&SERVICE=WFS&REQUEST=DescribeFeatureType&VERSION=1.0.0&TYPENAME=Greg-Odense-Parker-Kursus:v_greg_linier'; against '/j_spring_security_logout/' 2019-03-29 13:28:07,438 DEBUG [org.geoserver.security.IncludeQueryStringAntPathRequestMatcher] - Checking match of request : 'Path: /greg-odense-parker-kursus/wfs, QueryString: servicename=Greg-Odense-Parker-Kursus&SERVICE=WFS&REQUEST=DescribeFeatureType&VERSION=1.0.0&TYPENAME=Greg-Odense-Parker-Kursus:v_greg_linier'; against '/rest/**' 2019-03-29 13:28:07,438 DEBUG [org.geoserver.security.IncludeQueryStringAntPathRequestMatcher] - Checking match of request : 'Path: /greg-odense-parker-kursus/wfs, QueryString: servicename=Greg-Odense-Parker-Kursus&SERVICE=WFS&REQUEST=DescribeFeatureType&VERSION=1.0.0&TYPENAME=Greg-Odense-Parker-Kursus:v_greg_linier'; against '/gwc/rest/**' 2019-03-29 13:28:07,438 DEBUG [org.geoserver.security.IncludeQueryStringAntPathRequestMatcher] - Checking match of request : 'Path: /greg-odense-parker-kursus/wfs, QueryString: servicename=Greg-Odense-Parker-Kursus&SERVICE=WFS&REQUEST=DescribeFeatureType&VERSION=1.0.0&TYPENAME=Greg-Odense-Parker-Kursus:v_greg_linier'; against '/**' 2019-03-29 13:28:07,438 DEBUG [org.geoserver.security.IncludeQueryStringAntPathRequestMatcher] - Request matched by universal pattern '/**' 2019-03-29 13:28:07,438 DEBUG [org.geoserver.security.IncludeQueryStringAntPathRequestMatcher] - Matched Path: /greg-odense-parker-kursus/wfs, QueryString: servicename=Greg-Odense-Parker-Kursus&SERVICE=WFS&REQUEST=DescribeFeatureType&VERSION=1.0.0&TYPENAME=Greg-Odense-Parker-Kursus:v_greg_linier with /** 2019-03-29 13:28:07,438 DEBUG [org.geoserver.security] - AuthenticationCache found an entry for basic, OdenseKommune:4464f1565c67b38e5165d33c00c02b89 2019-03-29 13:28:07,438 DEBUG [org.geoserver.gwc.controller.GwcWmtsRestUrlHandlerMapping] - Looking up handler method for path /Greg-Odense-Parker-Kursus/wfs 2019-03-29 13:28:07,438 DEBUG [org.geoserver.gwc.controller.GwcWmtsRestUrlHandlerMapping] - Did not find handler method for [/Greg-Odense-Parker-Kursus/wfs] 2019-03-29 13:28:07,438 TRACE [org.geoserver.ows.OWSHandlerMapping] - No handler mapping found for [/Greg-Odense-Parker-Kursus/wfs] 2019-03-29 13:28:07,438 TRACE [org.geoserver.ows.OWSHandlerMapping] - No handler mapping found for [/Greg-Odense-Parker-Kursus/wfs] 2019-03-29 13:28:07,438 TRACE [org.geoserver.ows.OWSHandlerMapping] - No handler mapping found for [/Greg-Odense-Parker-Kursus/wfs] 2019-03-29 13:28:07,438 TRACE [org.geoserver.ows.OWSHandlerMapping] - No handler mapping found for [/Greg-Odense-Parker-Kursus/wfs] 2019-03-29 13:28:07,438 DEBUG [org.geoserver.ows.OWSHandlerMapping] - Mapping [/Greg-Odense-Parker-Kursus/wfs] to HandlerExecutionChain with handler [org.geoserver.ows.Dispatcher@1aeed65b] and 1 interceptor 2019-03-29 13:28:07,438 DEBUG [org.geoserver.config.impl] - Could not locate service of type interface org.geoserver.wfs.WFSInfo in workspace WorkspaceInfoImpl[Greg-Odense-Parker-Kursus], available services were [WMTSInfoImpl[WMTS], WCSInfoImpl[WCS], WFSInfoImpl[WFS], WMSInfoImpl[WMS], WPSInfoImpl[WPS]] 2019-03-29 13:28:07,438 INFO [org.geoserver.wfs] - Request: getServiceInfo 2019-03-29 13:28:07,438 INFO [org.geoserver.flow] - Control-flow inactive, there are no configured rules 2019-03-29 13:28:07,438 DEBUG [org.geoserver.config.impl] - Could not locate service of type interface org.geoserver.wfs.WFSInfo in workspace WorkspaceInfoImpl[Greg-Odense-Parker-Kursus], available services were [WMTSInfoImpl[WMTS], WCSInfoImpl[WCS], WFSInfoImpl[WFS], WMSInfoImpl[WMS], WPSInfoImpl[WPS]] 2019-03-29 13:28:07,438 INFO [org.geoserver.wfs] - Request: describeFeatureType service = WFS version = 1.0.0 baseUrl = http://geoserver001.lifa.dk:8080/geoserver/ typeName[0] = {Greg-Odense-Parker-Kursus}v_greg_linier outputFormat = XMLSCHEMA 2019-03-29 13:28:07,438 DEBUG [org.geoserver.security.filter.GeoServerSecurityContextPersistenceFilter$1] - SecurityContextHolder now cleared, as request processing completed 2019-03-29 13:28:07,438 INFO [org.geoserver.filters] - 10.10.1.51 "GET /geoserver/Greg-Odense-Parker-Kursus/wfs?servicename=Greg-Odense-Parker-Kursus&SERVICE=WFS&REQUEST=DescribeFeatureType&VERSION=1.0.0&TYPENAME=Greg-Odense-Parker-Kursus:v_greg_linier" took 0ms 2019-03-29 13:28:07,454 INFO [org.geoserver.flow] - Control-flow inactive, there are no configured rules 2019-03-29 13:28:07,454 DEBUG [org.geoserver.wfs] - Locating FeatureSource uri:'Greg-Odense-Parker-Kursus' name:'v_greg_linier' 2019-03-29 13:28:07,454 DEBUG [org.geoserver.wfs] - located FeatureType w/ typeRef 'DB-GIS_OK_Greg_Parker_Kursus:v_greg_linier' and elementName '{Greg-Odense-Parker-Kursus}v_greg_linier' 2019-03-29 13:28:07,454 DEBUG [org.geoserver.wfs] - Transaction Update:org.geoserver.wfs.request.Update$WFS11@29743818 2019-03-29 13:28:07,454 DEBUG [org.geoserver.wfs] - Preprocess to remember modification as a set of fids 2019-03-29 13:28:07,454 INFO [org.geoserver.gwc] - DataStoreChange: {Greg-Odense-Parker-Kursus}v_greg_linier PreUpdate 2019-03-29 13:28:07,469 INFO [org.geoserver.wfs] - Request: transaction service = WFS version = 1.0.0 baseUrl = http://geoserver001.lifa.dk:8080/geoserver/ group[0] = wfs:update=net.opengis.wfs.impl.UpdateElementTypeImpl@2dbccefe (filter: [ v_greg_linier.null ], handle: null, inputFormat: , srsName: null, typeName: {Greg-Odense-Parker-Kursus}v_greg_linier) update[0]: property[0]: name = {Greg-Odense-Parker-Kursus}hoejde value = 9.88 filter = [ v_greg_linier.null ] inputFormat = x-application/gml:3 typeName = {Greg-Odense-Parker-Kursus}v_greg_linier releaseAction = ALL 2019-03-29 13:28:07,469 DEBUG [org.geoserver.security.filter.GeoServerSecurityContextPersistenceFilter$1] - SecurityContextHolder now cleared, as request processing completed 2019-03-29 13:28:07,469 INFO [org.geoserver.filters] - 10.10.1.51 "POST /geoserver/wfs" took 78ms SQL Server profiler for same transaction ========================================= 2019-03-29 13:28:07,457 UPDATE "PARKER"."v_greg_linier" SET "hoejde" = 9.88 WHERE 0 = 1 2019-03-29 13:28:07,470 IF @@TRANCOUNT > 0 COMMIT TRAN 2019-03-29 13:28:07,473 IF @@TRANCOUNT > 0 ROLLBACK TRAN 2019-03-29 13:28:07,473 IF @@TRANCOUNT > 0 COMMIT TRAN set implicit_transactions off A working update , set field "hoejde" to: 6 in layer v_greg_flader ................................................................. Notice the id in the post request to geoserver: ..... Notice the corresponding sql statement in sqlserver UPDATE "PARKER"."v_greg_flader" SET "hoejde" = 6 WHERE ("ID" = '7399') Geoserver log for update transaction (set field hoejde til value 6 in v_greg_flader 2019-03-31 15:40:23,136 INFO [org.geoserver.filters] - 10.10.1.51 "POST /geoserver/wfs" "" "" "text/xml" request-size: 956 body: Greg-Odense-Parker-Kursus:hoejde6 2019-03-31 15:40:23,136 DEBUG [org.geoserver.security.IncludeQueryStringAntPathRequestMatcher] - Checking match of request : 'Path: /wfs, QueryString: null'; against '/web/**' 2019-03-31 15:40:23,136 DEBUG [org.geoserver.security.IncludeQueryStringAntPathRequestMatcher] - Checking match of request : 'Path: /wfs, QueryString: null'; against '/gwc/rest/web/**' 2019-03-31 15:40:23,136 DEBUG [org.geoserver.security.IncludeQueryStringAntPathRequestMatcher] - Checking match of request : 'Path: /wfs, QueryString: null'; against '/' 2019-03-31 15:40:23,136 DEBUG [org.geoserver.security.IncludeQueryStringAntPathRequestMatcher] - Checking match of request : 'Path: /wfs, QueryString: null'; against '/j_spring_security_check' 2019-03-31 15:40:23,136 DEBUG [org.geoserver.security.IncludeQueryStringAntPathRequestMatcher] - Checking match of request : 'Path: /wfs, QueryString: null'; against '/j_spring_security_check/' 2019-03-31 15:40:23,136 DEBUG [org.geoserver.security.IncludeQueryStringAntPathRequestMatcher] - Checking match of request : 'Path: /wfs, QueryString: null'; against '/j_spring_security_logout' 2019-03-31 15:40:23,136 DEBUG [org.geoserver.security.IncludeQueryStringAntPathRequestMatcher] - Checking match of request : 'Path: /wfs, QueryString: null'; against '/j_spring_security_logout/' 2019-03-31 15:40:23,136 DEBUG [org.geoserver.security.IncludeQueryStringAntPathRequestMatcher] - Checking match of request : 'Path: /wfs, QueryString: null'; against '/rest/**' 2019-03-31 15:40:23,136 DEBUG [org.geoserver.security.IncludeQueryStringAntPathRequestMatcher] - Checking match of request : 'Path: /wfs, QueryString: null'; against '/gwc/rest/**' 2019-03-31 15:40:23,136 DEBUG [org.geoserver.security.IncludeQueryStringAntPathRequestMatcher] - Checking match of request : 'Path: /wfs, QueryString: null'; against '/**' 2019-03-31 15:40:23,136 DEBUG [org.geoserver.security.IncludeQueryStringAntPathRequestMatcher] - Request matched by universal pattern '/**' 2019-03-31 15:40:23,136 DEBUG [org.geoserver.security.IncludeQueryStringAntPathRequestMatcher] - Matched Path: /wfs, QueryString: null with /** 2019-03-31 15:40:23,136 DEBUG [org.geoserver.security] - AuthenticationCache has no entry for basic, OdenseKommune:4464f1565c67b38e5165d33c00c02b89 2019-03-31 15:40:23,136 DEBUG [org.geoserver.security.rememberme.GeoServerTokenBasedRememberMeServices] - Did not send remember-me cookie (principal did not set parameter '_spring_security_remember_me') 2019-03-31 15:40:23,136 DEBUG [org.geoserver.security.rememberme.GeoServerTokenBasedRememberMeServices] - Remember-me login not requested. 2019-03-31 15:40:23,136 DEBUG [org.geoserver.security] - AuthenticationCache adding new entry for basic, OdenseKommune:4464f1565c67b38e5165d33c00c02b89 2019-03-31 15:40:23,136 DEBUG [org.geoserver.security] - Cache entries #: 0 2019-03-31 15:40:23,136 DEBUG [org.geoserver.security] - AuthenticationCache added new entry for basic, OdenseKommune:4464f1565c67b38e5165d33c00c02b89 2019-03-31 15:40:23,136 DEBUG [org.geoserver.security] - Cache entries #: 1 2019-03-31 15:40:23,136 DEBUG [org.geoserver.gwc.controller.GwcWmtsRestUrlHandlerMapping] - Looking up handler method for path /wfs 2019-03-31 15:40:23,136 DEBUG [org.geoserver.gwc.controller.GwcWmtsRestUrlHandlerMapping] - Did not find handler method for [/wfs] 2019-03-31 15:40:23,136 TRACE [org.geoserver.ows.OWSHandlerMapping] - No handler mapping found for [/wfs] 2019-03-31 15:40:23,136 TRACE [org.geoserver.ows.OWSHandlerMapping] - No handler mapping found for [/wfs] 2019-03-31 15:40:23,136 TRACE [org.geoserver.ows.OWSHandlerMapping] - No handler mapping found for [/wfs] 2019-03-31 15:40:23,136 TRACE [org.geoserver.ows.OWSHandlerMapping] - No handler mapping found for [/wfs] 2019-03-31 15:40:23,136 DEBUG [org.geoserver.ows.OWSHandlerMapping] - Mapping [/wfs] to HandlerExecutionChain with handler [org.geoserver.ows.Dispatcher@1aeed65b] and 1 interceptor 2019-03-31 15:40:23,136 DEBUG [org.vfny.geoserver.requests] - First 4 bytes of XML doc are : 3C ('<') 54 ('T') 72 ('r') 61 ('a') 2019-03-31 15:40:23,136 DEBUG [org.vfny.geoserver.requests] - Charset detection phase 1. Inferred encoding: UTF-8 2019-03-31 15:40:23,136 DEBUG [org.vfny.geoserver.requests] - Invalid(?) XML declaration: Greg-Odense-Parker-Kursus:hoejde6 2019-03-31 15:40:23,167 INFO [org.geoserver.wfs] - Request: getServiceInfo 2019-03-31 15:40:23,167 DEBUG [org.geoserver.wfs.xml] - Assuming hostname service-ok.lifa.dk does not refer to self. If this is wrong may lead to deadlock. 2019-03-31 15:40:23,183 INFO [org.geoserver.filters] - 10.10.1.51 "GET /geoserver/Greg-Odense-Parker-Kursus/wfs?servicename=Greg-Odense-Parker-Kursus&SERVICE=WFS&REQUEST=DescribeFeatureType&VERSION=1.0.0&TYPENAME=Greg-Odense-Parker-Kursus:v_greg_flader" "" "" "" 2019-03-31 15:40:23,183 DEBUG [org.geoserver.security.IncludeQueryStringAntPathRequestMatcher] - Checking match of request : 'Path: /greg-odense-parker-kursus/wfs, QueryString: servicename=Greg-Odense-Parker-Kursus&SERVICE=WFS&REQUEST=DescribeFeatureType&VERSION=1.0.0&TYPENAME=Greg-Odense-Parker-Kursus:v_greg_flader'; against '/web/**' 2019-03-31 15:40:23,183 DEBUG [org.geoserver.security.IncludeQueryStringAntPathRequestMatcher] - Checking match of request : 'Path: /greg-odense-parker-kursus/wfs, QueryString: servicename=Greg-Odense-Parker-Kursus&SERVICE=WFS&REQUEST=DescribeFeatureType&VERSION=1.0.0&TYPENAME=Greg-Odense-Parker-Kursus:v_greg_flader'; against '/gwc/rest/web/**' 2019-03-31 15:40:23,183 DEBUG [org.geoserver.security.IncludeQueryStringAntPathRequestMatcher] - Checking match of request : 'Path: /greg-odense-parker-kursus/wfs, QueryString: servicename=Greg-Odense-Parker-Kursus&SERVICE=WFS&REQUEST=DescribeFeatureType&VERSION=1.0.0&TYPENAME=Greg-Odense-Parker-Kursus:v_greg_flader'; against '/' 2019-03-31 15:40:23,183 DEBUG [org.geoserver.security.IncludeQueryStringAntPathRequestMatcher] - Checking match of request : 'Path: /greg-odense-parker-kursus/wfs, QueryString: servicename=Greg-Odense-Parker-Kursus&SERVICE=WFS&REQUEST=DescribeFeatureType&VERSION=1.0.0&TYPENAME=Greg-Odense-Parker-Kursus:v_greg_flader'; against '/j_spring_security_check' 2019-03-31 15:40:23,183 DEBUG [org.geoserver.security.IncludeQueryStringAntPathRequestMatcher] - Checking match of request : 'Path: /greg-odense-parker-kursus/wfs, QueryString: servicename=Greg-Odense-Parker-Kursus&SERVICE=WFS&REQUEST=DescribeFeatureType&VERSION=1.0.0&TYPENAME=Greg-Odense-Parker-Kursus:v_greg_flader'; against '/j_spring_security_check/' 2019-03-31 15:40:23,183 DEBUG [org.geoserver.security.IncludeQueryStringAntPathRequestMatcher] - Checking match of request : 'Path: /greg-odense-parker-kursus/wfs, QueryString: servicename=Greg-Odense-Parker-Kursus&SERVICE=WFS&REQUEST=DescribeFeatureType&VERSION=1.0.0&TYPENAME=Greg-Odense-Parker-Kursus:v_greg_flader'; against '/j_spring_security_logout' 2019-03-31 15:40:23,183 DEBUG [org.geoserver.security.IncludeQueryStringAntPathRequestMatcher] - Checking match of request : 'Path: /greg-odense-parker-kursus/wfs, QueryString: servicename=Greg-Odense-Parker-Kursus&SERVICE=WFS&REQUEST=DescribeFeatureType&VERSION=1.0.0&TYPENAME=Greg-Odense-Parker-Kursus:v_greg_flader'; against '/j_spring_security_logout/' 2019-03-31 15:40:23,183 DEBUG [org.geoserver.security.IncludeQueryStringAntPathRequestMatcher] - Checking match of request : 'Path: /greg-odense-parker-kursus/wfs, QueryString: servicename=Greg-Odense-Parker-Kursus&SERVICE=WFS&REQUEST=DescribeFeatureType&VERSION=1.0.0&TYPENAME=Greg-Odense-Parker-Kursus:v_greg_flader'; against '/rest/**' 2019-03-31 15:40:23,183 DEBUG [org.geoserver.security.IncludeQueryStringAntPathRequestMatcher] - Checking match of request : 'Path: /greg-odense-parker-kursus/wfs, QueryString: servicename=Greg-Odense-Parker-Kursus&SERVICE=WFS&REQUEST=DescribeFeatureType&VERSION=1.0.0&TYPENAME=Greg-Odense-Parker-Kursus:v_greg_flader'; against '/gwc/rest/**' 2019-03-31 15:40:23,183 DEBUG [org.geoserver.security.IncludeQueryStringAntPathRequestMatcher] - Checking match of request : 'Path: /greg-odense-parker-kursus/wfs, QueryString: servicename=Greg-Odense-Parker-Kursus&SERVICE=WFS&REQUEST=DescribeFeatureType&VERSION=1.0.0&TYPENAME=Greg-Odense-Parker-Kursus:v_greg_flader'; against '/**' 2019-03-31 15:40:23,183 DEBUG [org.geoserver.security.IncludeQueryStringAntPathRequestMatcher] - Request matched by universal pattern '/**' 2019-03-31 15:40:23,183 DEBUG [org.geoserver.security.IncludeQueryStringAntPathRequestMatcher] - Matched Path: /greg-odense-parker-kursus/wfs, QueryString: servicename=Greg-Odense-Parker-Kursus&SERVICE=WFS&REQUEST=DescribeFeatureType&VERSION=1.0.0&TYPENAME=Greg-Odense-Parker-Kursus:v_greg_flader with /** 2019-03-31 15:40:23,183 DEBUG [org.geoserver.security] - AuthenticationCache found an entry for basic, OdenseKommune:4464f1565c67b38e5165d33c00c02b89 2019-03-31 15:40:23,183 DEBUG [org.geoserver.gwc.controller.GwcWmtsRestUrlHandlerMapping] - Looking up handler method for path /Greg-Odense-Parker-Kursus/wfs 2019-03-31 15:40:23,183 DEBUG [org.geoserver.gwc.controller.GwcWmtsRestUrlHandlerMapping] - Did not find handler method for [/Greg-Odense-Parker-Kursus/wfs] 2019-03-31 15:40:23,183 TRACE [org.geoserver.ows.OWSHandlerMapping] - No handler mapping found for [/Greg-Odense-Parker-Kursus/wfs] 2019-03-31 15:40:23,183 TRACE [org.geoserver.ows.OWSHandlerMapping] - No handler mapping found for [/Greg-Odense-Parker-Kursus/wfs] 2019-03-31 15:40:23,183 TRACE [org.geoserver.ows.OWSHandlerMapping] - No handler mapping found for [/Greg-Odense-Parker-Kursus/wfs] 2019-03-31 15:40:23,183 TRACE [org.geoserver.ows.OWSHandlerMapping] - No handler mapping found for [/Greg-Odense-Parker-Kursus/wfs] 2019-03-31 15:40:23,183 DEBUG [org.geoserver.ows.OWSHandlerMapping] - Mapping [/Greg-Odense-Parker-Kursus/wfs] to HandlerExecutionChain with handler [org.geoserver.ows.Dispatcher@1aeed65b] and 1 interceptor 2019-03-31 15:40:23,183 DEBUG [org.geoserver.config.impl] - Could not locate service of type interface org.geoserver.wfs.WFSInfo in workspace WorkspaceInfoImpl[Greg-Odense-Parker-Kursus], available services were [WMTSInfoImpl[WMTS], WCSInfoImpl[WCS], WFSInfoImpl[WFS], WMSInfoImpl[WMS], WPSInfoImpl[WPS]] 2019-03-31 15:40:23,183 INFO [org.geoserver.wfs] - Request: getServiceInfo 2019-03-31 15:40:23,183 INFO [org.geoserver.flow] - Control-flow inactive, there are no configured rules 2019-03-31 15:40:23,183 DEBUG [org.geoserver.config.impl] - Could not locate service of type interface org.geoserver.wfs.WFSInfo in workspace WorkspaceInfoImpl[Greg-Odense-Parker-Kursus], available services were [WMTSInfoImpl[WMTS], WCSInfoImpl[WCS], WFSInfoImpl[WFS], WMSInfoImpl[WMS], WPSInfoImpl[WPS]] 2019-03-31 15:40:23,183 INFO [org.geoserver.wfs] - Request: describeFeatureType service = WFS version = 1.0.0 baseUrl = http://geoserver001.lifa.dk:8080/geoserver/ typeName[0] = {Greg-Odense-Parker-Kursus}v_greg_flader outputFormat = XMLSCHEMA 2019-03-31 15:40:23,183 DEBUG [org.geoserver.security.filter.GeoServerSecurityContextPersistenceFilter$1] - SecurityContextHolder now cleared, as request processing completed 2019-03-31 15:40:23,183 INFO [org.geoserver.filters] - 10.10.1.51 "GET /geoserver/Greg-Odense-Parker-Kursus/wfs?servicename=Greg-Odense-Parker-Kursus&SERVICE=WFS&REQUEST=DescribeFeatureType&VERSION=1.0.0&TYPENAME=Greg-Odense-Parker-Kursus:v_greg_flader" took 0ms 2019-03-31 15:40:23,198 INFO [org.geoserver.flow] - Control-flow inactive, there are no configured rules 2019-03-31 15:40:23,198 DEBUG [org.geoserver.wfs] - Locating FeatureSource uri:'Greg-Odense-Parker-Kursus' name:'v_greg_flader' 2019-03-31 15:40:23,198 DEBUG [org.geoserver.wfs] - located FeatureType w/ typeRef 'DB-GIS_OK_Greg_Parker_Kursus:v_greg_flader' and elementName '{Greg-Odense-Parker-Kursus}v_greg_flader' 2019-03-31 15:40:23,198 DEBUG [org.geoserver.wfs] - Transaction Update:org.geoserver.wfs.request.Update$WFS11@43a679e7 2019-03-31 15:40:23,198 DEBUG [org.geoserver.wfs] - Preprocess to remember modification as a set of fids 2019-03-31 15:40:23,198 INFO [org.geoserver.gwc] - DataStoreChange: {Greg-Odense-Parker-Kursus}v_greg_flader PreUpdate 2019-03-31 15:40:23,276 DEBUG [org.geoserver.wfs] - Post process update for boundary update and featureValidation 2019-03-31 15:40:23,276 INFO [org.geoserver.gwc] - DataStoreChange: {Greg-Odense-Parker-Kursus}v_greg_flader PostUpdate 2019-03-31 15:40:23,276 INFO [org.geoserver.wfs] - Request: transaction service = WFS version = 1.0.0 baseUrl = http://geoserver001.lifa.dk:8080/geoserver/ group[0] = wfs:update=net.opengis.wfs.impl.UpdateElementTypeImpl@207a63ee (filter: [ v_greg_flader.7399 ], handle: null, inputFormat: , srsName: null, typeName: {Greg-Odense-Parker-Kursus}v_greg_flader) update[0]: property[0]: name = {Greg-Odense-Parker-Kursus}hoejde value = 6 filter = [ v_greg_flader.7399 ] inputFormat = x-application/gml:3 typeName = {Greg-Odense-Parker-Kursus}v_greg_flader releaseAction = ALL 2019-03-31 15:40:23,276 DEBUG [org.geoserver.security.filter.GeoServerSecurityContextPersistenceFilter$1] - SecurityContextHolder now cleared, as request processing completed 2019-03-31 15:40:23,276 INFO [org.geoserver.filters] - 10.10.1.51 "POST /geoserver/wfs" took 140ms SQL Server profiler for same transaction ========================================= select 1 go set implicit_transactions on go SELECT "ID","versions_id","objekt_id","systid_fra","systid_til","oprettet","cvr_kode","cvr_navn","bruger_id","bruger","oprindkode","oprindelse","statuskode","status","off_kode","offentlig","hovedelement_kode","hovedelement_tekst","element_kode","element_tekst","underelement_kode","underelement_tekst","underelement_url","sektionskode","sektionsnavn","udfoerer_entrep","kommunal_kontakt","kommunal_kontakt_info","anlaegsaar","klip_sider","hoejde","klip_flade","tilstand_kode","tilstand","litra","note","vejkode","vejnavn","link","areal","omkreds","element_pris","aktiv","geometri" as "geometri" FROM "PARKER"."v_greg_flader" WHERE ("ID" = '7399') go UPDATE "PARKER"."v_greg_flader" SET "hoejde" = 6 WHERE ("ID" = '7399') go SELECT "ID","versions_id","objekt_id","systid_fra","systid_til","oprettet","cvr_kode","cvr_navn","bruger_id","bruger","oprindkode","oprindelse","statuskode","status","off_kode","offentlig","hovedelement_kode","hovedelement_tekst","element_kode","element_tekst","underelement_kode","underelement_tekst","underelement_url","sektionskode","sektionsnavn","udfoerer_entrep","kommunal_kontakt","kommunal_kontakt_info","anlaegsaar","klip_sider","hoejde","klip_flade","tilstand_kode","tilstand","litra","note","vejkode","vejnavn","link","areal","omkreds","element_pris","aktiv","geometri" as "geometri" FROM "PARKER"."v_greg_flader" WHERE ("ID" = '7399') go IF @@TRANCOUNT > 0 COMMIT TRAN go IF @@TRANCOUNT > 0 ROLLBACK TRAN go IF @@TRANCOUNT > 0 COMMIT TRAN set implicit_transactions off go