Hi Andrea,
I have just got back to this after a long hiatus. I should explain what
we are trying to do in more detail:
Our application renders maps from business intelligence tools using an
underlying map server. Geoserver is one of these. As part of a large
overhaul of the system a few years back we decided to use the H2
database version 1.4.196 to store our layers for performance reasons and
because the support for h2gis was available in Geoserver 2.8. This also
improves the performance of rendering maps because the Geoserver now
uses the H2 database in our product for the ephemeral layers we generate
rather than having to send the layer information to it.
We add a workspace with the details of our map layers to the Geoserver
map folder under workspaces. For all this to work we use h2gis version
1.3.2 in both our application and in the geoserver which we deploy with
our application. We also deploy another h2gis jar that has the
org.h2gis.geoserver.H2GISDataStoreFactoryInitializer.class in it.
According to the Github site https://github.com/orbisgis/h2gis-geoserver
it is supposed to be compatible with Geoserver 2.15 but it seems to work
fine with Geoserver 2.8.
The question is: can I get all this to work with Geoserver 2.23 or 2.24?
Since there are issues with the latest h2gis, can we make the version we
are currently using (1.3.2) work or are there some basic
incompatibilities that render our current version of h2gis, H2 and
supporting classes useless?
Any assistance gratefully received.
Regards,
Chris Mugdan
On 01/03/2023 12:07 pm, Andrea Aime wrote:
The latest H2GIS is unfortunately incompatible with GeoServer: it uses
H2 2.x native geometry support,
while GeoServer ships with H2 1.x, and depends on it in a large
variety of places.
H2 developers made it very difficult for us to upgrade: the used the
same package names for the two versions,
meaning they cannot coexist, and made the binary format of the
databases incompatible, and without automatic
upgrade. One would have to manually perform a dump to SQL and a
restore, which works for alphanumeric
databases, but won't work for spatialized ones... meaning a custom
tool would have to be written in order to perform upgrades.
We have ideas on how to perform migrations, but it would be a lot of
days of development... lack of funding is what
is keeping us at bay. If anyone here is interested to contribute to
this endeavour please contact me privately.
Best regards
Andrea
On Wed, Mar 1, 2023 at 11:14 AM mark <mc.pr...@gmail.com> wrote:
Op 28-02-2023 om 09:06 schreef Jody Garnett:
> I was not aware of that datastore; a quick web search shows it
is active
> (https://github.com/orbisgis/h2gis-geotools
> <https://github.com/orbisgis/h2gis-geotools>) and mtaintained by
orbisgis.
The H2-GIS datastore was recently added to GeoTools as an unsupported
module: https://github.com/geotools/geotools/pull/4043
https://github.com/geotools/geotools/tree/main/modules/unsupported/jdbc-h2gis
As it requires Java 11 it would only be available for the `main`
branch
(29-SNAPSHOT / 2.23-SNAPSHOT)
the geoserver extension lives at
https://github.com/orbisgis/h2gis-geoserver but it seems to be
sleeping/stalled/dead
Mark
_______________________________________________
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
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
--
Regards,
Andrea Aime
==GeoServer Professional Services from the experts!
Visit http://bit.ly/gs-services-us <http://bit.ly/gs-services-us>for
more information.==Ing. Andrea Aime @geowolfTechnical Lead
GeoSolutions Groupphone: +39 0584 962313
fax: +39 0584 1660272
mob: +39 339 8844549
https://www.geosolutionsgroup.com/ <https://www.geosolutionsgroup.com/>
http://twitter.com/geosolutions_it <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
_______________________________________________
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
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
_______________________________________________
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
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
