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