Hi list.

I've been looking into the limitations of using the field types "bit" (boolean) 
and "uniqueidentifier" (GUID) in SQL Server (2016), and publishing them via 
Geoserver (2.16.2).

We have had those limitations when displaying and editing them for a while in 
earlier versions, but it looks somewhat better in 2.16.2.

I'm using QGIS 3.10.3 as my testing client.


It seems that editing uniqueidentifiers (GUIDs) works, at least sometimes.
When I use Oracle JVM 1.8 for my Tomcat installation, it seems to work. It 
fails however with a java null pointer exception when I'm instead using 
AdoptOpenJDK JVM v 11.0.


Editing "bit" (boolean) type values still don't work.

QGIS displays the value 1 as "true" (and 0 as "false").

But when it's edited, the entered raw value is sent in the transaction to 
Geoserver. I've tried both "false" and "0" (without quotes).

However, regardless of whether QGIS sends "0" or "false" to Geoserver, it 
always tries to update the SQL Server table field with the value "false". I.e. 
it actively interprets "0" as "false".
But this is unfortunately syntactically wrong. Bit values in SQL Server only 
have values 0 and 1.


Can anyone verify these findings ?



Med venlig hilsen

Lars I. Nielsen, LIFA A/S
GIS-kons., FME+Python Certified Professional
Geoinformatik
[cid:[email protected]]
T
6313 6800
@
[email protected]
D
6313 6849
W
www.lifa.dk<http://www.lifa.dk>
M
CVR
20937289

[cid:[email protected]]<https://www.linkedin.com/company/lifa-a-s/>
Følg os på LinkedIn og læs de seneste nyheder fra LIFA A/S
_______________________________________________
Geoserver-users mailing list

Please make sure you read the following two resources before posting to this 
list:
- Earning your support instead of buying it, but Ian Turton: 
http://www.ianturton.com/talks/foss4g.html#/
- The GeoServer user list posting guidelines: 
http://geoserver.org/comm/userlist-guidelines.html

If you want to request a feature or an improvement, also see this: 
https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer


[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users

Reply via email to