Transforming the below feature and trying to insert into a mssqlserver database (on both mssql2012 and mssql2016) fails on the "kruinlijn" geometry (the polygon seems to be fine) (same feature inserts just fine on postgresql/postgis and oracle) GML
<?xml version="1.0" encoding="UTF-8"?>
<gml:FeatureCollection xmlns:xlink="http://www.w3.org/1999/xlink" xmlns:imgeo-s="http://www.geostandaarden.nl/imgeo/2.1/simple/gml31" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:gml="http://www.opengis.net/gml" xsi:schemaLocation="http://www.geostandaarden.nl/imgeo/2.1/simple/gml31 imgeo-simple-2.1-gml31.xsd http://www.opengis.net/gml http://schemas.opengis.net/gml/3.1.1/base/gml.xsd">
<gml:featureMember>
<imgeo-s:BegroeidTerreindeel gml:id="b64a9a08a-031a-11e6-b420-2bdcc4ab5d7f">
<imgeo-s:objectBeginTijd>2016-03-08</imgeo-s:objectBeginTijd>
<imgeo-s:identificatie.namespace>NL.IMGeo</imgeo-s:identificatie.namespace>
<imgeo-s:identificatie.lokaalID>G1699.2d8ccd18a08f7da5e05332a1e90adfb4</imgeo-s:identificatie.lokaalID>
<imgeo-s:tijdstipRegistratie>2016-03-08T18:21:50.000</imgeo-s:tijdstipRegistratie>
<imgeo-s:LV-publicatiedatum>2016-04-13T09:22:32.000</imgeo-s:LV-publicatiedatum>
<imgeo-s:bronhouder>G1699</imgeo-s:bronhouder>
<imgeo-s:inOnderzoek>false</imgeo-s:inOnderzoek>
<imgeo-s:relatieveHoogteligging>0</imgeo-s:relatieveHoogteligging>
<imgeo-s:bgt-status>bestaand</imgeo-s:bgt-status>
<imgeo-s:opTalud>true</imgeo-s:opTalud>
<imgeo-s:bgt-fysiekVoorkomen>transitie</imgeo-s:bgt-fysiekVoorkomen>
<imgeo-s:geometrie2d>
<gml:Polygon xmlns:gml="http://www.opengis.net/gml">
<gml:exterior>
<gml:Ring>
<gml:curveMember>
<gml:Curve>
<gml:segments>
<gml:Arc>
<gml:posList>226080.978 573035.586 226076.665 573034.943 226072.730 573033.058</gml:posList>
</gml:Arc>
<gml:Arc>
<gml:posList>226072.730 573033.058 226069.510 573029.236 226068.078 573024.444</gml:posList>
</gml:Arc>
<gml:Arc>
<gml:posList>226068.078 573024.444 226068.616 573019.172 226071.718 573014.878</gml:posList>
</gml:Arc>
<gml:Arc>
<gml:posList>226071.718 573014.878 226075.490 573012.795 226079.749 573012.142</gml:posList>
</gml:Arc>
<gml:Arc>
<gml:posList>226079.749 573012.142 226085.837 573013.825 226090.984 573017.490</gml:posList>
</gml:Arc>
<gml:Arc>
<gml:posList>226090.984 573017.490 226094.031 573021.315 226095.465 573025.994</gml:posList>
</gml:Arc>
<gml:Arc>
<gml:posList>226095.465 573025.994 226094.392 573030.204 226091.361 573033.311</gml:posList>
</gml:Arc>
<gml:Arc>
<gml:posList>226091.361 573033.311 226086.317 573035.133 226080.978 573035.586</gml:posList>
</gml:Arc>
</gml:segments>
</gml:Curve>
</gml:curveMember>
</gml:Ring>
</gml:exterior>
<gml:interior>
<gml:Ring>
<gml:curveMember>
<gml:Curve>
<gml:segments>
<gml:LineStringSegment>
<gml:posList>226093.699 573025.755 226091.283 573022.253 226089.041 573019.709 226086.547 573017.670 226083.399 573015.975 226079.950 573015.373 226076.607 573016.123 226073.981 573018.566 226072.144 573021.142 226070.924 573024.154 226070.825 573026.592 226072.272 573028.907 226074.565 573030.865 226077.310 573032.397 226080.768 573033.096 226084.670 573033.273 226087.464 573032.955</gml:posList>
</gml:LineStringSegment>
<gml:Arc>
<gml:posList>226087.464 573032.955 226091.885 573030.486 226093.699 573025.755</gml:posList>
</gml:Arc>
</gml:segments>
</gml:Curve>
</gml:curveMember>
</gml:Ring>
</gml:interior>
</gml:Polygon>
</imgeo-s:geometrie2d>
<imgeo-s:kruinlijn>
<gml:Curve xmlns:gml="http://www.opengis.net/gml">
<gml:segments>
<gml:Arc>
<gml:posList>226087.464 573032.955 226091.885 573030.486 226093.699 573025.755</gml:posList>
</gml:Arc>
<gml:LineStringSegment>
<gml:posList>226093.699 573025.755 226091.283 573022.253 226089.041 573019.709 226086.547 573017.670 226083.399 573015.975 226079.950 573015.373 226076.607 573016.123 226073.981 573018.566 226072.144 573021.142 226070.924 573024.154 226070.825 573026.592 226072.272 573028.907 226074.565 573030.865 226077.310 573032.397 226080.768 573033.096 226084.670 573033.273 226087.464 573032.955</gml:posList>
</gml:LineStringSegment>
</gml:segments>
</gml:Curve>
</imgeo-s:kruinlijn>
</imgeo-s:BegroeidTerreindeel>
</gml:featureMember>
</gml:FeatureCollection>
inspected values
SimpleFeatureImpl:begroeid_terreindeel=[SimpleFeatureImpl.Attribute: identif<identif id=NL.IMGeo:G1699.2d8ccd18a08f7da5e05332a1e90adfb4>=NL.IMGeo:G1699.2d8ccd18a08f7da5e05332a1e90adfb4,
SimpleFeatureImpl.Attribute: dat_beg_geldh<dat_beg_geldh id=NL.IMGeo:G1699.2d8ccd18a08f7da5e05332a1e90adfb4>=2016-03-08,
SimpleFeatureImpl.Attribute: datum_einde_geldh<datum_einde_geldh id=NL.IMGeo:G1699.2d8ccd18a08f7da5e05332a1e90adfb4>=null, SimpleFeatureImpl.Attribute: relve_hoogteligging<relve_hoogteligging id=NL.IMGeo:G1699.2d8ccd18a08f7da5e05332a1e90adfb4>=0,
SimpleFeatureImpl.Attribute: bgt_status<bgt_status id=NL.IMGeo:G1699.2d8ccd18a08f7da5e05332a1e90adfb4>=bestaand, SimpleFeatureImpl.Attribute: plus_status<plus_status id=NL.IMGeo:G1699.2d8ccd18a08f7da5e05332a1e90adfb4>=null,
SimpleFeatureImpl.Attribute: optalud<optalud id=NL.IMGeo:G1699.2d8ccd18a08f7da5e05332a1e90adfb4>=true,
SimpleFeatureImpl.Attribute: bgt_fysiekvoorkomen<bgt_fysiekvoorkomen id=NL.IMGeo:G1699.2d8ccd18a08f7da5e05332a1e90adfb4>=transitie,
SimpleFeatureImpl.Attribute: plus_fysiekvoorkomen<plus_fysiekvoorkomen id=NL.IMGeo:G1699.2d8ccd18a08f7da5e05332a1e90adfb4>=null,
SimpleFeatureImpl.Attribute: lod0geom<lod0geom id=NL.IMGeo:G1699.2d8ccd18a08f7da5e05332a1e90adfb4>=null,
SimpleFeatureImpl.Attribute: geom2d<geom2d id=NL.IMGeo:G1699.2d8ccd18a08f7da5e05332a1e90adfb4>=POLYGON ((226080.978 573035.586, 226080.9584592332 573035.5860130274, 226079.04553787297 573035.4606335373, 226077.1653471276 573035.0866403449, 226076.665 573034.943, 226075.350057582 573034.4704325777, 226073.63072934357 573033.6225537211, 226072.73 573033.058, 226071.632131333 573032.0840771241, 226070.5723684335 573030.8756491398, 226069.67940345587 573029.5392326084, 226069.51 573029.236, 226068.96851527848 573028.0976939874, 226068.45186739514 573026.5756984024, 226068.13829979434 573024.9992876195, 226068.078 573024.444, 226068.03434745313 573024.1463217663, 226067.94683131977 573022.8110835963, 226068.03434745313 573021.4758454263, 226068.29539842784 573020.1634535516, 226068.616 573019.172, 226068.7255175894 573018.8963633609, 226069.3173454797 573017.6962551189, 226070.06075575942 573016.5836630103, 226070.9430284726 573015.5776237944, 226071.718 573014.878, 226071.97147558103 573014.6781586906, 226073.30817022375 573013.7850078848, 226074.75000883226 573013.07397177, 226075.49 573012.795, 226076.2723211482 573012.5572163711, 226077.84905998578 573012.2435835161, 226079.45324690634 573012.1384395503, 226079.749 573012.142, 226080.3940893366 573012.2152416417, 226082.72776795385 573012.6794391802, 226084.9808916899 573013.444271628, 226085.837 573013.825, 226087.11490897293 573014.4966524902, 226089.09330617555 573015.8185752383, 226090.88223237311 573017.3874214077, 226090.984 573017.49, 226091.70320097913 573018.157295617, 226092.83411712333 573019.446858327, 226093.787036413 573020.8730028274, 226094.031 573021.315, 226094.54565413485 573022.4113273901, 226095.0969901294 573024.0355108555, 226095.4316108848 573025.7177629942, 226095.465 573025.994, 226095.46563467997 573026.0972048417, 226095.3938455276 573027.1924956498, 226095.17970640285 573028.2690457286, 226094.82688128547 573029.3084350076, 226094.392 573030.204, 226094.34140711106 573030.2928792482, 226093.7315904773 573031.2055343364, 226093.00786551595 573032.0307844906, 226092.1826153617 573032.754509452, 226091.361 573033.311, 226089.78003956252 573034.0460263934, 226087.23840126116 573034.9087963393, 226086.317 573035.133, 226084.60589295198 573035.4324347993, 226081.92755758204 573035.6079821739, 226080.978 573035.586), (226093.699 573025.755, 226091.283 573022.253, 226089.041 573019.709, 226086.547 573017.67, 226083.399 573015.975, 226079.95 573015.373, 226076.607 573016.123, 226073.981 573018.566, 226072.144 573021.142, 226070.924 573024.154, 226070.825 573026.592, 226072.272 573028.907, 226074.565 573030.865, 226077.31 573032.397, 226080.768 573033.096, 226084.67 573033.273, 226087.464 573032.955, 226088.19066015017 573032.7987618296, 226089.11141015726 573032.4862093184, 226089.98348673127 573032.0561487448, 226090.79196840018 573031.5159385644, 226091.52302181852 573030.8748219234, 226091.885 573030.486, 226092.16413845957 573030.1437685051, 226092.70434863988 573029.3352868361, 226093.1344092135 573028.4632102621, 226093.44696172475 573027.5424602551, 226093.63665831354 573026.5887911028, 226093.699 573025.755)),
SimpleFeatureImpl.Attribute: kruinlijn<kruinlijn id=NL.IMGeo:G1699.2d8ccd18a08f7da5e05332a1e90adfb4>=COMPOUNDCURVE (CIRCULARSTRING (226087.464 573032.955, 226091.885 573030.486, 226093.699 573025.755), (226093.699 573025.755, 226091.283 573022.253, 226089.041 573019.709, 226086.547 573017.67, 226083.399 573015.975, 226079.95 573015.373, 226076.607 573016.123, 226073.981 573018.566, 226072.144 573021.142, 226070.924 573024.154, 226070.825 573026.592, 226072.272 573028.907, 226074.565 573030.865, 226077.31 573032.397, 226080.768 573033.096, 226084.67 573033.273, 226087.464 573032.955)),
SimpleFeatureImpl.Attribute: bijwerkdatum<bijwerkdatum id=NL.IMGeo:G1699.2d8ccd18a08f7da5e05332a1e90adfb4>=null]
SQL Inserting new feature: INSERT INTO "dbo"."begroeid_terreindeel" ( "dat_beg_geldh","datum_einde_geldh","relve_hoogteligging","bgt_status","plus_status","optalud","bgt_fysiekvoorkomen","plus_fysiekvoorkomen","geom2d","lod0geom","kruinlijn","bijwerkdatum","identif" ) VALUES ( '2016-03-08 01:00:00',null,0,'bestaand',null,'true','transitie',null,geometry::STGeomFromText('POLYGON ((226080.978 573035.586, 226080.9584592332 573035.5860130274, 226079.04553787297 573035.4606335373, 226077.1653471276 573035.0866403449, 226076.665 573034.943, 226075.350057582 573034.4704325777, 226073.63072934357 573033.6225537211, 226072.73 573033.058, 226071.632131333 573032.0840771241, 226070.5723684335 573030.8756491398, 226069.67940345587 573029.5392326084, 226069.51 573029.236, 226068.96851527848 573028.0976939874, 226068.45186739514 573026.5756984024, 226068.13829979434 573024.9992876195, 226068.078 573024.444, 226068.03434745313 573024.1463217663, 226067.94683131977 573022.8110835963, 226068.03434745313 573021.4758454263, 226068.29539842784 573020.1634535516, 226068.616 573019.172, 226068.7255175894 573018.8963633609, 226069.3173454797 573017.6962551189, 226070.06075575942 573016.5836630103, 226070.9430284726 573015.5776237944, 226071.718 573014.878, 226071.97147558103 573014.6781586906, 226073.30817022375 573013.7850078848, 226074.75000883226 573013.07397177, 226075.49 573012.795, 226076.2723211482 573012.5572163711, 226077.84905998578 573012.2435835161, 226079.45324690634 573012.1384395503, 226079.749 573012.142, 226080.3940893366 573012.2152416417, 226082.72776795385 573012.6794391802, 226084.9808916899 573013.444271628, 226085.837 573013.825, 226087.11490897293 573014.4966524902, 226089.09330617555 573015.8185752383, 226090.88223237311 573017.3874214077, 226090.984 573017.49, 226091.70320097913 573018.157295617, 226092.83411712333 573019.446858327, 226093.787036413 573020.8730028274, 226094.031 573021.315, 226094.54565413485 573022.4113273901, 226095.0969901294 573024.0355108555, 226095.4316108848 573025.7177629942, 226095.465 573025.994, 226095.46563467997 573026.0972048417, 226095.3938455276 573027.1924956498, 226095.17970640285 573028.2690457286, 226094.82688128547 573029.3084350076, 226094.392 573030.204, 226094.34140711106 573030.2928792482, 226093.7315904773 573031.2055343364, 226093.00786551595 573032.0307844906, 226092.1826153617 573032.754509452, 226091.361 573033.311, 226089.78003956252 573034.0460263934, 226087.23840126116 573034.9087963393, 226086.317 573035.133, 226084.60589295198 573035.4324347993, 226081.92755758204 573035.6079821739, 226080.978 573035.586), (226093.699 573025.755, 226091.283 573022.253, 226089.041 573019.709, 226086.547 573017.67, 226083.399 573015.975, 226079.95 573015.373, 226076.607 573016.123, 226073.981 573018.566, 226072.144 573021.142, 226070.924 573024.154, 226070.825 573026.592, 226072.272 573028.907, 226074.565 573030.865, 226077.31 573032.397, 226080.768 573033.096, 226084.67 573033.273, 226087.464 573032.955, 226088.19066015017 573032.7987618296, 226089.11141015726 573032.4862093184, 226089.98348673127 573032.0561487448, 226090.79196840018 573031.5159385644, 226091.52302181852 573030.8748219234, 226091.885 573030.486, 226092.16413845957 573030.1437685051, 226092.70434863988 573029.3352868361, 226093.1344092135 573028.4632102621, 226093.44696172475 573027.5424602551, 226093.63665831354 573026.5887911028, 226093.699 573025.755))',28992),null,geometry::STGeomFromText('LINEARRING (226087.464 573032.955, 226088.19066015017 573032.7987618296, 226089.11141015726 573032.4862093184, 226089.98348673127 573032.0561487448, 226090.79196840018 573031.5159385644, 226091.52302181852 573030.8748219234, 226091.885 573030.486, 226092.16413845957 573030.1437685051, 226092.70434863988 573029.3352868361, 226093.1344092135 573028.4632102621, 226093.44696172475 573027.5424602551, 226093.63665831354 573026.5887911028, 226093.699 573025.755, 226091.283 573022.253, 226089.041 573019.709, 226086.547 573017.67, 226083.399 573015.975, 226079.95 573015.373, 226076.607 573016.123, 226073.981 573018.566, 226072.144 573021.142, 226070.924 573024.154, 226070.825 573026.592, 226072.272 573028.907, 226074.565 573030.865, 226077.31 573032.397, 226080.768 573033.096, 226084.67 573033.273, 226087.464 573032.955)',28992),null,'NL.IMGeo:G1699.2d8ccd18a08f7da5e05332a1e90adfb4') Stacktrace
|