[Geoserver-devel] spatialite on geoserver is not working

GeoServer GeoServer Developer
,
1

Greetings,

Would someone provide some guidance on how to get Spatialite extension to
work with Geoserver

I have tried this first
1.
I have download geoserver (tries 2.14.4, 2.14.5, 2.15, 2.16 and 2.17) and
followed this instruction from this URL site
https://docs.geoserver.org/latest/en/user/community/spatialite/index.html#spatialite-install
However, I can't not find the spatialite extension .jar file anywhere base
on the above link.

I have compiled and build GEOS and PROJ successfully. It doesn't help
because I can not find the Spatialite .jar file anywhere

2.
So, I continue searching and found these spatialite repo
https://repo.boundlessgeo.com/main/org/geoserver/community/gs-spatialite/

I have tried different combination between geoserver and gs-spatialite and
nothing has work so far.
Meaning, the geoserver will able to startup by it self but as soon as I
added any of the gs-spatialite .jar version into the
.../webapps/geoserver/WEB-INF/lib then the geoserver will not able to
startup.

I have look into the log file and there are errors that indicated the some
Java bean errors, it seems missing some of it dependencies that is why the
geoserver can not start up. I don't what those dependencies are.

What are those? I can compile java codes and build the jar files if I can
find the source code.
Where can I gather them and build the correct .jar file for the geoserver ?
If you have any suggestion please share

Any help will be greatly appreciate it.

Thanks,

--
Sent from: http://osgeo-org.1560.x6.nabble.com/GeoServer-Dev-f3819232.html

2

Hi,
in addition to what Jody already said, the spatialite module has been in an “abandoned” state for
several years now, it used to be supported but we had to move it down to unsupported due to lack
of a maintainer.

However, you can read spatialite files using the OGR data store plugin. That’s still a community module,
but has seen recent activity and it’s thus more likely to work properly

Cheers
Andrea

···

Regards, Andrea Aime == GeoServer Professional Services from the experts! Visit http://goo.gl/it488V for more information. == Ing. Andrea Aime @geowolf Technical Lead GeoSolutions S.A.S. Via di Montramito 3/A 55054 Massarosa (LU) phone: +39 0584 962313 fax: +39 0584 1660272 mob: +39 339 8844549 http://www.geo-solutions.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.

3

Thank you so much for point out the reason why spatialite is no longer available. One of our team lead found this link

https://docs.geoserver.org/latest/en/user/community/spatialite/index.html#spatialite-install

and decided for us to try out the features and I have been assigned to get it working. Perhaps, the link can be update with a

Note of Warning such as:

“ These are the instruction and examples how to implement spatialite with Geoserver. However, you will have to build the gs-spatialie.jar yourself “

Anyone know how to build the spatialie extension or help be build it. Once, it is working and I know how to do it I can be a maintainer.

I need help with some direction.

Are these the right path to take:

···
  1. Build the following package separately with the native libraries:

SQLite 3.7.2

SpatiaLite 4.3

GEOS 3.8

PROJ 7

  1. Then build java jar files from them?

Any guidance and advice will be appreciate it.

Thanks,

Yoom

From: Andrea Aime <andrea.aime@…1268…>
Sent: Saturday, March 7, 2020 6:21 AM
To: Yoom Nguyen <ynguyen@…5882…>
Cc: Geoserver-devel geoserver-devel@lists.sourceforge.net
Subject: Re: [Geoserver-devel] spatialite on geoserver is not working

Hi,

in addition to what Jody already said, the spatialite module has been in an “abandoned” state for

several years now, it used to be supported but we had to move it down to unsupported due to lack

of a maintainer.

However, you can read spatialite files using the OGR data store plugin. That’s still a community module,

but has seen recent activity and it’s thus more likely to work properly

Cheers

Andrea

On Fri, Mar 6, 2020 at 6:27 PM yoom <ynguyen@…5882…> wrote:

Greetings,

Would someone provide some guidance on how to get Spatialite extension to
work with Geoserver

I have tried this first
1.
I have download geoserver (tries 2.14.4, 2.14.5, 2.15, 2.16 and 2.17) and
followed this instruction from this URL site
https://docs.geoserver.org/latest/en/user/community/spatialite/index.html#spatialite-install
However, I can’t not find the spatialite extension .jar file anywhere base
on the above link.

I have compiled and build GEOS and PROJ successfully. It doesn’t help
because I can not find the Spatialite .jar file anywhere

So, I continue searching and found these spatialite repo
https://repo.boundlessgeo.com/main/org/geoserver/community/gs-spatialite/

I have tried different combination between geoserver and gs-spatialite and
nothing has work so far.
Meaning, the geoserver will able to startup by it self but as soon as I
added any of the gs-spatialite .jar version into the
…/webapps/geoserver/WEB-INF/lib then the geoserver will not able to
startup.

I have look into the log file and there are errors that indicated the some
Java bean errors, it seems missing some of it dependencies that is why the
geoserver can not start up. I don’t what those dependencies are.

What are those? I can compile java codes and build the jar files if I can
find the source code.
Where can I gather them and build the correct .jar file for the geoserver ?
If you have any suggestion please share

Any help will be greatly appreciate it.

Thanks,

–
Sent from: http://osgeo-org.1560.x6.nabble.com/GeoServer-Dev-f3819232.html

Geoserver-devel mailing list
Geoserver-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-devel

–

Regards, Andrea Aime == GeoServer Professional Services from the experts! Visit http://goo.gl/it488V for more information. == Ing. Andrea Aime @geowolf Technical Lead GeoSolutions S.A.S. Via di Montramito 3/A 55054 Massarosa (LU) phone: +39 0584 962313 fax: +39 0584 1660272 mob: +39 339 8844549 http://www.geo-solutions.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.