[Geoserver-devel] GeoServer 2.15.0 - excel output - missing dependency

Dear GeoServer-List,

I have just installed the recent GeoServer 2.15.0 with the „Excel-WFS Output Format“-extension.

When trying to do a getFeature-request with the „excel2007“-outputformat, I got this exception (the „excel“-outputformat worked fine):

Caused by: java.lang.ClassNotFoundException: org.apache.commons.compress.archivers.zip.ZipFile

at org.apache.catalina.loader.WebappClassLoaderBase.loadClass(WebappClassLoaderBase.java:1285)

at org.apache.catalina.loader.WebappClassLoaderBase.loadClass(WebappClassLoaderBase.java:1119)

It seems that the „commons-compress“-library is missing.

After downloading it (from https://commons.apache.org/proper/commons-compress/download_compress.cgi) and adding it to the „WEB-INF\lib“-folder, it is working.

Maybe you have to add the dependency to the Excel WFS Output Format-extension.

I am running the GeoServer in a Windows environment using Tomcat 9 and Oracle JDK 8.

Best regards,

Paul

Hi Paul,
thanks for the report. I’d first open a ticket so that it does not get lost:
https://osgeo-org.atlassian.net/projects/GEOS/summary

In case you’re up to make a fix, I believe it would have to be done around here:
https://github.com/geoserver/geoserver/blob/master/src/release/ext-excel.xml

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.

Hi Andrea,

I’ve created the issue: https://osgeo-org.atlassian.net/browse/GEOS-9159

Unfortunately I am not that experienced with the development. So maybe someone else can fix it.

Regards,
Paul

···

Hi Paul,

thanks for the report. I’d first open a ticket so that it does not get lost:

https://osgeo-org.atlassian.net/projects/GEOS/summary

In case you’re up to make a fix, I believe it would have to be done around here:

https://github.com/geoserver/geoserver/blob/master/src/release/ext-excel.xml

Cheers

Andrea

On Wed, Mar 20, 2019 at 4:49 PM Biskup, Paul <Paul.Biskup@…3654…> wrote:

Dear GeoServer-List,

I have just installed the recent GeoServer 2.15.0 with the „Excel-WFS Output Format“-extension.

When trying to do a getFeature-request with the „excel2007“-outputformat, I got this exception (the „excel“-outputformat worked fine):

Caused by: java.lang.ClassNotFoundException: org.apache.commons.compress.archivers.zip.ZipFile

at org.apache.catalina.loader.WebappClassLoaderBase.loadClass(WebappClassLoaderBase.java:1285)

at org.apache.catalina.loader.WebappClassLoaderBase.loadClass(WebappClassLoaderBase.java:1119)

It seems that the „commons-compress“-library is missing.

After downloading it (from https://commons.apache.org/proper/commons-compress/download_compress.cgi) and adding it to the „WEB-INF\lib“-folder, it is working.

Maybe you have to add the dependency to the Excel WFS Output Format-extension.

I am running the GeoServer in a Windows environment using Tomcat 9 and Oracle JDK 8.

Best regards,

Paul


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.

Hi,

it seems, that the same problem is back in the newest stable GeoServer 2.15.2.

I got the same exception when trying to do a getFeature-excel2007-request.

Adding the „commons-compress“-library fixes it.

Should I reopen the issue (https://osgeo-org.atlassian.net/browse/GEOS-9159)?

I can’t tell if the fix from the issue has ever worked, because I haven’t tested it since then.

Regards,
Paul

···

Von: Biskup, Paul
Gesendet: Donnerstag, 21. März 2019 09:57
An: andrea.aime@…1268…
Cc: geoserver-devel@lists.sourceforge.net
Betreff: AW: [Geoserver-devel] GeoServer 2.15.0 - excel output - missing dependency

Hi Andrea,

I’ve created the issue: https://osgeo-org.atlassian.net/browse/GEOS-9159

Unfortunately I am not that experienced with the development. So maybe someone else can fix it.

Regards,
Paul

Von: Andrea Aime <andrea.aime@…1268…>
Gesendet: Mittwoch, 20. März 2019 17:16
An: Biskup, Paul <Paul.Biskup@…3654…>
Cc: geoserver-devel@lists.sourceforge.net
Betreff: Re: [Geoserver-devel] GeoServer 2.15.0 - excel output - missing dependency

Hi Paul,

thanks for the report. I’d first open a ticket so that it does not get lost:

https://osgeo-org.atlassian.net/projects/GEOS/summary

In case you’re up to make a fix, I believe it would have to be done around here:

https://github.com/geoserver/geoserver/blob/master/src/release/ext-excel.xml

Cheers

Andrea

On Wed, Mar 20, 2019 at 4:49 PM Biskup, Paul <Paul.Biskup@…3654…> wrote:

Dear GeoServer-List,

I have just installed the recent GeoServer 2.15.0 with the „Excel-WFS Output Format“-extension.

When trying to do a getFeature-request with the „excel2007“-outputformat, I got this exception (the „excel“-outputformat worked fine):

Caused by: java.lang.ClassNotFoundException: org.apache.commons.compress.archivers.zip.ZipFile

at org.apache.catalina.loader.WebappClassLoaderBase.loadClass(WebappClassLoaderBase.java:1285)

at org.apache.catalina.loader.WebappClassLoaderBase.loadClass(WebappClassLoaderBase.java:1119)

It seems that the „commons-compress“-library is missing.

After downloading it (from https://commons.apache.org/proper/commons-compress/download_compress.cgi) and adding it to the „WEB-INF\lib“-folder, it is working.

Maybe you have to add the dependency to the Excel WFS Output Format-extension.

I am running the GeoServer in a Windows environment using Tomcat 9 and Oracle JDK 8.

Best regards,

Paul


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.

Hi Paul,
as far as I can see, the ticket got fixed only on master (2.16-SNAPSHOT) but the change did not get
backported to 2.15.x. Technically it’s still fixed, only not in the series you want to use (we cannot force
volunteer to perform fixes where you need them, only where they want to/have time to do them) :slight_smile:

The 2.16.x nightly build extension has the jar:
https://build.geoserver.org/geoserver/master/ext-latest/geoserver-2.16-SNAPSHOT-excel-plugin.zip

I’d add a comment in the ticket though, maybe someone will run a backport of that change

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.

If you can confirm it is working correctly on master, I’ll backport it.

Brad

From: Andrea Aime andrea.aime@anonymised.com
Sent: Monday, 12 August 2019 5:16 PM
To: Biskup, Paul Paul.Biskup@anonymised.com
Cc: geoserver-devel@anonymised.comge.net
Subject: Re: [Geoserver-devel] GeoServer 2.15.0 - excel output - missing dependency

Hi Paul,

as far as I can see, the ticket got fixed only on master (2.16-SNAPSHOT) but the change did not get

backported to 2.15.x. Technically it’s still fixed, only not in the series you want to use (we cannot force

volunteer to perform fixes where you need them, only where they want to/have time to do them) :slight_smile:

The 2.16.x nightly build extension has the jar:

https://build.geoserver.org/geoserver/master/ext-latest/geoserver-2.16-SNAPSHOT-excel-plugin.zip

I’d add a comment in the ticket though, maybe someone will run a backport of that change

Cheers

Andrea

On Mon, Aug 12, 2019 at 8:21 AM Biskup, Paul <Paul.Biskup@anonymised.com…> wrote:

Hi,

it seems, that the same problem is back in the newest stable GeoServer 2.15.2.

I got the same exception when trying to do a getFeature-excel2007-request.

Adding the „commons-compress“-library fixes it.

Should I reopen the issue (https://osgeo-org.atlassian.net/browse/GEOS-9159)?

I can’t tell if the fix from the issue has ever worked, because I haven’t tested it since then.

Regards,
Paul

Von: Biskup, Paul
Gesendet: Donnerstag, 21. März 2019 09:57
An: andrea.aime@anonymised.com
Cc: geoserver-devel@lists.sourceforge.net
Betreff: AW: [Geoserver-devel] GeoServer 2.15.0 - excel output - missing dependency

Hi Andrea,

I’ve created the issue: https://osgeo-org.atlassian.net/browse/GEOS-9159

Unfortunately I am not that experienced with the development. So maybe someone else can fix it.

Regards,
Paul

Von: Andrea Aime <andrea.aime@anonymised.com>
Gesendet: Mittwoch, 20. März 2019 17:16
An: Biskup, Paul <Paul.Biskup@anonymised.com>
Cc: geoserver-devel@anonymised.comt
Betreff: Re: [Geoserver-devel] GeoServer 2.15.0 - excel output - missing dependency

Hi Paul,

thanks for the report. I’d first open a ticket so that it does not get lost:

https://osgeo-org.atlassian.net/projects/GEOS/summary

In case you’re up to make a fix, I believe it would have to be done around here:

https://github.com/geoserver/geoserver/blob/master/src/release/ext-excel.xml

Cheers

Andrea

On Wed, Mar 20, 2019 at 4:49 PM Biskup, Paul <Paul.Biskup@anonymised.com4…> wrote:

Dear GeoServer-List,

I have just installed the recent GeoServer 2.15.0 with the „Excel-WFS Output Format“-extension.

When trying to do a getFeature-request with the „excel2007“-outputformat, I got this exception (the „excel“-outputformat worked fine):

Caused by: java.lang.ClassNotFoundException: org.apache.commons.compress.archivers.zip.ZipFile

at org.apache.catalina.loader.WebappClassLoaderBase.loadClass(WebappClassLoaderBase.java:1285)

at org.apache.catalina.loader.WebappClassLoaderBase.loadClass(WebappClassLoaderBase.java:1119)

It seems that the „commons-compress“-library is missing.

After downloading it (from https://commons.apache.org/proper/commons-compress/download_compress.cgi) and adding it to the „WEB-INF\lib“-folder, it is working.

Maybe you have to add the dependency to the Excel WFS Output Format-extension.

I am running the GeoServer in a Windows environment using Tomcat 9 and Oracle JDK 8.

Best regards,

Paul


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.


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.