Rob Egelmeer (
https://osgeo-org.atlassian.net/secure/ViewProfile.jspa?accountId=5c98f3ffa063736c5f65a922
) *created* an issue
GeoServer (
https://osgeo-org.atlassian.net/browse/GEOS?atlOrigin=eyJpIjoiOTFlZDI2MDE1ZmZjNDliZjg0YTViZjRjMDRjOWE1NjAiLCJwIjoiaiJ9
) / Bug (
https://osgeo-org.atlassian.net/browse/GEOS-10791?atlOrigin=eyJpIjoiOTFlZDI2MDE1ZmZjNDliZjg0YTViZjRjMDRjOWE1NjAiLCJwIjoiaiJ9
) GEOS-10791 (
https://osgeo-org.atlassian.net/browse/GEOS-10791?atlOrigin=eyJpIjoiOTFlZDI2MDE1ZmZjNDliZjg0YTViZjRjMDRjOWE1NjAiLCJwIjoiaiJ9
) SQL server error when executing a WFST insert request in a table with a
GENERATED ALWAYS column (
https://osgeo-org.atlassian.net/browse/GEOS-10791?atlOrigin=eyJpIjoiOTFlZDI2MDE1ZmZjNDliZjg0YTViZjRjMDRjOWE1NjAiLCJwIjoiaiJ9
)
Issue Type: Bug Affects Versions: 2.21.2 Assignee: Unassigned Attachments:
WFST_insert_error.txt Components: SQLServer Created: 13/Dec/22 4:40 PM
Priority: Medium Reporter: Rob Egelmeer (
https://osgeo-org.atlassian.net/secure/ViewProfile.jspa?accountId=5c98f3ffa063736c5f65a922
)
Preforming a WFST insert request in a SQL server table with temporal tables
does not work. The insert query tries to insert a value into a generated always
column.
In the attachment there is a part of the geotools logging with the insert query
and the SQL server exception. This is the WFST request I made:
<wfs:Transaction
xmlns:muteren="muteren" service="WFS" version="1.0.0"
xmlns:wfs=" http://www.opengis.net/wfs"; ( http://www.opengis.net/wfs%22 )
xmlns:ogc=" http://www.opengis.net/ogc"; ( http://www.opengis.net/ogc%22 )
xmlns:gml=" http://www.opengis.net/gml"; ( http://www.opengis.net/gml%22 )
xmlns:xsi=" http://www.w3.org/2001/XMLSchema-instance"; (
http://www.w3.org/2001/XMLSchema-instance%22 ) xsi:schemalocation="
http://www.opengis.net/wfs ( http://www.opengis.net/wfs )
http://schemas.opengis.net/wfs/1.0.0/WFS-transaction.xsd"; (
http://schemas.opengis.net/wfs/1.0.0/WFS-transaction.xsd%22 ) >
[wfs:Insert|wfs:Insert]
[muteren:invoer_od_geografische_locatie|muteren:invoer_od_geografische_locatie]
<referentie>test</referentie>
<maand>Januari</maand>
<jaar>3333</jaar>
<historisch>N</historisch>
<gebruiker>robe</gebruiker>
<created_at>2022-12-13</created_at>
<updated_at>2022-12-13</updated_at>
<geom>
<gml:Polygon srsName=" http://www.opengis.net/gml/srs/epsg.xml#28992"; (
http://www.opengis.net/gml/srs/epsg.xml#28992%22 ) >
[gml:outerBoundaryIs|gml:outerBoundaryIs]
[gml:LinearRing|gml:LinearRing]
<gml:coordinates decimal="." cs="," ts=" ">98283.68,508144.8 98206.4,508003.68
98428.16,508107.84 98283.68,508144.8</gml:coordinates>
</gml:LinearRing>
</gml:outerBoundaryIs>
</gml:Polygon>
</geom>
</muteren:invoer_od_geografische_locatie>
</wfs:Insert>
</wfs:Transaction>
More informatie about the temporal tables in SQL server can be found on this
page:
[Temporal Tables - SQL Server | Microsoft
Learn|https://learn.microsoft.com/en-us/sql/relational-databases/tables/temporal-tables?view=sql-server-ver16&viewFallbackFrom=sql-server-ver16%C2%A0]
(
https://osgeo-org.atlassian.net/browse/GEOS-10791#add-comment?atlOrigin=eyJpIjoiOTFlZDI2MDE1ZmZjNDliZjg0YTViZjRjMDRjOWE1NjAiLCJwIjoiaiJ9
) Add Comment (
https://osgeo-org.atlassian.net/browse/GEOS-10791#add-comment?atlOrigin=eyJpIjoiOTFlZDI2MDE1ZmZjNDliZjg0YTViZjRjMDRjOWE1NjAiLCJwIjoiaiJ9
)
Get Jira notifications on your phone! Download the Jira Cloud app for Android (
https://play.google.com/store/apps/details?id=com.atlassian.android.jira.core&referrer=utm_source%3DNotificationLink%26utm_medium%3DEmail
) or iOS (
https://itunes.apple.com/app/apple-store/id1006972087?pt=696495&ct=EmailNotificationLink&mt=8
) This message was sent by Atlassian Jira (v1001.0.0-SNAPSHOT#100212-
sha1:99773b8 )
_______________________________________________
Geoserver-devel mailing list
Geoserver-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-devel
