I would suggest that you also reach out to the servicemix project. Take a look at https://github.com/apache/servicemix-bundles/tree/master/poi-4.0.0 where there is active work.
Sent from my iPhone > On Dec 19, 2018, at 4:35 PM, Mills, Gary (GE Digital) <gary.l.mi...@ge.com> > wrote: > > Hello, I am trying to upgrade from org.apache.servicemix.buncles.poi.3.9_2 to > 4.0.0_1 (*thanks in advance) > > I inherited an application that used 3.9_2, simply to read xlsx spreadsheets > and update a database. > > I needed to write an app to read in a template, update the template with > message exchange data, then send the xlsx workbook to some destination. I > had it all working with 3.9_2, however, there is no workbook.close() method > in 3.9_2. So, I opted to upgrade to 4.0.0_1. On my journey I tried each > release up to 4.0.0_1 unsuccessfully. I then just settled on 4.0.0_1 to try > to get it working. > > I'm almost there, however, I cannot resolve alll the dependencies. > > Error executing command: Could not start bundle > mvn:com.ge.ip.infra/delta-fadec-prod/3.0.1-SNAPSHOT in feature(s) > fadec-application-1.0.0: Unresolved constraint in bundle delta-fadec-prod > [348]: Unable to resolve 348.0: missing requirement [348.0] > osgi.wiring.package; > (&(osgi.wiring.package=org.apache.poi.ss.usermodel)(version>=4.0.0)(!(version>=5.0.0))) > [caused by: Unable to resolve 319.0: missing requirement [319.0] > osgi.wiring.package; (osgi.wiring.package=org.apache.xml.security.signature)] > > I'm pretty close, stuck here... the bottom of the manifest for 4.0.0_1, the > rest starting at org.apache.xml.security.signature, the org.w3c.dom, etc... > > l.extensions;version="[4.0,5)",org.apache.poi.xssf.util;version="[4.0 > ,5)",org.apache.xml.security.signature,org.ietf.jgss,org.w3c.dom,org. > w3c.dom.events,org.w3c.dom.ls,org.xml.sax,org.xml.sax.ext,org.xml.sax > .helpers,junit.framework;resolution:=optional > > I've been at this for 3 days now, very frustrating, needing you expertise, > thank you. > > POM > <?xml version="1.0" encoding="UTF-8"?> > <project xmlns="http://maven.apache.org/POM/4.0.0"; > > xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"; > > xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 > http://maven.apache.org/maven-v4_0_0.xsd<http://maven.apache.org/POM/4.0.0%20http:/maven.apache.org/maven-v4_0_0.xsd>"> > > <modelVersion>4.0.0</modelVersion> > > <parent> > <groupId>com.ge.ip.infra</groupId> > <artifactId>ge.ip.infra.parent</artifactId> > <version>3.0.1-SNAPSHOT</version> > </parent> > > <artifactId>delta-fadec-prod</artifactId> > <packaging>bundle</packaging> > > <name>GE-IP Delta FADEC PROD ENV</name> > > <dependencies> > > <!-- IBM MQ Dependencies --> > <dependency> > <groupId>com.ibm.dhbcore</groupId> > <artifactId>dhbcore</artifactId> > <version>7.5.0.2</version> > </dependency> > <dependency> > <groupId>com.ibm.mq.jmqi</groupId> > <artifactId>jmqi</artifactId> > <version>7.5.0.2</version> > </dependency> > <dependency> > <groupId>com.ibm.mq</groupId> > <artifactId>mq</artifactId> > <version>7.5.0.2</version> > </dependency> > <dependency> > <groupId>com.ibm.mqjms</groupId> > <artifactId>mqjms</artifactId> > <version>7.5.0.2</version> > </dependency> > > <!-- Camel Spring Dependencies --> > <dependency> > <groupId>org.springframework</groupId> > <artifactId>spring-jdbc</artifactId> > </dependency> > <!-- C3P0 database management--> > <dependency> > <groupId>com.mchange</groupId> > <artifactId>c3p0</artifactId> > </dependency> > <!-- Java Apache POI Excel dependencies --> > <dependency> > <groupId>org.apache.servicemix.bundles</groupId> > <artifactId>org.apache.servicemix.bundles.poi</artifactId> > <version>4.0.0_1</version> <!-- 3.9_2, 3.14_1 --> > </dependency> > <dependency> > <groupId>org.apache.poi</groupId> > <artifactId>poi</artifactId> > <version>4.0.1</version> > </dependency> > <dependency> > <groupId>org.apache.poi</groupId> > <artifactId>poi-ooxml</artifactId> > <version>4.0.1</version> <!-- 3.9, 3.14--> > </dependency> > <dependency> > <groupId>org.apache.poi</groupId> > <artifactId>poi-ooxml-schemas</artifactId> > <version>4.0.1</version> > </dependency> > <dependency> > <groupId>org.apache.commons</groupId> > <artifactId>commons-collections4</artifactId> > <version>4.2</version> > </dependency> > <dependency> > <groupId>org.apache.poi</groupId> > <artifactId>ooxml-schemas</artifactId> > <version>1.4</version> > </dependency> > <dependency> > <groupId>org.apache.commons</groupId> > <artifactId>commons-math3</artifactId> > <version>3.6.1</version> > </dependency> > <dependency> > <groupId>commons-codec</groupId> > <artifactId>commons-codec</artifactId> > <version>1.11</version> > </dependency> > <dependency> > <groupId>org.apache.commons</groupId> > <artifactId>commons-compress</artifactId> > <version>1.18</version> > </dependency> > <dependency> > <groupId>org.apache.poi</groupId> > <artifactId>ooxml-security</artifactId> > <version>1.1</version> > </dependency> > <dependency> > <groupId>com.enterprisemath</groupId> > <artifactId>em-utils</artifactId> > <version>2.4.0</version> > </dependency> > <!-- <dependency> > <groupId>org.apache.poi</groupId> > <artifactId>poi</artifactId> > </dependency> --> > > <!-- MySQL dependencies --> > <dependency> > <groupId>mysql</groupId> > <artifactId>mysql-connector-java</artifactId> > </dependency> > <!-- Camel Dependencies --> > <dependency> > <groupId>org.apache.camel</groupId> > <artifactId>camel-core</artifactId> > </dependency> > <dependency> > <groupId>org.apache.camel</groupId> > <artifactId>camel-sql</artifactId> > </dependency> > <dependency> > <groupId>org.apache.camel</groupId> > <artifactId>camel-jms</artifactId> > </dependency> > <dependency> > <groupId>org.apache.camel</groupId> > <artifactId>camel-ftp</artifactId> > </dependency> > <dependency> > <groupId>org.apache.camel</groupId> > <artifactId>camel-blueprint</artifactId> > </dependency> > <dependency> > <groupId>org.apache.camel</groupId> > <artifactId>camel-csv</artifactId> > </dependency> > <dependency> > <groupId>org.apache.camel</groupId> > <artifactId>camel-xmlbeans</artifactId> > </dependency> > <dependency> > <groupId>org.apache.camel</groupId> > <artifactId>camel-velocity</artifactId> > </dependency> > <dependency> > <groupId>org.apache.camel</groupId> > <artifactId>camel-ognl</artifactId> > </dependency> > <dependency> > <groupId>commons-io</groupId> > <artifactId>commons-io</artifactId> > </dependency> > <dependency> > <groupId>joda-time</groupId> > <artifactId>joda-time</artifactId> > </dependency> > <dependency> > <groupId>org.apache.camel</groupId> > <artifactId>camel-jdbc</artifactId> > </dependency> > > <!-- logging --> > <dependency> > <groupId>org.slf4j</groupId> > <artifactId>slf4j-api</artifactId> > </dependency> > <dependency> > <groupId>org.slf4j</groupId> > <artifactId>slf4j-log4j12</artifactId> > </dependency> > <dependency> > <groupId>org.slf4j</groupId> > <artifactId>jcl-over-slf4j</artifactId> > </dependency> > <dependency> > <groupId>log4j</groupId> > <artifactId>log4j</artifactId> > </dependency> > > </dependencies> > <!-- Build definition --> > <build> > <defaultGoal>install</defaultGoal> > <plugins> > <plugin> > <groupId>org.codehaus.mojo</groupId> > <artifactId>build-helper-maven-plugin</artifactId> > <version>1.8</version> > <executions> > <execution> > <id>attach-artifacts</id> > <phase>package</phase> > <goals> > <goal>attach-artifact</goal> > </goals> > <configuration> > <artifacts> > <artifact> > <file>target/classes/features.xml</file> > <type>xml</type> > <classifier>features</classifier> > </artifact> > </artifacts> > </configuration> > </execution> > </executions> > </plugin> > <plugin> > <groupId>org.apache.maven.plugins</groupId> > <artifactId>maven-resources-plugin</artifactId> > <version>2.4.3</version> > <executions> > <execution> > <id>copy-resources</id> > <phase>validate</phase> > <goals> > <goal>copy-resources</goal> > </goals> > <configuration> > <outputDirectory>${basedir}/target</outputDirectory> > <resources> > <resource> > <directory>src/main/resources</directory> > <filtering>true</filtering> > </resource> > </resources> > </configuration> > </execution> > </executions> > </plugin> > <!-- to generate the MANIFEST-FILE of the bundle --> > <plugin> > <groupId>org.apache.felix</groupId> > <artifactId>maven-bundle-plugin</artifactId> > <version>${bundle-plugin-version}</version> > <extensions>true</extensions> > <configuration> > <instructions> > <Bundle-SymbolicName>${project.artifactId}</Bundle-SymbolicName> > <Private-Package>com.ge.ip.infra.fadec.*</Private-Package> > <Import-Package> > org.springframework.jdbc, > org.springframework.jdbc.core, > * > </Import-Package> > </instructions> > </configuration> > </plugin> > </plugins> > </build> > </project> > > FEATURES.XML > > <?xml version="1.0" encoding="UTF-8"?> > <features xmlns="http://karaf.apache.org/xmlns/features/v1.0.0";> > <feature name="fadec-application" version="1.0.0" description="Delta FADEC > Route and dependencies"> > <feature>camel-core</feature> > <feature>camel-blueprint</feature> > <feature>camel-csv</feature> > <feature>camel-sql</feature> > <feature>camel-jdbc</feature> > <feature>camel-velocity</feature> > <feature>camel-xmlbeans</feature> > > <bundle > start-level="60">mvn:org.apache.servicemix.bundles/org.apache.servicemix.bundles.dom4j/1.6.1_5</bundle> > <bundle > start-level="61">wrap:mvn:org.apache.poi/poi-ooxml-schemas/4.0.1$DynamicImport-package=*</bundle> > <!-- 3.9, 3.14 $DynamicImport-package=*--> > <bundle > start-level="61">wrap:mvn:org.apache.commons/commons-collections4/4.2</bundle> > <bundle > start-level="62">wrap:mvn:org.apache.commons/commons-compress/1.18</bundle> > <bundle > start-level="63">wrap:mvn:org.apache.commons/commons-math3/3.6.1</bundle> > <bundle > start-level="64">wrap:mvn:org.apache.poi/ooxml-security/1.1</bundle> > > <bundle > start-level="65">mvn:org.apache.servicemix.bundles/org.apache.servicemix.bundles.poi/4.0.0_1</bundle> > <!-- 3.9_2 3.13_1 3.14--> > > > <bundle>mvn:com.ibm.msg.client.osgi/osgi-jms/7.5.0.2</bundle> > <bundle>mvn:com.ibm.msg.client.osgi/osgi-wmq-prereq/7.5.0.2</bundle> > <bundle>mvn:com.ibm.msg.client.osgi/osgi-nls/7.5.0.2</bundle> > <bundle>mvn:com.ibm.msg.client.osgi/osgi-wmq-nls/7.5.0.2</bundle> > <bundle>mvn:com.ibm.msg.client.osgi/osgi-wmq/7.5.0.2</bundle> > > <bundle>mvn:com.ibm.msg.client.osgi/osgi-commonservices-j2se/7.5.0.2</bundle> > <bundle>mvn:com.ibm.msg.client.osgi/jms-prereq/7.5.0.2</bundle> > <bundle>mvn:com.ibm.mq.osgi/osgi-directip/7.5.0.2</bundle> > > <bundle > start-level="80">wrap:mvn:com.enterprisemath/em-utils/2.4.0</bundle> > <bundle > start-level="80">wrap:mvn:mysql/mysql-connector-java/5.1.45</bundle> > <bundle > start-level="84">wrap:mvn:com.mchange/mchange-commons-java/0.2.11</bundle> > <bundle > start-level="85">wrap:mvn:com.mchange/c3p0/0.9.5.2$Bundle-SymbolicName=c3p0-0.9.5.2&Import-package=*;resolution:=optional;version=0</bundle> > <bundle > start-level="85">wrap:mvn:org.springframework/spring-jdbc/4.0.4.RELEASE$Import-package=com.mysql.jdbc;resolution:=optional;version=0,javax.sql;resolution:=optional;version=0,org.apache.commons.logging;resolution:=optional;version=0,org.springframework.util;resolution:=0;version=0</bundle> > > <bundle > start-level="90">mvn:com.ge.ip.infra/delta-fadec-prod/3.0.1-SNAPSHOT</bundle> > </feature> > </features> > > I'm ready to just give up and go back to 3.9_2 however, I fear resource > issues is I do not close the workbook when done. > > Gary Mills > Sent from Mail<https://go.microsoft.com/fwlink/?LinkId=550986> for Windows 10 >
