SQL Server plugin/extension

GeoServer GeoServer User
1

Hello all,

We unfortunately still have some of our spatial data in SQL Server and probably will for a long time to come, so I just wanted to check: the SQL Server data type “geography” is not supported by GeoServer’s SQL Server extension and we should instead use “geometry”?

Not complaining or asking for changes, simply checking I’m up to speed on this :slight_smile:

Thanks,
Sam

2

Hi Samuli,
that seems to be the case… in the whole codebase for the SQL Server
plugin I only see one mention of
“geography”.

SQL Server is one of those commercial database plugins that gets any change
done only when there is
sponsoring on the table, hard to imagine an open source developer taking a
Sunday off to work on it.
That said, both funding and code contributions are more than welcomed.
While waiting for someone to step up and implement comprehensive geography
support,
using “geometry” seems the way to go, indeed.

Cheers,

Andrea Aime

==
GeoServer Professional Services from the experts!

Visit GeoSolutions Enterprise Support Services for more information.

Ing. Andrea Aime
@geowolf
Technical Lead

GeoSolutions Group
phone: +39 0584 962313

fax: +39 0584 1660272

mob: +39 339 8844549

http://twitter.com/geosolutions_it

Con riferimento alla normativa sul trattamento dei dati personali (Reg. UE
2016/679 - Regolamento generale sulla protezione dei dati “GDPR”), si
precisa che ogni circostanza inerente alla presente email (il suo
contenuto, gli eventuali allegati, etc.) è un dato la cui conoscenza è
riservata al/i solo/i destinatario/i indicati dallo scrivente. Se il
messaggio Le è giunto per errore, è tenuta/o a cancellarlo, ogni altra
operazione è illecita. Le sarei comunque grato se potesse darmene notizia.

This email is intended only for the person or entity to which it is
addressed and may contain information that is privileged, confidential or
otherwise protected from disclosure. We remind that - as provided by
European Regulation 2016/679 “GDPR” - copying, dissemination or use of this
e-mail or the information herein by anyone other than the intended
recipient is prohibited. If you have received this email by mistake, please
notify us immediately by telephone or e-mail

On Tue, Sep 17, 2024 at 10:16 AM Samuli Neuvonen via OSGeo Discourse <
noreply@discourse.osgeo.org> wrote:

asneuvon https://discourse.osgeo.org/u/asneuvon
September 17

Hello all,

We unfortunately still have some of our spatial data in SQL Server and
probably will for a long time to come, so I just wanted to check: the SQL
Server data type “geography” is not supported by GeoServer’s SQL Server
extension and we should instead use “geometry”?

Not complaining or asking for changes, simply checking I’m up to speed on
this [image: :slight_smile:]

Thanks,
Sam

Visit Topic
https://discourse.osgeo.org/t/sql-server-plugin-extension/50931/1 or
reply to this email to respond.

To unsubscribe from these emails, click here
https://discourse.osgeo.org/email/unsubscribe/34b0ce17a7d481c554f663647db24b231b2c1df2b64318f09e9d55d61ef8b42d
.

3

Hi all you SQL Server extension fans and other curious minds!

SQL Server 2022 is not listed among the supported versions in the extension’s documentation. Does this mean the list hasn’t been updated yet, or does the extension not work with SQL Server 2022? Has @asneuvon or anyone else tested it?

Best regards,
Ismo Lahtinen

4

If you are interested in it then you are the best person to test it, provided that nothing much has changed then I would expect it to work fine, though you might need to update the JDBC jar used.

So try it out and let us know how it goes, if you need to make any changes then a pull request would be great and if you don’t then you can update the docs to reflect that too

Ian