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&password=xxxx&servicename=Greg-Odense-Parker-Kursus&SERVICE=WFS&REQUEST=DescribeFeatureType&VERSION=1.0.0&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 [org.geoserver.ows.Dispatcher@1aeed65b] 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&password=xxxx&servicename=Greg-Odense-Parker-Kursus&SERVICE=WFS&REQUEST=DescribeFeatureType&VERSION=1.0.0&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 [org.geoserver.ows.Dispatcher@1aeed65b] 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:org.geoserver.wfs.request.Update$WFS11@29743818
|
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:update=net.opengis.wfs.impl.UpdateElementTypeImpl@2dbccefe (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&password=xxxx&servicename=Greg-Odense-Parker-Kursus&SERVICE=WFS&REQUEST=DescribeFeatureType&VERSION=1.0.0&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 [org.geoserver.ows.Dispatcher@1aeed65b] 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&password=xxxx&servicename=Greg-Odense-Parker-Kursus&SERVICE=WFS&REQUEST=DescribeFeatureType&VERSION=1.0.0&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 [org.geoserver.ows.Dispatcher@1aeed65b] 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:org.geoserver.wfs.request.Update$WFS11@43a679e7
|
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:update=net.opengis.wfs.impl.UpdateElementTypeImpl@207a63ee (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
|