transactions-geoserver-sqlserver.txt

logfile from geoserver and sqlserver - Bo Thomsen, 2019-04-09 08:33 AM

Download (32.8 KB)

 
1

    
2

    
3
Update, doesn't work..................................................................
4

    
5
Notice the identification of the object in the post request to Geoserver:
6
.....<FeatureId xmlns="http://www.opengis.et/ogc" fid="v_greg_linier.null"/></Filter></Update></Transaction>
7

    
8

    
9
Notice the where condition in the sql statement
10
UPDATE "PARKER"."v_greg_linier" SET "hoejde" = 9.88  WHERE 0 = 1
11

    
12
Geoserver log for update transaction (set a field called "hoejde" to a value of: 9.88 in layer v_greg_linier
13
o
14
2019-03-29 13:28:07,391 INFO [org.geoserver.filters] - 10.10.1.51 "POST /geoserver/wfs" "" "" "text/xml"  request-size: 959 body: 
15
<Transaction xmlns="http://www.opengis.net/wfs" xmlns:Greg-Odense-Parker-Kursus="Greg-Odense-Parker-Kursus" xsi:schemaLocation="Greg-Odense-Parker-Kursus https://service-ok.lifa.dk/Authenticate.ashx?login=xxxx&amp;password=xxxx&amp;servicename=Greg-Odense-Parker-Kursus&amp;SERVICE=WFS&amp;REQUEST=DescribeFeatureType&amp;VERSION=1.0.0&amp;TYPENAME=Greg-Odense-Parker-Kursus:v_greg_linier" service="WFS" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" version="1.0.0" xmlns:gml="http://www.opengis.net/gml"><Update xmlns="http://www.opengis.net/wfs" typeName="Greg-Odense-Parker-Kursus:v_greg_linier"><Property xmlns="http://www.opengis.net/wfs"><Name xmlns="http://www.opengis.net/wfs">Greg-Odense-Parker-Kursus:hoejde</Name><Value xmlns="http://www.opengis.net/wfs">9.88</Value></Property><Filter xmlns="http://www.opengis.net/ogc"><FeatureId xmlns="http://www.opengis.et/ogc" fid="v_greg_linier.null"/></Filter></Update></Transaction>
16

    
17
2019-03-29 13:28:07,391 DEBUG [org.geoserver.security.IncludeQueryStringAntPathRequestMatcher] - Checking match of request : 'Path: /wfs, QueryString: null'; against '/web/**'
18
2019-03-29 13:28:07,391 DEBUG [org.geoserver.security.IncludeQueryStringAntPathRequestMatcher] - Checking match of request : 'Path: /wfs, QueryString: null'; against '/gwc/rest/web/**'
19
2019-03-29 13:28:07,391 DEBUG [org.geoserver.security.IncludeQueryStringAntPathRequestMatcher] - Checking match of request : 'Path: /wfs, QueryString: null'; against '/'
20
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'
21
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/'
22
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'
23
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/'
24
2019-03-29 13:28:07,391 DEBUG [org.geoserver.security.IncludeQueryStringAntPathRequestMatcher] - Checking match of request : 'Path: /wfs, QueryString: null'; against '/rest/**'
25
2019-03-29 13:28:07,391 DEBUG [org.geoserver.security.IncludeQueryStringAntPathRequestMatcher] - Checking match of request : 'Path: /wfs, QueryString: null'; against '/gwc/rest/**'
26
2019-03-29 13:28:07,391 DEBUG [org.geoserver.security.IncludeQueryStringAntPathRequestMatcher] - Checking match of request : 'Path: /wfs, QueryString: null'; against '/**'
27
2019-03-29 13:28:07,391 DEBUG [org.geoserver.security.IncludeQueryStringAntPathRequestMatcher] - Request matched by universal pattern '/**'
28
2019-03-29 13:28:07,391 DEBUG [org.geoserver.security.IncludeQueryStringAntPathRequestMatcher] - Matched Path: /wfs, QueryString: null with /**
29
2019-03-29 13:28:07,391 DEBUG [org.geoserver.security] - AuthenticationCache found an entry for basic, OdenseKommune:4464f1565c67b38e5165d33c00c02b89
30
2019-03-29 13:28:07,391 DEBUG [org.geoserver.gwc.controller.GwcWmtsRestUrlHandlerMapping] - Looking up handler method for path /wfs
31
2019-03-29 13:28:07,391 DEBUG [org.geoserver.gwc.controller.GwcWmtsRestUrlHandlerMapping] - Did not find handler method for [/wfs]
32
2019-03-29 13:28:07,391 TRACE [org.geoserver.ows.OWSHandlerMapping] - No handler mapping found for [/wfs]
33
2019-03-29 13:28:07,391 TRACE [org.geoserver.ows.OWSHandlerMapping] - No handler mapping found for [/wfs]
34
2019-03-29 13:28:07,391 TRACE [org.geoserver.ows.OWSHandlerMapping] - No handler mapping found for [/wfs]
35
2019-03-29 13:28:07,391 TRACE [org.geoserver.ows.OWSHandlerMapping] - No handler mapping found for [/wfs]
36
2019-03-29 13:28:07,391 DEBUG [org.geoserver.ows.OWSHandlerMapping] - Mapping [/wfs] to HandlerExecutionChain with handler [[email protected]] and 1 interceptor
37
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')
38
2019-03-29 13:28:07,407 DEBUG [org.vfny.geoserver.requests] - Charset detection phase 1. Inferred encoding: UTF-8
39
2019-03-29 13:28:07,407 DEBUG [org.vfny.geoserver.requests] - Invalid(?) XML declaration: <Trans.
40
2019-03-29 13:28:07,407 DEBUG [org.vfny.geoserver.requests] - Charset detection phase 2. Charset in XML declaration is `null`.
41
2019-03-29 13:28:07,407 DEBUG [org.vfny.geoserver.requests] - Trying to create reader basing on existing charset information: `UTF-8`.
42
2019-03-29 13:28:07,407 DEBUG [org.geoserver.ows] - Raw XML request: <Transaction xmlns="http://www.opengis.net/wfs" xmlns:Greg-Odense-Parker-Kursus="Greg-Odense-Parker-Kursus" xsi:schemaLocation="Greg-Odense-Parker-Kursus https://service-ok.lifa.dk/Authenticate.ashx?login=xxxx&amp;password=xxxx&amp;servicename=Greg-Odense-Parker-Kursus&amp;SERVICE=WFS&amp;REQUEST=DescribeFeatureType&amp;VERSION=1.0.0&amp;TYPENAME=Greg-Odense-Parker-Kursus:v_greg_linier" service="WFS" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" version="1.0.0" xmlns:gml="http://www.opengis.net/gml"><Update xmlns="http://www.opengis.net/wfs" typeName="Greg-Odense-Parker-Kursus:v_greg_linier"><Property xmlns="http://www.opengis.net/wfs"><Name xmlns="http://www.opengis.net/wfs">Greg-Odense-Parker-Kursus:hoejde</Name><Value xmlns="http://www.opengis.net/wfs">9.88</Value></Property><Filter xmlns="http://www.opengis.net/ogc"><FeatureId xmlns="http://www.opengis.net/ogc" fid="v_greg_linier.null"/></Filter></Update></Transaction>                                                                 
43
2019-03-29 13:28:07,422 INFO [org.geoserver.wfs] - 
44
Request: getServiceInfo
45
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.
46
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" "" "" "" 
47
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/**'
48
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/**'
49
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 '/'
50
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'
51
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/'
52
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'
53
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/'
54
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/**'
55
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/**'
56
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 '/**'
57
2019-03-29 13:28:07,438 DEBUG [org.geoserver.security.IncludeQueryStringAntPathRequestMatcher] - Request matched by universal pattern '/**'
58
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 /**
59
2019-03-29 13:28:07,438 DEBUG [org.geoserver.security] - AuthenticationCache found an entry for basic, OdenseKommune:4464f1565c67b38e5165d33c00c02b89
60
2019-03-29 13:28:07,438 DEBUG [org.geoserver.gwc.controller.GwcWmtsRestUrlHandlerMapping] - Looking up handler method for path /Greg-Odense-Parker-Kursus/wfs
61
2019-03-29 13:28:07,438 DEBUG [org.geoserver.gwc.controller.GwcWmtsRestUrlHandlerMapping] - Did not find handler method for [/Greg-Odense-Parker-Kursus/wfs]
62
2019-03-29 13:28:07,438 TRACE [org.geoserver.ows.OWSHandlerMapping] - No handler mapping found for [/Greg-Odense-Parker-Kursus/wfs]
63
2019-03-29 13:28:07,438 TRACE [org.geoserver.ows.OWSHandlerMapping] - No handler mapping found for [/Greg-Odense-Parker-Kursus/wfs]
64
2019-03-29 13:28:07,438 TRACE [org.geoserver.ows.OWSHandlerMapping] - No handler mapping found for [/Greg-Odense-Parker-Kursus/wfs]
65
2019-03-29 13:28:07,438 TRACE [org.geoserver.ows.OWSHandlerMapping] - No handler mapping found for [/Greg-Odense-Parker-Kursus/wfs]
66
2019-03-29 13:28:07,438 DEBUG [org.geoserver.ows.OWSHandlerMapping] - Mapping [/Greg-Odense-Parker-Kursus/wfs] to HandlerExecutionChain with handler [[email protected]] and 1 interceptor
67
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]]
68
2019-03-29 13:28:07,438 INFO [org.geoserver.wfs] - 
69
Request: getServiceInfo
70
2019-03-29 13:28:07,438 INFO [org.geoserver.flow] - Control-flow inactive, there are no configured rules
71
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]]
72
2019-03-29 13:28:07,438 INFO [org.geoserver.wfs] - 
73
Request: describeFeatureType
74
    service = WFS
75
    version = 1.0.0
76
    baseUrl = http://geoserver001.lifa.dk:8080/geoserver/
77
    typeName[0] = {Greg-Odense-Parker-Kursus}v_greg_linier
78
    outputFormat = XMLSCHEMA
79
2019-03-29 13:28:07,438 DEBUG [org.geoserver.security.filter.GeoServerSecurityContextPersistenceFilter$1] - SecurityContextHolder now cleared, as request processing completed
80
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
81
2019-03-29 13:28:07,454 INFO [org.geoserver.flow] - Control-flow inactive, there are no configured rules
82
2019-03-29 13:28:07,454 DEBUG [org.geoserver.wfs] - Locating FeatureSource uri:'Greg-Odense-Parker-Kursus' name:'v_greg_linier'
83
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'
84
2019-03-29 13:28:07,454 DEBUG [org.geoserver.wfs] - Transaction Update:[email protected]
85
2019-03-29 13:28:07,454 DEBUG [org.geoserver.wfs] - Preprocess to remember modification as a set of fids
86
2019-03-29 13:28:07,454 INFO [org.geoserver.gwc] - DataStoreChange: {Greg-Odense-Parker-Kursus}v_greg_linier PreUpdate
87
2019-03-29 13:28:07,469 INFO [org.geoserver.wfs] - 
88
Request: transaction
89
    service = WFS
90
    version = 1.0.0
91
    baseUrl = http://geoserver001.lifa.dk:8080/geoserver/
92
    group[0] = wfs:[email protected] (filter: [ v_greg_linier.null ], handle: null, inputFormat: <unset>, srsName: null, typeName: {Greg-Odense-Parker-Kursus}v_greg_linier)
93
    update[0]:
94
        property[0]:
95
            name = {Greg-Odense-Parker-Kursus}hoejde
96
            value = 9.88
97
        filter = [ v_greg_linier.null ]
98
        inputFormat = x-application/gml:3
99
        typeName = {Greg-Odense-Parker-Kursus}v_greg_linier
100
    releaseAction = ALL
101
2019-03-29 13:28:07,469 DEBUG [org.geoserver.security.filter.GeoServerSecurityContextPersistenceFilter$1] - SecurityContextHolder now cleared, as request processing completed
102
2019-03-29 13:28:07,469 INFO [org.geoserver.filters] - 10.10.1.51 "POST /geoserver/wfs" took 78ms
103

    
104

    
105
SQL Server profiler for same transaction
106
=========================================
107
2019-03-29 13:28:07,457		UPDATE "PARKER"."v_greg_linier" SET "hoejde" = 9.88  WHERE 0 = 1
108
2019-03-29 13:28:07,470		IF @@TRANCOUNT > 0 COMMIT TRAN
109
2019-03-29 13:28:07,473		IF @@TRANCOUNT > 0 ROLLBACK TRAN
110
2019-03-29 13:28:07,473		IF @@TRANCOUNT > 0 COMMIT TRAN set implicit_transactions off 
111

    
112

    
113

    
114

    
115

    
116

    
117
A working update , set field "hoejde" to: 6 in layer v_greg_flader .................................................................
118

    
119
Notice the id in the post request to geoserver:
120
.....<FeatureId xmlns="http://www.opengis.net/ogc" fid="v_greg_flader.7399"/></Filter></Update></Transaction>
121

    
122

    
123
Notice the corresponding sql statement in sqlserver
124
UPDATE "PARKER"."v_greg_flader" SET "hoejde" = 6  WHERE ("ID" = '7399')
125

    
126

    
127
Geoserver log for update transaction (set field hoejde til value 6 in v_greg_flader
128
2019-03-31 15:40:23,136 INFO [org.geoserver.filters] - 10.10.1.51 "POST /geoserver/wfs" "" "" "text/xml"  request-size: 956 body: 
129
<Transaction xmlns="http://www.opengis.net/wfs" xmlns:Greg-Odense-Parker-Kursus="Greg-Odense-Parker-Kursus" version="1.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" service="WFS" xmlns:gml="http://www.opengis.net/gml" xsi:schemaLocation="Greg-Odense-Parker-Kursus https://service-ok.lifa.dk/Authenticate.ashx?login=xxxx&amp;password=xxxx&amp;servicename=Greg-Odense-Parker-Kursus&amp;SERVICE=WFS&amp;REQUEST=DescribeFeatureType&amp;VERSION=1.0.0&amp;TYPENAME=Greg-Odense-Parker-Kursus:v_greg_flader"><Update xmlns="http://www.opengis.net/wfs" typeName="Greg-Odense-Parker-Kursus:v_greg_flader"><Property xmlns="http://www.opengis.net/wfs"><Name xmlns="http://www.opengis.net/wfs">Greg-Odense-Parker-Kursus:hoejde</Name><Value xmlns="http://www.opengis.net/wfs">6</Value></Property><Filter xmlns="http://www.opengis.net/ogc"><FeatureId xmlns="http://www.opengis.net/ogc" fid="v_greg_flader.7399"/></Filter></Update></Transaction>
130

    
131
2019-03-31 15:40:23,136 DEBUG [org.geoserver.security.IncludeQueryStringAntPathRequestMatcher] - Checking match of request : 'Path: /wfs, QueryString: null'; against '/web/**'
132
2019-03-31 15:40:23,136 DEBUG [org.geoserver.security.IncludeQueryStringAntPathRequestMatcher] - Checking match of request : 'Path: /wfs, QueryString: null'; against '/gwc/rest/web/**'
133
2019-03-31 15:40:23,136 DEBUG [org.geoserver.security.IncludeQueryStringAntPathRequestMatcher] - Checking match of request : 'Path: /wfs, QueryString: null'; against '/'
134
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'
135
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/'
136
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'
137
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/'
138
2019-03-31 15:40:23,136 DEBUG [org.geoserver.security.IncludeQueryStringAntPathRequestMatcher] - Checking match of request : 'Path: /wfs, QueryString: null'; against '/rest/**'
139
2019-03-31 15:40:23,136 DEBUG [org.geoserver.security.IncludeQueryStringAntPathRequestMatcher] - Checking match of request : 'Path: /wfs, QueryString: null'; against '/gwc/rest/**'
140
2019-03-31 15:40:23,136 DEBUG [org.geoserver.security.IncludeQueryStringAntPathRequestMatcher] - Checking match of request : 'Path: /wfs, QueryString: null'; against '/**'
141
2019-03-31 15:40:23,136 DEBUG [org.geoserver.security.IncludeQueryStringAntPathRequestMatcher] - Request matched by universal pattern '/**'
142
2019-03-31 15:40:23,136 DEBUG [org.geoserver.security.IncludeQueryStringAntPathRequestMatcher] - Matched Path: /wfs, QueryString: null with /**
143
2019-03-31 15:40:23,136 DEBUG [org.geoserver.security] - AuthenticationCache has no entry for basic, OdenseKommune:4464f1565c67b38e5165d33c00c02b89
144
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')
145
2019-03-31 15:40:23,136 DEBUG [org.geoserver.security.rememberme.GeoServerTokenBasedRememberMeServices] - Remember-me login not requested.
146
2019-03-31 15:40:23,136 DEBUG [org.geoserver.security] - AuthenticationCache adding new entry for basic, OdenseKommune:4464f1565c67b38e5165d33c00c02b89
147
2019-03-31 15:40:23,136 DEBUG [org.geoserver.security] - Cache entries #: 0
148
2019-03-31 15:40:23,136 DEBUG [org.geoserver.security] - AuthenticationCache added new entry for basic, OdenseKommune:4464f1565c67b38e5165d33c00c02b89
149
2019-03-31 15:40:23,136 DEBUG [org.geoserver.security] - Cache entries #: 1
150
2019-03-31 15:40:23,136 DEBUG [org.geoserver.gwc.controller.GwcWmtsRestUrlHandlerMapping] - Looking up handler method for path /wfs
151
2019-03-31 15:40:23,136 DEBUG [org.geoserver.gwc.controller.GwcWmtsRestUrlHandlerMapping] - Did not find handler method for [/wfs]
152
2019-03-31 15:40:23,136 TRACE [org.geoserver.ows.OWSHandlerMapping] - No handler mapping found for [/wfs]
153
2019-03-31 15:40:23,136 TRACE [org.geoserver.ows.OWSHandlerMapping] - No handler mapping found for [/wfs]
154
2019-03-31 15:40:23,136 TRACE [org.geoserver.ows.OWSHandlerMapping] - No handler mapping found for [/wfs]
155
2019-03-31 15:40:23,136 TRACE [org.geoserver.ows.OWSHandlerMapping] - No handler mapping found for [/wfs]
156
2019-03-31 15:40:23,136 DEBUG [org.geoserver.ows.OWSHandlerMapping] - Mapping [/wfs] to HandlerExecutionChain with handler [[email protected]] and 1 interceptor
157
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')
158
2019-03-31 15:40:23,136 DEBUG [org.vfny.geoserver.requests] - Charset detection phase 1. Inferred encoding: UTF-8
159
2019-03-31 15:40:23,136 DEBUG [org.vfny.geoserver.requests] - Invalid(?) XML declaration: <Trans.
160
2019-03-31 15:40:23,136 DEBUG [org.vfny.geoserver.requests] - Charset detection phase 2. Charset in XML declaration is `null`.
161
2019-03-31 15:40:23,136 DEBUG [org.vfny.geoserver.requests] - Trying to create reader basing on existing charset information: `UTF-8`.
162
2019-03-31 15:40:23,136 DEBUG [org.geoserver.ows] - Raw XML request: <Transaction xmlns="http://www.opengis.net/wfs" xmlns:Greg-Odense-Parker-Kursus="Greg-Odense-Parker-Kursus" version="1.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" service="WFS" xmlns:gml="http://www.opengis.net/gml" xsi:schemaLocation="Greg-Odense-Parker-Kursus https://service-ok.lifa.dk/Authenticate.ashx?login=xxxx&amp;password=xxxx&amp;servicename=Greg-Odense-Parker-Kursus&amp;SERVICE=WFS&amp;REQUEST=DescribeFeatureType&amp;VERSION=1.0.0&amp;TYPENAME=Greg-Odense-Parker-Kursus:v_greg_flader"><Update xmlns="http://www.opengis.net/wfs" typeName="Greg-Odense-Parker-Kursus:v_greg_flader"><Property xmlns="http://www.opengis.net/wfs"><Name xmlns="http://www.opengis.net/wfs">Greg-Odense-Parker-Kursus:hoejde</Name><Value xmlns="http://www.opengis.net/wfs">6</Value></Property><Filter xmlns="http://www.opengis.net/ogc"><FeatureId xmlns="http://www.opengis.net/ogc" fid="v_greg_flader.7399"/></Filter></Update></Transaction>                                                                    
163
2019-03-31 15:40:23,167 INFO [org.geoserver.wfs] - 
164
Request: getServiceInfo
165
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.
166
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" "" "" "" 
167
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/**'
168
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/**'
169
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 '/'
170
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'
171
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/'
172
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'
173
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/'
174
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/**'
175
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/**'
176
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 '/**'
177
2019-03-31 15:40:23,183 DEBUG [org.geoserver.security.IncludeQueryStringAntPathRequestMatcher] - Request matched by universal pattern '/**'
178
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 /**
179
2019-03-31 15:40:23,183 DEBUG [org.geoserver.security] - AuthenticationCache found an entry for basic, OdenseKommune:4464f1565c67b38e5165d33c00c02b89
180
2019-03-31 15:40:23,183 DEBUG [org.geoserver.gwc.controller.GwcWmtsRestUrlHandlerMapping] - Looking up handler method for path /Greg-Odense-Parker-Kursus/wfs
181
2019-03-31 15:40:23,183 DEBUG [org.geoserver.gwc.controller.GwcWmtsRestUrlHandlerMapping] - Did not find handler method for [/Greg-Odense-Parker-Kursus/wfs]
182
2019-03-31 15:40:23,183 TRACE [org.geoserver.ows.OWSHandlerMapping] - No handler mapping found for [/Greg-Odense-Parker-Kursus/wfs]
183
2019-03-31 15:40:23,183 TRACE [org.geoserver.ows.OWSHandlerMapping] - No handler mapping found for [/Greg-Odense-Parker-Kursus/wfs]
184
2019-03-31 15:40:23,183 TRACE [org.geoserver.ows.OWSHandlerMapping] - No handler mapping found for [/Greg-Odense-Parker-Kursus/wfs]
185
2019-03-31 15:40:23,183 TRACE [org.geoserver.ows.OWSHandlerMapping] - No handler mapping found for [/Greg-Odense-Parker-Kursus/wfs]
186
2019-03-31 15:40:23,183 DEBUG [org.geoserver.ows.OWSHandlerMapping] - Mapping [/Greg-Odense-Parker-Kursus/wfs] to HandlerExecutionChain with handler [[email protected]] and 1 interceptor
187
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]]
188
2019-03-31 15:40:23,183 INFO [org.geoserver.wfs] - 
189
Request: getServiceInfo
190
2019-03-31 15:40:23,183 INFO [org.geoserver.flow] - Control-flow inactive, there are no configured rules
191
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]]
192
2019-03-31 15:40:23,183 INFO [org.geoserver.wfs] - 
193
Request: describeFeatureType
194
    service = WFS
195
    version = 1.0.0
196
    baseUrl = http://geoserver001.lifa.dk:8080/geoserver/
197
    typeName[0] = {Greg-Odense-Parker-Kursus}v_greg_flader
198
    outputFormat = XMLSCHEMA
199
2019-03-31 15:40:23,183 DEBUG [org.geoserver.security.filter.GeoServerSecurityContextPersistenceFilter$1] - SecurityContextHolder now cleared, as request processing completed
200
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
201
2019-03-31 15:40:23,198 INFO [org.geoserver.flow] - Control-flow inactive, there are no configured rules
202
2019-03-31 15:40:23,198 DEBUG [org.geoserver.wfs] - Locating FeatureSource uri:'Greg-Odense-Parker-Kursus' name:'v_greg_flader'
203
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'
204
2019-03-31 15:40:23,198 DEBUG [org.geoserver.wfs] - Transaction Update:[email protected]
205
2019-03-31 15:40:23,198 DEBUG [org.geoserver.wfs] - Preprocess to remember modification as a set of fids
206
2019-03-31 15:40:23,198 INFO [org.geoserver.gwc] - DataStoreChange: {Greg-Odense-Parker-Kursus}v_greg_flader PreUpdate
207
2019-03-31 15:40:23,276 DEBUG [org.geoserver.wfs] - Post process update for boundary update and featureValidation
208
2019-03-31 15:40:23,276 INFO [org.geoserver.gwc] - DataStoreChange: {Greg-Odense-Parker-Kursus}v_greg_flader PostUpdate
209
2019-03-31 15:40:23,276 INFO [org.geoserver.wfs] - 
210
Request: transaction
211
    service = WFS
212
    version = 1.0.0
213
    baseUrl = http://geoserver001.lifa.dk:8080/geoserver/
214
    group[0] = wfs:[email protected] (filter: [ v_greg_flader.7399 ], handle: null, inputFormat: <unset>, srsName: null, typeName: {Greg-Odense-Parker-Kursus}v_greg_flader)
215
    update[0]:
216
        property[0]:
217
            name = {Greg-Odense-Parker-Kursus}hoejde
218
            value = 6
219
        filter = [ v_greg_flader.7399 ]
220
        inputFormat = x-application/gml:3
221
        typeName = {Greg-Odense-Parker-Kursus}v_greg_flader
222
    releaseAction = ALL
223
2019-03-31 15:40:23,276 DEBUG [org.geoserver.security.filter.GeoServerSecurityContextPersistenceFilter$1] - SecurityContextHolder now cleared, as request processing completed
224
2019-03-31 15:40:23,276 INFO [org.geoserver.filters] - 10.10.1.51 "POST /geoserver/wfs" took 140ms
225

    
226

    
227

    
228

    
229
SQL Server profiler for same transaction
230
=========================================
231
select 1
232
go
233
set implicit_transactions on 
234
go
235
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')
236
go
237
UPDATE "PARKER"."v_greg_flader" SET "hoejde" = 6  WHERE ("ID" = '7399')
238
go
239
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')
240
go
241
IF @@TRANCOUNT > 0 COMMIT TRAN
242
go
243
IF @@TRANCOUNT > 0 ROLLBACK TRAN
244
go
245
IF @@TRANCOUNT > 0 COMMIT TRAN set implicit_transactions off 
246
go